Quick review on MS Excel Options, Ribbon, Sheets

Saving Excel File as PDF, CSV and Older versions

Using Excel Shortcuts with Full List of Shortcuts

Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet

Using Paste Special Options

Formatting Cells, Rows, Columns and Sheet

Advanced Filtering in Excel

Grouping & Subtotal in Excel

Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password

Page Layout and Printer Properties

Working with Formulas / function

Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc

Database Functions

Date & Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY

Information Functions

Math & Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, EVEN, SUMIF

Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK,COUNTIF, MAX, MAXA,MIN, MINA, STDEVA

Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE

Conditional Formatting

Using Conditional Formatting

Using Conditional Formatting with Multiple Cell Rules

Using Color Scales and Icon Sets in Conditional Formatting

Creating New Rules and Managing Existing Rules

Data Lock & Protection

Advance Charts in Excel

Area Charts and Surface Charts

Trend line Charts and Candle Stick

Charts and Pie Charts

XY (Scatter Charts)

Time Series Charts and Bubble Charts

Radar Charts and Doughnut Charts

Rotating 3D Excel Charts

Working with Fill Series & Go to Special

Consolidation in Excel

What if Analysis in Excel

Goal Seek

Scenario Manager

Data Table

Working with Histogram

Helps in summarize discrete or continuous data

Helps in identifying the most efficient pricing plans in sales & marketing, It will determine the issues with a certain process

Calculating peak time hours in restaurants & Hospitals

To Measure the Effectiveness of the Marketing Campaigns, Pricing, And Promotions On Sales Of A Product

Used To Analyse Categorical Data

Commonly Used In Understanding Customer Behaviour

To Understand the Relationship between a Company’s Stock Price & The Company’s Quarterly Earnings

Credit Risk Assessment

Creating Automation Tools With Excel Scripts

Create A Workbook Table Of Contents

Run A Script On All Excel Files In A Folder

Copy Multiple Excel Tables Into A Single Table

Generate An Automated Sales Summary Using Pivot Tables

Create, Sort, & Format A Table Automatically In Excel

Sales Forecasting

Demand Forecasting

Forecasting For Decision Making

Being Able To Generate Scenarios – Optimistic, Pessimistic

Know How To Capture Information About Significant Market Events

COMPONENTS OF POWER BI: DESKTOP, SERVICE, AND MOBILE APPS

BENEFITS AND APPLICATIONS OF POWER BI

POWER BI ARCHITECTURE OVERVIEW

INSTALLING AND SETTING UP POWER BI DESKTOP

CONNECTING TO DATA SOURCES (EXCEL, CSV, ONLINE SERVICES, ETC.)

CLEANING AND TRANSFORMING DATA

HANDLING MISSING DATA SPLITTING AND MERGING COLUMNS

DATA FORMATTING AND STANDARDIZATION WORKING WITH RELATIONSHIPS BETWEEN TABLES

CREATING CUSTOM COLUMNS AND MEASURES WITH DAX (DATA ANALYSIS EXPRESSIONS)

CREATING RELATIONSHIPS BETWEEN TABLES UNDERSTANDING

CALCULATED COLUMNS AND MEASURES

MANAGING MODEL PERFORMANCE WITH OPTIMIZATION TECHNIQUES

CREATING BASIC CHARTS: BAR, LINE, PIE, AND COLUMN CHARTS

ADVANCED VISUALS: SCATTER PLOTS, MAPS, FUNNEL CHARTS, & GAUGES USING SLICERS, FILTERS, & DRILL-THROUGHS

CREATING AND CUSTOMIZING DASHBOARDS FORMATTING AND STYLING REPORTS FOR BETTER USER EXPERIENCE USING POWER BI MARKETPLACE FOR CUSTOM VISUALS

CALCULATED COLUMNS AND MEASURES

AGGREGATION FUNCTIONS (SUM, AVERAGE, COUNT)

TIME INTELLIGENCE FUNCTIONS (YTD, MTD, QTD)

PUBLISHING REPORTS TO POWER BI SERVICE

CREATING DASHBOARDS IN POWER BI SERVICE

SHARING REPORTS AND DASHBOARDS WITH OTHERS

EXPORTING REPORTS TO PDF

SALES ANALYSIS

FINANCIAL REPORTING

CONNECTING POWER BI DESKTOP WITH MOBILE FOR REAL TIME ANALYSIS

RETAIL ANALYSIS DASHBOARDS

TELECOM CHURN RATE DASHBOARD

OLA COMPANY DASHBOARD

BLINKIT ANALYSIS DASHBOARD