OVERVIEW
In today's fast-paced, technical business environment, numbers are everything. Much of our success hinges on how well we can manage the data - statistics, planning, reporting - that we encounter on a daily basis. We learn how we are doing and discover our next course of action by studying numbers. An incredibly powerful tool for doing this is Microsoft Excel.
Â
Microsoft Excel is the standard spreadsheet application for both the business world and personal use. This training will teach you basic to advanced features of Excel.
TRAINING OBJECTIVES
By the end of the training course, participants will be able to:
Learn about overview of Advanced Microsoft ExcelÂ
Calculate with advanced functions & formulas.
Create and modify charts & graphs.
Analyze data using Pivot Tables and Pivot Charts
Learn about Macro
TRAINING CONTENT
Microsoft Excel New Features
Condition Formatting
Data Validation
Flash Fill
Text to Columns
What If Analysis
Group
Consolation
Â
Advanced Excel Functions
Sum, Sumif, Count, Now, Countif, Countifs, Counta, Countblank
Average, Min, Max, Date, Int, Mod, Left, Right, Mid, Dollar
Day, Month, Year, Day360, Today
Round, Rounddown, Roundup,
DSUM, DCOUNT, DCOUNTA, DMIN, DMAX, DAVERAGE
CONCATENATE, SUMPRODUCT
Lookup Function
If Function
PV Calculation
Chart Report
Â
Pivot Table
Â
Macro