Quick review on MS Excel Options, Ribbon, Sheets

Saving Excel File as PDF, CSV and Older versions

Using Excel Shortcuts with Full List of Shortcut

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

Sales Forecasting

Demand Forecasting

Forecasting For Decision Making

Being Able To Generate Scenarios – Optimistic, Pessimistic

Know How To Capture Information About Significant Market Events

Interactive Sales Dashboard In Excel

Bank & Marketing Dashboard

Interactive HR Dashboard In Excel

Project Management Dashboard In Excel

Call Centre Dashboard In Excel

Fundamental of Accounts Rules of Accounts

Creating/Altering/Deleting Company in Tally Prime

Group & Ledger Creation in Tally Prime

Journal Entries in in Tally Prime

Day Book & Cash/Bank Book

Trading & P&L Account

Trial Balance, Balance Sheet & Reports

Managing Accounts of Sole Proprietorship

Managing Accounts of Consultancy Firm

GST in Tally Accounting

Ledgers for GST

GST Reports

Inventory Management

Purchase & sale Vouchers

Creating Stock Group, Stock Items, & units

Maintaining Stock & Depreciation

Managing Account of Partnership Firm

Bill Wise Details

Inventory Reports