Course Overview on Microsoft Excel: Advanced
This course trains learners in Advanced skills for Microsoft Excel 365. Learners who have completed our Excel Fundamentals and Intermediate courses who wish to master Excel's most powerful and complex tools will learn vital skills for managing and analysing spreadsheet data in a professional setting.
Learners will gain essential Excel skills such as linking and referencing external data sources, Lookup functions and advanced Excel formulas. They will also learn about workbook security and automation, as well as creating Sparklines to map and forecast data .
Learners can take this course as a 1-day class led by an expert instructor, either online or in a classroom.
The material covered in this course assumes knowledge of the Excel basic skills learned in our Excel Fundamentals course as well as a grasp of Excel formulas and intermediate data analysis tools covered by our Intermediate Excel Training course. All three of these courses are available as a discounted bundle in our Excel Bootcamp. Professionals who want to gain further Excel skills centered on data analysis and high-level usage of Excel Power-Query functions should sign-up for our Excel Data Analysis course.
What You Will Learn
- Learn to work with data from multiple worksheets and workbooks at once.
- Learn to use Lookup Functions and Formula Auditing to analyse data and adjust according to evolving business needs.
- Learn to enact security measures to protect data from malicious access attempts.
- Learn to automate Workbook Functionality, allowing efficient scaling-up according to one's business' needs.
- Learn to create Sparklines to map and forecast data.
Delivery Methods
| Delivery Method | Duration | ||
|---|---|---|---|
| 1 Day | Get a Quote | ||
| 1 Day | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
Splashworks (Pty) Ltd
Yes, highly recommend your company.
United Exports South Africa (Pty) Ltd
The course will surely make working with excel must better and easier
Gauteng Provincial Treasury
The facilitator was very patient, ensured everyone was on the same page and ensured participation from everyone.
United Exports South Africa (Pty) Ltd
The excel sessions were very practical and easy to follow.
Gauteng Provincial Treasury
Examples were so friendly user and the trainer was explaining very well
World Vision International
the training was very beneficial to our work
Audience
This course is tailored for professionals who need to leverage advanced Excel 365 capabilities to drive efficiency and make informed decisions for their business. Professionals who wish to use Excel to automate repetitive Excel tasks en-masse, collaborate with a team to work with data referenced from a shared source, or use advanced data analysis tools to map or forecast data trends will find the knowledge gained in this course essential to their success.
Pre-Requisites
Course Outline / Curriculum
Lesson 1:Working with Multiple Worksheets and Workbooks
-
- Use Links and External References
- Use 3-D References
- Consolidate Data
Lesson 2: Using Lookup Functions and Formula Auditing
-
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
Lesson 3: Sharing and Protecting Workbooks
-
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
Lesson 4: Automating Workbook Functionality
-
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Lesson 5: Creating Sparklines and Mapping Data
-
- Create Sparklines
- Map Data
Lesson 6: Forecasting Data
-
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
Schedule Dates and Booking
There are currently no scheduled dates.