This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
**This course bundle includes practice exercises**
Data Analysis is THE skill you need to thrive in the modern workforce.
Data Analysis is easier than you might think. You don’t need to be able to code or understand algorithms. What you need, is a deep understanding of the Microsoft Excel techniques needed to conduct comprehensive data analysis.
In this five-course bundle, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business.
In this special course, we’ve combined five of our full-length titles into one, huge-value bundle. Here’s what you get:
Excel for Business Analysts
What you’ll learn:
-
How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
-
How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
-
How to split data using text functions SEARCH, LEFT, RIGHT, MID
-
How to standardize and clean data ready for analysis
-
About using the PivotTable function to perform data analysis
-
How to use slicers to draw out information
-
How to display your analysis using Pivot Charts
-
All about forecasting and using the Forecast Sheets
-
Conducting a Linear Forecast and Forecast Smoothing
-
How to use Conditional Formatting to highlight areas of your data
-
All about Histograms and Regression
-
How to use Goal Seek, Scenario Manager, and Solver to fill data gaps
Advanced Excel 2019 Course
What You’ll Learn:
-
What’s new/different in Excel 2016
-
Advanced charting and graphing in Excel
-
How to use detailed formatting tools
-
Lookup and advanced lookup functions
-
Financial functions including calculating interest and depreciation
-
Statistical functions
-
Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
-
How to create awesome visualizations using sparklines and data bars
-
Mastery of PivotTables and Pivot Charts
-
Scenario Manager, Goal Seek, and Solver
-
Advanced charts such as Surface, Radar, Bubble, and Stock Charts
PivotTables for Beginners
What You’ll Learn:
-
How to clean and prepare your data
-
Creating a basic PivotTable
-
Using the PivotTable fields pane
-
Adding fields and pivoting the fields
-
Formatting numbers in PivotTable
-
Different ways to summarize data
-
Grouping PivotTable data
-
Using multiple fields and dimension
-
The methods of aggregation
-
How to choose and lock the report layout
-
Applying PivotTable styles
-
Sorting data and using filters
-
Create pivot charts based on PivotTable data
-
Selecting the right chart for your data
-
Apply conditional formatting
-
Add slicers and timelines to your dashboards
-
Adding new data to the original source dataset
-
Updating PivotTables and charts
Advanced PivotTables
What You’ll Learn:
-
How to do a PivotTable (a quick refresher)
-
How to combine data from multiple worksheets for a PivotTable
-
Grouping, ungrouping, and dealing with errors
-
How to format a PivotTable, including adjusting styles
-
How to use the Value Field Settings
-
Advanced Sorting and Filtering in PivotTables
-
How to use Slicers, Timelines on multiple tables
-
How to create a Calculated Field
-
All about GETPIVOTDATA
-
How to create a Pivot Chart and add sparklines and slicers
-
How to use 3D Maps from a PivotTable
-
How to update your data in a PivotTable and Pivot Chart
-
All about Conditional Formatting in a PivotTable
-
How to create amazing looking dashboards
Advanced Formulas in Excel
What You’ll Learn:
-
Filter a dataset using a formula
-
Sort dataset using formulas and defined variables
-
Create multi-dependent dynamic drop-down lists
-
Perform a 2-way lookup
-
Make decisions with complex logical calculations
-
Extract parts of a text string
-
Create a dynamic chart title
-
Find the last occurrence of a value in a list
-
Look up information with XLOOKUP
-
Find the closest match to a value
This course includes:
-
30+ hours of video tutorials
-
230+ individual video lectures
-
Exercise files to practice what you learned
-
Certificate of completion
This course was recorded using Excel 2019 and Excel 365. It’s also relevant to those using other, recent versions of Microsoft Excel including Excel 2013 and 2016.
Here’s what our students are saying…
“Well described and clearly demonstrated.”
– Harlan
“My name is Kenvis and i have a knowledge in IT but never thought of specializing in Data Analytics before. This was so exciting and am now anxious to learn more.”
– Kenvis
“I like the instructor very much. I had a slight problem with the MIN function but I reviewed the tutorial again until I realized where my error was, and fixed it!”
– Beverly
Excel for Business Analysts: The Basics
Excel for Business Analysts: Merging and Looking Up Data
Excel for Business Analysts: Making Better Decisions with IF
-
9Merging Data from Different Sources
-
10Looking up Information with VLOOKUP (Exact)
-
11Looking up information with VLOOKUP (Approx)
-
12How to use VLOOKUP with Data that Expands
-
13Using HLOOKUP
-
14Combining VLOOKUP and MATCH
-
15Using INDEX, MATCH and XLOOKUP
-
16Data Validation Lists with Lookups
-
17Exercise 02
-
18Section Quiz