WORKSHOP DETAILS
Microsoft Excel (Advanced) |
|---|
In this advanced Microsoft Excel training, you will deepen your expertise by mastering a range of complex formulas and functions. You'll learn to effectively use Lookup and reference functions alongside array formulas for sophisticated calculations. The course covers text functions, logical and conditional functions for enhanced decision-making, and advanced techniques for creating and customising PivotTables and Pivot Charts. Additionally, you'll gain skills in data consolidation and management using Excel's Power Query, culminating in the creation of a comprehensive dashboard to showcase your proficiency.
Each booking is for one individual workshop that run for a five-hour duration on the selected delivery date of your choosing. Delivery commences at 9.30 - 3pm with half hour allocated for lunch. Light refreshments are provided with a warm welcoming environment that is sure to enhance your learning experience. Face to face delivery is located is at Tai Tokerau Trades Training, 17 Hannah Street, Whangārei. Online Delivery also available. |
Course Content |
|---|
Microsoft Excel Advanced Advanced Formulas and Functions: -Utilise Lookup and reference functions (VLOOPKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, and OFFSET) for dynamic data retrieval -Array formulas and functions (Single Array, Multi Array, SUMPRODUCT, TRANSPOSE). -Text Functions (LEFT, RIGHT, MID, TEXTJOIN) -Master logical and conditional functions (IF, AND, OR, and nested IF statements) for decision-making processes Pivot Tables and Pivot Charts: -Creating and customizing PivotTables -Grouping, filtering, and sorting data in PivotTables -Using calculated fields and items -Creating Pivot Charts and Slicers for interactive data visualization
Data Consolidation and Management -Consolidating data from multiple sources. -Using Excel's Power Query to clean and transform data. -Data modelling and relationships. Consolidate your learning to create a dashboard in Excel. |
Further Information
Upcoming Dates 2024
Choose one of the following options:
September
Friday 27th
October
Wednesday 2nd (Online Delivery) FULL
Thursday 17th
November
Thursday 7th
December
Thursday 5th
Booking Information
Once an online booking form has been submitted you will receive and email confirmation of the booking request and payment information.
For group booking [minimum of 5 attendees] alternative date requests can be submitted via the enquiry form on the Elevate Training - Aotearoa home page.
Booking Full Terms and Conditions can be found at the bottom of this Course Details page.
Online Booking Option
Microsoft Excel (Advanced) is also offered through an Online delivery via MS Teams.
On Demand Learning Option
Delivery Information coming soon....
Need More Information - Submit a Microsoft Excel Enquiry
