BASIC
1 day
Business Analytics
I know how to move around in Excel and perform basic commands & calculations. Start right at the beginning...
For who?
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
Roadmap
OBJECTIVE:Build a strong foundation of Excel and enable the participants to perform data analysis in Excel.
DURATION:
7h split into 2 sessions (3.5h each)
FORMAT:
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
Removing duplicates
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
Chart elements
Chart design
PivotTables and Pivot Charts:
Summarizing and Analyzing Data
Pivot Table Basic
Pivot Table Options
Pivot Table Options
Pivot Table Design and Pivot Charts
Meet your Trainer
Bas Dohmen
Questions?
Let us know!
We will be in touch shortly :)
Thank you!