Improve the way you manage and present information and take the legwork out of calculations and data manipulation with this powerful software. This course provides the learner with the skills and knowledge necessary to create workbooks in Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting. Course Content Getting to know Excel Starting Excel The Excel screen Using the ribbon Using keytip badges Minimising the ri... [More]

Microsoft Excel Level 3 focuses on the more advanced features of Excel. Advanced analysis tools, especially pivot tables, solver, outlining and summarising are covered, as are some key automation features such as macros. Course Content Lookup functions: Understanding data lookup functions; Using CHOOSE; Using VLOOKUP; Using VLOOKUP for Exact Matches; Using HLOOKUP; Using INDEX; Using MATCH; Understanding reference functions; Using ROW and ROWS; Using COLUMN and COLUMNS; Using ADDRES... [More]

Microsoft Excel Level 2 is the second of a 3-Level study program for Microsoft Excel. This level extends the learner’s basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features and working more effectively with existing worksheets and workbooks. Course Content Filling data: Fil... [More]

Learn how to use a combination of Excel and VBA to improve your productivity, adding power and flexibility to spreadsheets by creating user-defined functions. Basic knowledge of Excel is assumed but no programming knowledge is required. Course Content Recorded Macros: Understanding excel macros; Setting macro security; Saving a document as macro enabled; Recording a simple macro; Running a recorded macro; Relative cell references; Running a macro with relative references; Viewing a ... [More]