Advanced Excel Training
Advanced Excel Training for Corporate's, Professionals & Students:
Advanced Excel Training course offered by Excel Prodigy. that makes you master in microsoft excel. We have conducted 750+ Corporate Training and Trained more than 22,500+ Professionals on Advanced Excel, VBA Macro, PowerPoint & Ms Office in India & International.
Advanced Excel Training Overview:
Our Advanced Excel training course will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. Find out how you can utilise advanced ‘If’ statements.
Advanced Excel Training Course
Course Duration of Advanced Excel Training Course: 16 Hours (2 Days)
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
The VLOOKUP/HLOOKUP Functions
Excel 2007 & 2010 Quick Overview
Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features
Basic Formula of Advanced Excel Training Course
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function and power BI
Pivot Tables – Advanced Excel Training Level
Extracting Records with Advanced Filter. Using Formulas In Criteria
Sorting by Top to Bottom / Left to Right. Creating / Deleting Custom List. Sort by using Custom List…
Hyper / Data Linking
Hyper linking data, within sheet / workbook. Linking & Updating links between workbooks & application.