You know the basics but feel limited in Excel? Advance your skills with this comprehensive intermediate Excel training!
Want to run this event in-house? Enquire about running this event in-house
Interested in attending? Have a suggestion about running this event near you?
Register your interest now
Description
MS Excel Essentials for Professionals - Intermediate
Module Overview
Take your Excel skills to the next level with our comprehensive training program. This course is designed to equip you with advanced techniques for data visualization, manipulation, and collaboration using Microsoft Office Excel. Throughout the program, you'll dive deep into creating dynamic charts and tables to visually represent your data with clarity and precision. Discover time-saving formatting options and validation features that streamline your workflow and ensure data accuracy. Gain expertise in creating complex formulas that leverage built-in functions for advanced data analysis.
Learning Objectives
-
Utilize Excel Tables effectively for dynamic reporting purposes
-
Efficiently manipulate and visualize data to gain insights
-
Apply intermediate-level formulas and functions for dynamic data analysis
-
Create professional-quality charts for data presentation
-
Utilize Pivot Tables and Pivot Charts to construct basic Excel Dashboards
-
Perform WHAT-IF analysis for basic planning and budgeting scenarios
-
Implement simple macros for task automation to streamline workflow
-
Generate reports with minimal future maintenance requirements, ensuring long term usability
Who Should Attend
Participants should have basics Excel introduction or equivalent skills. Participants must be able to:
-
Create, open, save, format, and print a worksheet
-
Use formulas and the SUM function
-
Copy, move and delete values and formulas
Course Outline
Module 1: Formula Basics
Module 2: Reference
Module 3: Text Formulas
Module 4: Date & Time
Module 5: Logical Function
Module 6: Conditional Formatting
Module 7: Working with Functions
Module 8: Analyzing Data
Module 9: VLOOKUP & HLOOKUP FUNDAMENTALS
Module 10: Advanced LOOKUP Techniques
Module 11: Working with Charts
Module 12: Using Table Features
Module 13: Formatting and Data Validation
Download the course outline here
