I know how to move around in Excel and perform basic commands & calculations. Start right at the beginning...
This training is for everyone who is starting with Excel and wants to make sure the fundamentals are strong. This training helps you learn and understand key functionalities of Excel from scratch . Pivot Tables, formulas and functions as well as visualizations and much more in short and practical way.
Upon completion you will be able to use all key features of Excel, work with tables, pivot tables and be able to preform data analysis in Excel.
Business Analytics Basic
OBJECTIVE:Build a strong foundation of Excel and enable the participants to perform data analysis in Excel.
7h split into 2 sessions (3.5h each)
Real time Training Online. Access to online environment, call via Zoom, MS Teams or Webex.
Intro: What is a Spreadsheet?
Introduction to spreadsheets
Mathematics and formulas
Manipulating text and data cleaning
Removing unwanted characters
Formatting (figures and text)
Basic Functionalities: Sort, Filter, Hide, Search & Replace
Formulas and Functions: Performing Quantitative Analysis
Formula basics (concept, references, fixing cells)
Function basics: Arithmetic calculations, basic functions
Logic and lookup functions
Calculations across spreadsheets
Charts: Depicting Data Visually
Chart creation basics
Datasets and Tables:
Basic Conditional formatting
Subtotals and outlines
PivotTables and Pivot Charts:
Summarizing and Analyzing Data
Pivot Table Basic
Pivot Table Options
Pivot Table Options
Pivot Table Design and Pivot Charts
Learning Path (over 6h of recorded content)
Additional optional assignments (2)
Possibility to ask questions ad hoc to the trainer at any point (email)
Meet your Trainer
His background is in finance and he has worked as a BI consultant before.
Over the last 10 years he has been consulting on projects and training international teams in Data Analytics, Power BI, Tableau and advanced Excel.
He has worked with hundreds of different companies in diverse industries, ranging from FMCG, travel companies to big 5.
He is widely recognized in the Power BI community and has one of the fastest growing Power BI YouTube channels worldwide- How to Power BI.
Let us know!
We will be in touch shortly :)