[Course] Advanced Excel Part 2 – Advanced Analysis & Productivity

Advanced Excel Part 2 – Advanced Analysis & Productivity

Advanced Excel Part 2 is a practical one-day course for experienced Excel users who want to move beyond the core advanced skills covered in Advanced Excel Part 1.

The course focuses on advanced analysis, productivity and problem-solving tools that can help employees work more efficiently with business spreadsheets and data.

Delegates work with Advanced Filters, Goal Seek, Scenario Manager, macros, conditional formatting, Sparklines and other useful Excel productivity features.

Advanced Excel Part 2 can be attended as a standalone course by experienced Excel users or combined with Advanced Excel Part 1 as a comprehensive two-day Advanced Excel programme.

Download Advanced Excel Part 2 Course – Table of Contents

Advanced Excel Part 2 Training South Africa

Many experienced Excel users know how to create formulas and reports but still spend considerable time manually analysing, formatting and manipulating spreadsheets.

Advanced Excel Part 2 introduces additional Excel tools that allow users to investigate information, test different business scenarios, automate repetitive tasks and improve the presentation of spreadsheet information.

The emphasis is on practical workplace application. Delegates learn how the different Excel features can be used in real business situations rather than simply learning individual commands.

What You Will Learn in Advanced Excel Part 2

Advanced Filters

Advanced Filters provide greater control over extracting and analysing information from Excel datasets. Delegates learn how to apply advanced filtering criteria to identify the information they require from larger sets of business data.

Goal Seek

Goal Seek allows Excel users to work backwards from a required result. Instead of changing figures repeatedly to determine the required input, delegates learn how Excel can calculate the value necessary to achieve a specific outcome.

This can be particularly useful for budgets, targets, pricing, forecasts and other business calculations.

Scenario Manager

Scenario Manager allows users to create and compare different sets of values within a spreadsheet.

Delegates learn how to use scenarios to investigate different possible business outcomes without repeatedly changing the original spreadsheet data.

Simple Excel Macros

Advanced Excel Part 2 introduces delegates to simple Excel macros as a first step towards spreadsheet automation.

Delegates learn how to:

• Record a macro
• Stop recording a macro
• Run or play a recorded macro
• Delete a macro

The purpose is not to turn delegates into VBA programmers. It is to demonstrate how repetitive Excel processes can begin to be automated using Excel’s built-in macro functionality.

Advanced Conditional Formatting

Conditional Formatting allows important information, exceptions and trends to be highlighted automatically.

Delegates work with Conditional Formatting and learn how formulas can be incorporated into formatting rules to provide greater control over how spreadsheet information is displayed.

Hyperlinks and Comments

Advanced Excel Part 2 also covers practical spreadsheet features such as hyperlinks and comments.

These tools can make larger workbooks easier to navigate and allow additional information or explanations to be incorporated into spreadsheets.

Additional Excel Formulae

Delegates continue developing their ability to work with Excel formulas and apply appropriate functions to practical spreadsheet problems.

The emphasis is on understanding how formulas can be combined with other Excel features to improve analysis and productivity.

Sparklines

Sparklines provide compact visual representations of trends directly inside worksheet cells.

Delegates learn how Sparklines can be used to make trends and changes in business information easier to identify without creating a full chart.

Download the table of contents Advanced Excel Part 2 Course – Table of Contents

Practical Business Applications

The skills covered in Advanced Excel Part 2 can be applied across finance, administration, operations, sales, human resources, project environments and management reporting.

After completing the course, delegates should be better equipped to:

• Extract specific information from larger datasets
• Work backwards from business targets using Goal Seek
• Compare alternative business scenarios
• Automate simple repetitive Excel tasks
• Highlight exceptions and important information automatically
• Consolidate information across multiple worksheets
• Improve workbook navigation
• Present trends using Sparklines
• Apply Excel tools more efficiently to workplace problems

Who Should Attend Advanced Excel Part 2?

Advanced Excel Part 2 is designed for existing Excel users who are already comfortable working with formulas, spreadsheets and business data.

It is particularly suitable for employees working in:

• Finance and accounting
• Management reporting
• Administration
• Sales and marketing
• Human resources
• Operations
• Business analysis
• Project environments
• Management and executive support

Delegates who have not yet covered advanced referencing, VLOOKUP, data validation and PivotTables should consider completing Advanced Excel Part 1 first.

Advanced Excel Part 1 and Part 2

Companies requiring broader Advanced Excel development can combine Advanced Excel Part 1 and Advanced Excel Part 2 into a two-day programme.

Part 1 establishes the core advanced skills, including advanced referencing, data validation, formulas, PivotTables and PivotCharts.

Part 2 then extends those skills into more advanced analysis and productivity techniques, including Advanced Filters, Goal Seek, Scenario Manager, macros and advanced Conditional Formatting.

