Advanced Excel (Basics + Advance).
COURSE DETAILS:-
Microsoft Excel is the industry leading spreadsheet program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel.Excel learns your patterns, organizing your data to save you time. Easily create spreadsheets from templates or on your own and use modern formulas to perform calculations.Charts and graphs help you present your data in compelling ways, with formatting, sparklines, and tables to better understand your data. Easily create forecasts to predict trends with just a click.
BASICS & OVERVIEW
ADVANCE EXCEL –LEVEL 1
ADVANCE EXCEL LEVEL 2 –WITH PIVOT TABLES, MACROS, AND FORMULAS& FUNCTIONS
CREATING CHARTS AND GRAPHICS
USING ADVANCED EXCEL FEATURES
ANALYZING DATA WITH EXCEL
ADVANCE EXCEL WITH FINANCIAL MODELLING
MS EXCEL FINANCIAL FUNCTIONS (TO CALCULATE DEPRECIATIONS)
BUSINESS AND FINANCIAL DATA VALIDATION
WORKING WITH FINANCIAL DATA (To sort list, salary list, stock list etc.)
BUSINESS AND FINANCIAL FUNCTIONS (Investment & share details etc)
MUST TOOLS FOR EVERY BUSINESS AND FINANCE PROFESSIONAL (Trial balance, balance sheet, cash flow etc)
DATA CONSOLIDATION (EMPLOYEE SHEET, SALES BUDGET, ETC)
PIVOT TABLE AND PIVOT CHARTS – A MUST LEARN TOOL Using Your Own Data (stock data, cash flow, trial balance)
