Session wise outline
Session-01: Formulas & Functions
- Tables & Structural References
- IFS, goodbye Nested IF
- SUMIFS
- VLOOKUP
- INDEX+MATCH Combination Formula
- Working with Date & Time values in Excel
- Working with text values in Excel
- Implement Business logic with and / or / not
- Summarize filtered values with subtotal
- Errors in Formulas
Session-02: Data Analysis
- Basic statistics
- Weighted Average
- Quickly spot outliers
- Find common values between lists
- Extract Top / Bottom 5 values
- Top 5 Values – Easier method
- Avoid VLOOKUP’s with multi-table pivots
- Monthly / Quarterly totals from daily data
- Change from previous month / period
- Make Your Analysis Interactive
Session-03: Chart & Visuals
- Know which chart to use
- Thermometer Chart
- Combo Chart
- Smart titles & captions on your charts
- Analyze distribution with histograms
- Box Plots
- Indexed Charts
- Interactive Charts
- Last year vs. This year Analysis
- Highlight important points in charts
- Tables are charts too
Session-04: Tips & Tricks
- Remove Blank Cells
- Remove duplicate combinations
- Change formulas quickly with FIND Replace
- Use Flash Fill to extract data quickly
- Distinct counts – the easy way with Pivot Tables
- Clone with CTRL
- Customize Quick Access Toolbar + Ribbon
- Alignment Tools
- Mouse Shortcuts
- Keyboard Shortcuts
How participants will benefit after course?
- Learn everything you need to be a world-class data analyst
- Master advanced formulas and functions
- Create sophisticated outputs for analysis, including beautiful tables, charts, and graphs
Target audience
Any professional who involve in business decision making process or helps decision makers by providing real time & actionable insights. This course is suitable for them who wants to build their career in Management Information System, Financial Analysis, Business Analytics & Strategic Business Planning related functions
Instructor
Rony Saha
Financial Analysis and Business Intelligence Professional.
Rony Saha, a Financial Management and Business Intelligence Professional with more than 10 years job experience in Accounting, Financial Analysis, Inventory Management, Business Planning, Business Process Management and Business Intelligence in different industries
Become awesome at work!
Reviews
There are no reviews yet.