Microsoft Excel Video Training – Intermediate

Training Theme 

In this training, you will go over more specific Excel features.

At the end of this training, you will know how to use the most popular features of Microsoft Excel: PivotTables. These are powerful tools that will allow you to calculate, summarize and analyze your data to derive patterns and trends. You will then discover the possibilities offered by Microsoft Excel to transcribe data visually using graphs, and thus make your documents more attractive.

Finally, to allow you to go further, you will be introduced to different functions available in Microsoft Excel, which you can use to create formulas and process your data more accurately and efficiently. After taking this training, the analysis, valuation and summary of your data in Microsoft Excel will no longer have any secrets for you!

Training Objectives 

You know Microsoft Excel and want to go a step further to analyze and enhance your data more accurately.

At the end of this training, you will know:

•     How to use PivotTables
•     How to turn your data into charts and visuals
•     How to use Microsoft Excel functions to calculate and summarize your data

Prerequisite and Target Audience 

Target audience: Users who want to learn more about PivotTables, formatting and summary tools in Microsoft Excel
Startup Level: Intermediate
Prerequisite: Know the operation and basic tools of Microsoft Excel and know how to use this tool independently

Means and Methods 

• E-Learning Modules: A video series to help you achieve the defined educational objective.

Training Content

3 Use Case Videos

•     Run and generate reports for an entire team
•     Sharing a file from a smartphone
•     Accessing Office from 5 different terminals

81 Video Tutorials on Excel broken down into 10 lessons

•     Text reprocessing functions
  •     Concatenate text
  •     Check the accuracy of two cells
  •     Identify the presence of an expression in text
  •     Retrieve part of a cell's text from the left or right
  •     Calculate the number of characters in a text
  •     Switch uppercase, lowercase text
  •     Retrieve part of a text in a cell
  •     Automatically add capital letters to text
  •     Remove unnecessary spaces from text
•     Date functions
  •     Convert separate items to date format
  •     Retrieve information from a date
  •     Convert separate items to time
  •     Calculate the number of days between two dates
  •     Increment a one-day date
  •     Dynamically get today's date
  •     Get the week and weekday number of a date
  •     Convert a timestamp to date
  •     Convert a number of seconds to a time format
•     Logical functions
  •     Logical operators
  •     Basic conditions
  •     Boolean logic
  •     Double conditions
  •     Manage multiple sets of conditions
  •     Managing multiple values
•     Search and reference functions
  •     Obtain the numeric coordinates of a cell
  •     Recreate the coordinates of a cell
  •     Retrieve a set of values from a reference
  •     Retrieve unique items from a list
  •     Refer to a table by applying filters and sorts
  •     The VLOOKUP function
  •     The HLOOKUP function
  •     Use table references
•     Error handling functions
  •     Incompatible cell format
  •     Problem in cell selection
  •     Dividing a number by zero
  •     Reference to an invalid cell
  •     Integer number too large
  •     Search cannot return a value
  •     Figure too long
  •     The Watch Window
•     Create Charts - Introduction
  •     Introduction to Data Visualization
  •     The main principles of data visualization
  •     The data analysis cycle
  •     Tips and best practices
•     Create and customize your first chart
  •     Create your first chart
  •     Switch values
  •     Customize the items displayed on a chart
  •     Add a chart to a dedicated sheet
•     The different types of charts
  •     Ranking charts by importance
  •     Bar chart
  •     Pie chart
  •     Stacked Bar Chart
  •     Available trend charts
  •     Line options
  •     Areas
  •     Relationship charts between available properties
  •     Scatter plot
  •     Add categories to a scatter plot
  •     Bubble chart
  •     Understanding distribution charts for a series of values
  •     Display a distribution histogram
  •     Display box and whisker diagrams
  •     Overview of set and subset graphs
  •     Create a Treemap
  •     Create a Sunburst
  •     Overview of Financial Analysis Charts
  •     Create a Stock
  •     Create a Waterfall chart
  •     Funnel
  •     Sparklines
  •     Radar
  •     Map
  •     Combo chart
  •     3D Maps
•     Conditional formatting
  •     Use conditional formatting
  •     Conditionally format dates
  •     Conditionally format text
  •     Copy and remove conditional formatting
•     Conditional formatting to the next level
  •     Take conditional formatting to the next level
  •     Use formulas to apply conditional formatting
  •     Manage conditional formatting

Learn more about Microsoft Excel

Microsoft Excel is a powerful calculation and data analysis tool, which offers many possibilities. When you have to work with a large number of people, sometimes from different sources, the basic functionality of your spreadsheet software may seem limited.

Fortunately, Microsoft Excel has many resources, such as PivotTables, which once mastered, allow you to go further in your analysis and in the valorization of your data. Using the functions in your formulas also saves you valuable time.

Finally, the ability to create graphs and visual items to transcribe your data will allow you to gain clarity when you present your summaries to your colleagues.