Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
2 Days
The Excel - Advanced Functions course will help you to build well-structured, complex formulas to work more efficiently with data. It will explore Logical, Lookup, Reference and Statistical functions and how they are used.
Participants should be able to:
Level - Advanced
Working with long documents in Microsoft Word can be a challenge. We will show you how to format documents quickly and consistently, how to add numbered headings, create a table of contents, an index, table or figure captions and cross-references.
Level - Advanced
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.
Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
Level - Fundamental
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.