Target Audience: Participants should know the application of the following functions: VLOOKUP; IF; COUNTIF; SUMIF; TREND; GROWTH; REPLACE; EXACT; TRIM. Advisable for participants to attend the “Advanced Microsoft Excel Tips and Techniques for Management” program first.
About the Course:
Understand the more advanced functions on features of what Excel 2007 offers
Perform various statistical analysis using the statistical functions
Analyze data using some of the more advanced built-in features
Comprehend the more advanced text functions and its applications
Perform date and time calculations for a given period, or time
Incorporate multiple charts and understand the use of Histogram
Learn to use and invoke the Add-Ins
How best to apply a what-if analysis using the Solver
Click Here Advanced Microsoft Excel Functions and Features For Management Decision Making