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 - Intermediate
Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable.
Level - Intermediate
A vast majority of projects that suffer cost and time overruns do so because they lack professional scheduling. This course focuses on key tools of Microsoft Project needed by schedulers and planners; the Work Breakdown Structure (WBS) and the Critical Path Method (CPM).
Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.