Essential Excel Spreadsheet Skills (IT008C)

It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures.

Nothing is more powerful than having clear and accurate data to make meaningful and useful decisions about your company, business units, product cycles, sales projections and operating requirements in order to forecast your business futures. This programme is directed at the businessperson who needs to use Excel in their everyday job to improve decision-making and productivity.

Programme Outline:

• Spreadsheet Concept & Structure
• Effective spreadsheet structure
• Designing input & output areas
• Macro designing & the use of subroutines
• Setting up data test plan Building Basic Formulas
• Understanding formula basics
• Controlling the order of precedence
• Controlling worksheet calculation
• Working with range names & links in formulas Creating Advanced Formulas
• Working with arrays
• Applying data validation rules to cells
• Using dialog box controls on a worksheet Spreadsheet Calculation Techniques
• Working with Excel’s functions
• Building megaformulas with function nesting
• Using Lookup tables & the If functions
• Understanding & using NPV, IRR, SPB, DPB, NFV, MIRR, etc
• Solving circular references Spreadsheet Consolidation & Linking
• Linking data between worksheets
• Working with Consolidate interface
• Interfacing with other applications
• Working with Pivot Tables & Scenarios Charting Techniques & Presentation
• Representing data in charts
• Plotting data interactively
• Controlling graphic objects Auditing & Debugging
• Understanding Error values
• Testing the cell logic
• Auditing a worksheet