Communication skills course

Data Analysis Using Microsoft Excel

Delivery Mode

Live Online & face to face classroom

lessons

7

skill level

Intermediate

duration

8 hours

language

english

  • Delivery mode : Live online and classroom
  • Course Duration : 8 hours
  • Live Online Duration : 2 days (4 hours each day)
  • Classroom Training Duration : 1 day (8 hours)
Data Analysis Using Microsoft Excel

Course Overview

Getting knowledgeable in data analysis is critical for every business. Our program is designed to introduce you to data and demonstrate how to analyze data using Microsoft Excel. Excel is the go-to tool for gathering data, organizing them, managing them, and performing analysis.

The 8-hour workshop is designed for those desiring to use Excel for data analysis in their own field of work. This workshop will provide you with hands-on experience in manipulating data and teaches you the importance of spreadsheets in data analysis.

The tips and tricks that you will learn here will help you become a more effective and efficient Excel user.  By using charts to visualize data, you will learn to create engaging and insightful reports.

  • Delivery mode : Live online and classroom
  • Course Duration : 8 hours
  • Live Online Duration : 2 days (4 hours each day)
  • Classroom Training Duration : 1 day (8 hours)

Delivery Methods:

  • Self-discovery and critique
  • Group exploration and facilitator led discussions
  • Practical exercises
  • Best practice theory exploration

Completing this course will help you:

By the end of this training course participants will be able to:

  • Organize and manage worksheet data
  • Simplify tasks using formulas and functions
  • Analyze data by utilizing filters and statistical functions
  • Perform analysis using Pivot tables
  • Visualize data for engaging reports

Who is the course for?

Aspiring working professionals who work with data and anyone who is completing their final year studies in business school and colleges.

Learning Path

  • Understanding data and data types
  • Importance of data quality (cleaning & wrangling)
  • Introduction to data analysis and type of analysis
  • Introduction to the spreadsheet concepts
  • Working with workbook and sheets
  • Layouts in Microsoft Excel
  • Cell referencing
  • Understanding cell, range, and range names
  • Application of fill handle and flash fills
  • Shortcuts
  • General formatting
  • Format painter
  • Number and date formatting
  • Conditional formatting
  • Shortcuts
  • Working with tables
  • Sorting list/database
  • Working with Filter
  • Understanding and applying data validation
  • Introduction to Excel functions
  • Type of functions
    • Inbuilt and UDF’s
  • Arithmetic functions
    • SUM, INT, ABS, MOD, ROUND, ROUNDUP, ROUNDDOWN
  • Text functions
    • TEXT, TRIM, LEFT, RIGHT, MID, LEN, FIND
  • Statistical functions
    • AVERAGE, MEDIAN, MODE, COUNT, COUNTA, MAX, MIN, LARGE SMALL
  • Date functions
    • DATE, DAY, MONTH, YEAR, NOW, TODAY, WEEKNUM, WEEKDAY, DAYS360
  • Logical functions
    • AND, OR, NOT, IF, IFS, SUMIFS, COUNTIFS, AVERAGEIFS
  • Lookup functions
    • VLOOKUP, INDEX, MATCH
  • Understanding chart types
  • Chart elements and styles
  • Visualizing data
  • Formatting charts
  • Building picture charts
  • Introduction to Pivot tables and Pivot charts
  • Analyzing data using Pivot tables
  • Dynamic visuals using Pivot charts
  • Case study

Questions and answers

Are you ready to start ?

Connect with us

Share this course :

Facilitator(s)

Name of Trainer

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.