- 1 Month
- 25 Hours
Advance excel training course includes Conditional formatting, Column editing, Pivot table, Advance functions, Formula auditing, Advance filter, Goal seek Reports .
Learn the foremost advanced formulas, functions and kinds of monetary analysis to be an Excel computer user . This advanced Excel training institute course builds on our free Excel crash program and is meant specifically for spreadsheet users who are already proficient and searching to require their skills to a complicated level..
This advanced tutorial will assist you become a world-class securities analyst for careers in investment banking, private equity, corporate development, equity research and FP&A. By watching the trainer build all the formulas and functions right your screen, you'll easily pause, rewatch, and repeat exercises until you've mastered them
Text Functions - UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,SEARCH,FIND,LEN,TRIM....
DATE & TIME - DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF....
FINANCIAL - DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,PRICE.....
LOGICAL - IF,AND.OR,NOT,TRUE,FALSE,IFERROR....
LOOKUP & REFERENCES - LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,INDIRECT,HYPERLINK....
MATHEMATICS - SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,FLOOR,COS,PI,ROUND,POWER,PRODUCT...
CREATE A MACRO, EDIT A MACRO, APPLY CONDITIONAL FORMATING, ADD DATA VALIDATION CRITERIA, UPDATE A WORKBOOK PROPERTIES, MODIFYING EXCEL DEFAULT SETTIING
COLLABORATING WITH OTHERS
PROTECT FILES, SHARE A WORKBOOK, SET REVISION TRACKING, MERGE WORKBOOK, ADMINISTRATOR DIGITAL SIGNATURE
CALCULATING DATA WITH ADVANCE FORMULA
MANAGE CELL & RANGE NAME, CALCULATING DATA ACROSS WORKSHEETS, USE SPECIAL FUNCTIONS, USING FORMULA TO SEPERATE DATA INTO SEPERATE COL., LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
Organizing Worksheet And Table Data
Create A Chart, Chart Element, Changing A Chart Type, Modifying A Chart, Format A Chart, Set Up Dynamic & Intreactive Chart, Calculating In Pivot Table
Trace Cell, Trouble Shoot Error In Formulas, Troubleshoot invalid Data And Formula, Watch And Evalute Formula
Create A Scenarios, Perform What-if-analysis, Perform Statistical Analysis, Anlysis Toolpack
Organizing Sheet And Table Data
Table, Create Table Dialog Box, Styles And Quick Style Set, Formate Table, Sort Or Filter Worksheet Or Table Data, Database function…….Dsum(), Daverage(),Dcount()
Inserting Graphics Object
Insert And Modify Picture And Clipart, Draw And Modify Shapes, Illustrate Workflow Using SmartArt graphics, Layer And Group Graphics Object, Customizing And Enahancing Workbook, Customizing Workbook, Manage Themes, Create And Use Template(ex-bills)
Import/Export & Publish
Exporting Excel Data, Importing Delimited Text File, Publish A Worksheet To The Web, Importing Data From The Web, Create A Web Query
Freelance Accountants, Business Owners, Students aspiring for a Career in finance, accounting & taxation. (12th, Undergraduates, Graduates, B.com, M.com, MBAs)