Advance Excel Skills
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.
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
Microsoft Excel New Features
Text to Columns
What If Analysis
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