Write your awesome label here.

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

Datasets and Tables:

Excel tables
    Table manipulation
    Table aggregation
    Basic Conditional formatting
    Subtotals and outlines

PivotTables and Pivot Charts:
Summarizing and Analyzing Data

Pivot Table Basic
Pivot Table Options
Pivot Table Design and Pivot Charts

ACCESS:
Training Call
Training Materials
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

Bas Dohmen

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.
Write your awesome label here.

Questions?

Let us know!
We will be in touch shortly :)

Contact us

First Name
Last Name
E-mail
Message
Thank you!