Organisations can therefore select Part 1 only, Part 2 for suitably experienced employees, or combine both courses.

Advanced Excel Part 2 and AI

AI tools such as Microsoft Copilot and ChatGPT can increasingly assist employees with formulas, analysis and spreadsheet problem-solving.

However, employees still need sufficient Excel knowledge to understand what the AI is doing, recognise incorrect results and determine whether a proposed solution is appropriate for the business requirement.

Advanced Excel Part 2 develops this underlying Excel knowledge while helping users understand more sophisticated ways of analysing and working with spreadsheet information.

Advanced Excel Part 2 Course Duration

Advanced Excel Part 2 is a one-day instructor-led course, normally running from 09h00 to approximately 15h30.

Corporate training can be delivered onsite at the client’s premises or virtually using Microsoft Teams.

For organisations requiring training across different Excel skill levels, College Africa Group also provides Excel Training South Africa, including Basic, Intermediate and Advanced Excel programmes.

Advanced Excel Part 2 Course Content

The one-day course includes:

• Advanced Filters
• Goal Seek
• Scenario Manager
• Scenario examples and exercises
• Simple macros
• Recording, running and deleting macros
• Conditional Formatting
• Formula-based Conditional Formatting
• 3-D formulas
• Hyperlinks
• Comments
• Additional formulae
• Sparklines
• Excel shortcut keys
• Additional practical exercises

Microsoft Excel Resources

Delegates can also use Microsoft’s official Excel resources for additional information and reference material:

• Microsoft Excel Help & Learning
• Microsoft Excel Functions by Category

Why Choose College Africa Group for Advanced Excel Part 2?

College Africa Group provides practical corporate Excel training focused on the skills employees need in the workplace.

Advanced Excel Part 2 combines instructor demonstrations with practical exercises so delegates can apply the Excel tools covered during the course.

Training is available for corporate groups onsite and virtually. Delegates receive course material and an electronic attendance certificate on completion.

Continue to Advanced Excel Part 3

After completing Advanced Excel Part 2, experienced Excel users can continue to Advanced Excel Part 3 – Modern Excel & Microsoft 365.

Part 3 focuses on newer Excel functionality available in modern versions of Microsoft Excel and Microsoft 365, including XLOOKUP, dynamic arrays, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and LET.

These newer functions can simplify formulas, improve data analysis and provide more flexible ways of working with business information.

Advanced Excel Part 3 can be attended as the next level after Parts 1 and 2 or as a standalone course by experienced Excel users with the required existing skills.

Advanced Excel Part 3 – Modern Excel & Microsoft 365

Microsoft Excel Resources

For additional information about the Excel features covered in Advanced Excel Part 2, delegates can use Microsoft’s official Excel resources:

• Microsoft Excel Help & Learning
• Microsoft – Use Goal Seek to Find the Result You Want
• Microsoft – Using Scenarios in Excel
• Microsoft – Create a Macro in Excel

Frequently Asked Questions – Advanced Excel Part 2

How long is Advanced Excel Part 2?

Advanced Excel Part 2 is a one-day instructor-led course, normally running from 09h00 to approximately 15h30.

What is covered in Advanced Excel Part 2?

The course covers Advanced Filters, Goal Seek, Scenario Manager, simple macros, advanced Conditional Formatting, hyperlinks, comments, additional formulas, Sparklines and practical exercises.

Do I have to complete Advanced Excel Part 1 first?

Not necessarily. Experienced Excel users with the required existing skills can attend Part 2 directly. Delegates who are not yet comfortable with advanced formulas, referencing and PivotTables should complete Part 1 first.

Can Advanced Excel Part 1 and Part 2 be combined?

Yes. Parts 1 and 2 can be delivered as a two-day Advanced Excel programme for corporate groups.

Does Advanced Excel Part 2 include macros?

Yes. The course introduces simple Excel macros, including recording, running and deleting recorded macros. It is an introduction to automation rather than a VBA programming course.

Is Advanced Excel Part 2 available online?

Yes. Instructor-led virtual Advanced Excel Part 2 training is available using Microsoft Teams. Onsite corporate training is also available.

Is Advanced Excel Part 2 suitable for corporate groups?

Yes. The course is designed for practical workplace application and can be delivered to corporate groups across South Africa.

What comes after Advanced Excel Part 2?

Experienced users can progress to Advanced Excel Part 3, which focuses on modern Microsoft 365 Excel functionality including XLOOKUP, dynamic arrays, FILTER, SORT, UNIQUE and other newer Excel features.

Advanced Excel Part 2 Enquiries

Advanced Excel Part 2 is available for corporate groups across South Africa through onsite and instructor-led virtual training.

Contact College Africa Group for course dates, group pricing and training options.

Telephone: 083 778 4903
Email: sales@collegeafricagroup.com

Enquire About Advanced Excel Part 2