Scribd
Upload
189 views3 pages

Excel Mastery for Analytics Students

This document outlines a business analytics course syllabus that focuses on developing Excel skills. The course is divided into four main sections: Building Blocks, Story Telling, Business Automations, and Data Science in Excel. The Building Blocks section covers basic Excel features and functions over 8 hours. Story Telling focuses on data visualization and dashboards to convey insights over 8 hours. Business Automations explores advanced formulas, pivot tables, and macros for process automation over 8 hours. Finally, Data Science in Excel applies time series analysis, causal studies, and other data science techniques using Excel over 8 hours.

Uploaded by

Alok Patil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
189 views3 pages

Excel Mastery for Analytics Students

This document outlines a business analytics course syllabus that focuses on developing Excel skills. The course is divided into four main sections: Building Blocks, Story Telling, Business Automations, and Data Science in Excel. The Building Blocks section covers basic Excel features and functions over 8 hours. Story Telling focuses on data visualization and dashboards to convey insights over 8 hours. Business Automations explores advanced formulas, pivot tables, and macros for process automation over 8 hours. Finally, Data Science in Excel applies time series analysis, causal studies, and other data science techniques using Excel over 8 hours.

Uploaded by

Alok Patil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Business Analy

Lets excel in Excel! Building Blocks


Excel is a complete tool !

Be it data storage, visualization,


automations or analytics, Excel
enables end-to-end business processes.

Objective:
As an advanced analytics consultant,
expertise in data science, tools as well
as mastery in the art of story telling is
essential.

This course aims to develop students in


the above through excel. This comprises proficiency at basic features and functions in
excel
Broadly the focus of this course can be
Data Entry(Ctrl,Alt,Fill Series)
broken down into:
1 Tool Familiarity Cell Referencing to freeze cells
(i) Building Blocks: 8 hours Freeze Panes & Name cells
(ii) Story Telling: 8 hours 2 Selective view Filtering & Sorting,
Conditional Tips & Tricks
formatting
(iii) Business Automations: 8 hours 3 Making data stand out Conditional formatting with and
(iv) Data Science in Excel: 8 hours Data Types & Data without formulae
Types,Text-column,Duplicates,
4
Treatment Find/Replace, Paste as Special

5 Summarize data SUM, MAX, MIN, IF,SUM Ifs,


AVERAGE Ifs, COUNT Ifs, COUNT A
LEN TRUNC ROUND TRIM SEARCH
6 Data cleaning & String FIND SUBSTITUTE REPLACE LEFT MID
Functions RIGHT UPPER LOWER REPT TEXT

7 Date Functions WEEKDAY WEEKNUM DATE TODAY()


NOW()
LOOKUP VLOOKUP HLOOKUP
8 Lookup functions MATCH INDEX OFFSET
Business Analytics Spreadsheet Modeling Syllabus
Story Telling Business Automations

Data Visualization and building dashboards to convey Using advanced formulae, pivot tables and macros for
a story process automations
1 Format Painter Formatting objects similarly
1 Solver Lets optimize and solve constraints!
2 Alignment Top/Down,Left/Right,
Vertically/Horizontally Advanced formulae - Indirect,Offset
3 Grouping Data Group/Un-group rows
2 Automations Using and nested IF conditions
4 Colors & Borders Types Formulae Evaluate Formulae to debug
Charting Excel Chart types and their IFERROR()
5
Techniques significance Pivot Structure & Usage

Drop-down based Data Refresh Automations Using Charting in Pivots


3 Pivots
Dynamic Charts Slicers
Option /Check-box based charts Creating calculated fields
Building
6 Dashboards Hide/Un-hide Gridlines, Formula Understanding Macro basics
Bar, Headings Recording a Macro
4 Automations Using
Review(Spell Check, Protect) Macros Changing a Macro
Decision making through If/Else-if
Final Story-Telling conditions
Data Science in Excel

Causal, Time-series and launch analytics on our very own


Excel!
Detecting the seasonality period of
1 Seasonality time-series data
Building the ACF plot
2 Smoothening Smoothening data fluctuations
3 Trend Modification Changing the trend direction
4 Time series Breaking into its Trend, seasonality
Decomposition and Irregularity

5 Building your time- Additive, Multiplicative models


series model Using Forecast Function
Correlation & Regression Case
6 Causal Study Studies
7 Simulations Monte Carlo Simulation
Using the transition curve
8 Launch Analytics Event Impact Analysis,
Using linear, log, sigmoid and
exponential methods

You might also like