Data Analysis & Dashboard Reporting in Excel Informa Middle East
السعر: $3,500 - $5,500
تدريب إفتراضي أونلاين. المحاضرات قد تكون فردية أو ضمن مجموعة.
  • مدة الدورة التدريبية: 4 Days

تفاصيل الدورة

The VisiCalc row-and-column-based layout introduced in 1978 is what we know as spreadsheets today. These have evolved to become powerful business tools that are widely used across business functions. Step into any of the various departments in a business and you will find some business processes that are supported using Excel. ExcelŐs current advanced functionality together with its formatting and visual design capabilities creates a basis for its extensive use as a data analysis and business reporting tool.

Module One Introducing dashboards Defining a dashboard Defining a report User requirements Dashboard dimensions and filters Dashboard design principles Best practice in data modelling Excel functions and dashboards Ranges and tables Module Two Table design principles Custom number formatting Adding and customising sparklines Using conditional formatting Pivot tables Module Three Charting and visualisation techniques Top and bottom displays Variance displays Progress bars Bullet graphs Module Four Leverage macros to automate reporting Utilising form controls in dashboards Check boxes List boxes Option buttons

تحديث بتاريخ 27 January, 2019

نبذة عن معهد Informa Middle East

Informa Middle East, is part of Informa, a multinational publicly listed publishing and events company.
The Middle East office was previously known as IIR Middle East, and has been established in Dubai since 1993. Informa Middle East has grown to be the largest event organiser in the region and with over 300 staff, the office runs over 450 training courses and over 40 conferences regionally on an annual basis.
The company also incorporates Informa Global Exhibitions which organises around 130 trade and consumer exhibitions in over 38 cities across the globe.  Arab Health, Cityscape, Middle East Electricity and The Bride Show are some of the flag ship events.
Aside from the public training courses, conferences and exhibitions, Informa Middle East also provides in-house training to companies as well as manages events on behalf of corporate clients. Some of the past clients include NBAD, Microsoft, Etisalat, STC, Mobily, and ADNOC.  
http://www.informa-mea.com/ عرض الجميع دورات Informa Middle East
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Excel ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو