Youngster Superstar: Analytics and Excel Power Up!

Module1: Power up with Basics and fundamentals
Learn the Excel User interface

How to open Excel

01:34
How to enter data excel and save the excel file.

01:22
How to open previously saved data

02:08
The structure of columns and rows in excel

01:34
Overview of the Excel Window/Graphic User Interface

07:59
Basics of Data Analysis

05:44
Overview of Excel Formats

04:59
Difference between a Workbook and Worksheet

00:47
Copy and paste or move sheet in or outside a workbook

02:43
Add columns and Rows in a worksheet

03:02
Hide or Unhide rows and Columns

02:34
Freeze or unfreeze panes to view large datasets

02:15

Module 2: Power up interaction with data manipulation techniques
Learn how to work with data in Excel

Introducing Data Manipulation Skills in Excel

02:22
How To Use Data Filters in Excel

06:09
Using Advanced Filters for data management in Excel

09:14
Basics of number formatting in Excel

03:36
Number Format – Advanced

01:02
How to copy or Move Sheet in an excel workbook

01:25
Select and Boarder

03:05
Form for Data Entry

07:27
Formatting Data as an Excel Table

04:60
Benefits of Managing data in an Excel Table format

07:10
Excel Table data management

03:46
Multiple Sheet Operation

03:34
How to Sum all worksheets in an excel workbook

03:25
Sum All Sheets Use Start-End Sheets

03:41
Basics and Importance of Data Validation in Excel Data Management

05:24
How to remove duplicates in a list

02:53
Exploring the “Text-to-Column” Command

05:31
Further techniques: Page Lay Out – Print Titles, Print Options Gridlines, Freeze panes etc

03:05

Module 3: Power up with formulas to assess Class Performance
Learn basics of sum, count, average, sumifs, countifs to add, count, average and other basic functions.

Module 4: Visualizations: Class performance report using charts and graphs
Learn how to make different graphs and updating their properties like Titles, Axes, Legends, Series, Data labels etc.

Module 5: Power up conversion of marks/score to grades using common Excel functions
Converting scores/marks to grades using IF, IFS, VLOOKUP, INDEX/MATCH and XLOOKUP Functions

Module 6: Superstar on a Data Management Journey
Data Management: sorting and filtering data

Module 7: Mum’s shop (Duuka) case Study: Introductory Business Analysis and Reporting in Excel using PIVOT TABLES.
PIVOT TABLE ANALYSIS SKILLS: Setting foothold on the analytics pedestal analyzing performance of business operations of mum's shop. Using grocery operations data to generate a business performance report suing the all powerful PIVOT TABLE functionality n Excel.

Course Content

Module1: Power up with Basics and fundamentals Learn the Excel User interface

How to open Excel

How to enter data excel and save the excel file.

How to open previously saved data

The structure of columns and rows in excel

Overview of the Excel Window/Graphic User Interface

Basics of Data Analysis

Overview of Excel Formats

Difference between a Workbook and Worksheet

Copy and paste or move sheet in or outside a workbook

Add columns and Rows in a worksheet

Hide or Unhide rows and Columns

Freeze or unfreeze panes to view large datasets

Module 2: Power up interaction with data manipulation techniques Learn how to work with data in Excel

Introducing Data Manipulation Skills in Excel

How To Use Data Filters in Excel

Using Advanced Filters for data management in Excel

Basics of number formatting in Excel

Number Format – Advanced

How to copy or Move Sheet in an excel workbook

Select and Boarder

Form for Data Entry

Formatting Data as an Excel Table

Benefits of Managing data in an Excel Table format

Excel Table data management

Multiple Sheet Operation

How to Sum all worksheets in an excel workbook

Sum All Sheets Use Start-End Sheets

Basics and Importance of Data Validation in Excel Data Management

How to remove duplicates in a list

Exploring the “Text-to-Column” Command

Further techniques: Page Lay Out – Print Titles, Print Options Gridlines, Freeze panes etc

Module 3: Power up with formulas to assess Class Performance Learn basics of sum, count, average, sumifs, countifs to add, count, average and other basic functions.

Overview of class student scores data

Finding the total student grades and the average score

Understanding and Interpreting SUM and Average

Using Excel to find a student’s position in class

Arrange student scores/marks in ascending/descending order

Module 4: Visualizations: Class performance report using charts and graphs Learn how to make different graphs and updating their properties like Titles, Axes, Legends, Series, Data labels etc.

Getting Started with Charts in Excel

Definition of charts, locating them in excel and exploration of chart types

Editing Charts: Chart title, Grid lines, bolding font and Italics

Axes, Titles and other chart elements

Change a chart from one chart type to another (from bar to column)

Overview of other Chart Types

Locating and understanding More Chart types

Module 5: Power up conversion of marks/score to grades using common Excel functions Converting scores/marks to grades using IF, IFS, VLOOKUP, INDEX/MATCH and XLOOKUP Functions

Recapping analysis of performance from Module 4 and introducing grading

Converting number scores to grades using the VLOOKUP function in excel

XLOOKUP function as an alternative to VLOOKUP to undertake grading of scores

The IFS function as an alternative to undertake grading of scores

Performance Summary for candidate grades using the COUNTIFs function

Easily view and interpret performance summary (grades) using Charts

Module 6: Superstar on a Data Management Journey Data Management: sorting and filtering data

Overview of data management

Overview of shortcuts to quickly and efficiently move to different ends of a dataset

Simplify data challenges by using the FILTER and SORT commands in excel

Computing averages in big datasets using the AVERAGEIFS function

Introducing Business Data Analysis in Excel

Overview of Pivot Table analysis

Working with dates in constructing a pivot table report

Pivot Table field manipulation and changing value Field Settings operator

More practice with Pivot Tables by interchanging fields between rows and columns

Filtering, Slicers and other functionalities in Pivot Table Management

Student Ratings & Reviews

Module1: Power up with Basics and fundamentals
Learn the Excel User interface

Module 2: Power up interaction with data manipulation techniques
Learn how to work with data in Excel

Module 3: Power up with formulas to assess Class Performance
Learn basics of sum, count, average, sumifs, countifs to add, count, average and other basic functions.

Module 4: Visualizations: Class performance report using charts and graphs
Learn how to make different graphs and updating their properties like Titles, Axes, Legends, Series, Data labels etc.

Module 5: Power up conversion of marks/score to grades using common Excel functions
Converting scores/marks to grades using IF, IFS, VLOOKUP, INDEX/MATCH and XLOOKUP Functions

Module 6: Superstar on a Data Management Journey
Data Management: sorting and filtering data