Microsoft Excel L4 Masterclass – Duration 1 Day
Course Overview
In this Excel L4 Masterclass the focus is on the more advanced techniques of Functions and Formulas. We look at the unusual charts in Excel and Data Visualisation with Charts & Graphs, and work on Data Analysis with Pivot Tables & Pivot Charts. Excel Pro Tips for Power Users shows us how to use some of the powerful and effective tools and techniques such as Formatting Tips & Pivot Table Tips and more.
Prerequisites:
A good working knowledge of Excel to Intermediate Level. The course is also of interest to those who would like to work more with Formulas and Pivot Tables.
More Functions and Formulas:
AND/OR
NOT (<>)
Addressing Errors
IS Functions
Rand and RandBetween functions
SUM PRODUCT
COUNTIFS
SUMIFS
UPPER, LOWER, PROPPER and TRIM
Left, Mid, Right & Len
TEXT & VALUE
Data Base Functions
More Advance Charts
Histogram and Pareto Charts
Looking at more of the unusual Charts in Excel
More Pivot Tables and Dashboards
Creating Pivot Tables
Creating Dashboards
Excel Pro Tips for Power Users
Microsoft Excel L4 Masterclass – Duration 1 day
In this Excel L4 Masterclass the focus is on the more advanced techniques of Functions and Formulas. We look at the unusual charts in Excel and Data Visualisation with Charts & Graphs, and work on Data Analysis with Pivot Tables & Pivot Charts. Excel Pro Tips for Power Users shows us how to use some of the powerful and effective tools and techniques such as Formatting Tips & Pivot Table Tips and more.
Prerequisites:
A good working knowledge of Excel to Intermediate Level. The course is also of interest to those who would like to work more with Formulas and Pivot Tables.
More Functions and Formulas:
AND/OR
NOT (<>)
Addressing Errors
IS Functions
Rand and RandBetween functions
SUM PRODUCT
COUNTIFS
SUMIFS
UPPER, LOWER, PROPPER and TRIM
Left, Mid, Right & Len
TEXT & VALUE
Data Base Functions
More Advance Charts
Histogram and Pareto Charts
Looking at more of the unusual Charts in Excel
More Pivot Tables and Dashboards
Creating Pivot Tables
Creating Dashboards
Excel Pro Tips for Power Users
Microsoft Excel L4 Masterclass – Duration 1 Day
Course Overview
In this Excel L4 Masterclass the focus is on the more advanced techniques of Functions and Formulas. We look at the unusual charts in Excel and Data Visualisation with Charts & Graphs, and work on Data Analysis with Pivot Tables & Pivot Charts. Excel Pro Tips for Power Users shows us how to use some of the powerful and effective tools and techniques such as Formatting Tips & Pivot Table Tips and more.
Prerequisites:
A good working knowledge of Excel to Intermediate Level. The course is also of interest to those who would like to work more with Formulas and Pivot Tables.
More Functions and Formulas:
AND/OR
NOT (<>)
Addressing Errors
IS Functions
Rand and RandBetween functions
SUM PRODUCT
COUNTIFS
SUMIFS
UPPER, LOWER, PROPPER and TRIM
Left, Mid, Right & Len
TEXT & VALUE
Data Base Functions
More Advance Charts
Histogram and Pareto Charts
Looking at more of the unusual Charts in Excel
More Pivot Tables and Dashboards
Creating Pivot Tables
Creating Dashboards
Excel Pro Tips for Power Users
Microsoft Excel L4 Masterclass – Duration 1 day
In this Excel L4 Masterclass the focus is on the more advanced techniques of Functions and Formulas. We look at the unusual charts in Excel and Data Visualisation with Charts & Graphs, and work on Data Analysis with Pivot Tables & Pivot Charts. Excel Pro Tips for Power Users shows us how to use some of the powerful and effective tools and techniques such as Formatting Tips & Pivot Table Tips and more.
Prerequisites:
A good working knowledge of Excel to Intermediate Level. The course is also of interest to those who would like to work more with Formulas and Pivot Tables.
More Functions and Formulas:
AND/OR
NOT (<>)
Addressing Errors
IS Functions
Rand and RandBetween functions
SUM PRODUCT
COUNTIFS
SUMIFS
UPPER, LOWER, PROPPER and TRIM
Left, Mid, Right & Len
TEXT & VALUE
Data Base Functions
More Advance Charts
Histogram and Pareto Charts
Looking at more of the unusual Charts in Excel
More Pivot Tables and Dashboards
Creating Pivot Tables
Creating Dashboards
Excel Pro Tips for Power Users
