Hello and welcome to the second course of my Excel For Business series. In this Excel for Business - Intermediate course, you will build on the strong foundations you already have (after taking my Excel Essentials For Business course). The course will expand your Excel knowledge to new horizons through practical business examples.

You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.

I will be with you every step of the way. Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. For those of you who have done the Essentials course, you will be a little more familiar. Working through

faviconv2_1741919174832.png

Excel For Business - intermediate

W1_V1.rar

Working with multiple worksheets

W1_V2.rar

3D formulas

W1-V3 Linking Workbooks.rar

Linking workbooks

W1-V4 Consolidating by Position.rar

Cosolidating by position

W1-V5 Consolidating by Reference.rar

Consolidating by reference

Working with multiple worksheets and workbooks

W2-V1.rar

Introducing named ranges

W2_V2.rar

Creating named ranges

W2_V3.rar

Managing named ranges

W2_V4.rar

Named ranges in Formulas

All about Named ranges

W3_V1 Text functions.rar

Text functions

W3_V2 Extracting_Text.rar

Extracting Text

W3_V3 Find.rar

Finding Text

W3_V4 Date_Functions.rar

Date functions

W4_V1 COUNT_Functions.rar

Count functions

W4_V2 COUNTIFS.rar

Counting with criteria

W4_V3 SUMIFS.rar

Adding with criteria

W4_V4 Sparklines.rar

Using Sparklines

W4-V5 advanced charting.rar

Advanced charting

Intermediate Excel functions

W5_V1 Tables.rar

Creating and formatting tables

W5_V2 WorkingWithTables.rar

Working with tables

W5_V3 SortingAndFiltering.rar

Sorting and filtering in tables

W5_V4 Automation.rar

Automation with Tables 

W5_V5 ConvertAndSubtotal.rar

Converting to ranges and subtotals

All about tables

W6 _V1.rar

Creating and modifying a pivot table

W6_V2.rar

Value Field Settings

W6_V3.rar

Sorting and Filtering a Pivot Table

W6_V4.rar

Reporting Filter Pages

W6_V5.rar

Pivot charts

Pivot tables

What you'll learn

Course content

Instructor

Outstanding review