|
Step by step training in all aspects of Excel applications with spreadsheet examples. Development of Macros to automate repetitive tasks and user form Excel tasks. Step by step development of VBA applications.VBA codes to copy in to your Excel VBA editor.Indexes from 3 of 7 training modules:Training level 101 introduce newcomers to Excel and remind older hands of the power of Excel working with Formulas and Functions. Easy to read in Microsoft Word step by step guide in English covering: > In depth Formula and Function rules, what is meant by Cell References, Absolute and Relative cell references, using the AutoSum function, AutoCalculate rules, Nesting arguments, Syntax rules, Insert rules, Naming cell ranges, Averaging, Counting, CountIf, SumIf, working with Text, using Constants, using the Paste Name dialog, and much more.LEVEL 201 TRAINING ? Extracting information for Decisions The do's and don?ts of data and text tables to make decision presentations clearer and easier. Step by step introduction using a data extraction problem as the example. Explaining the Vlookup and Hlookup functions and all Dfunctions. Applying Data validation, List validation, Text validation. Using Auditing options. Working with external data, external references, external data and external formula. And much more.p>LEVEL 301 TRAINING ? Working with Pivot Tables in Excel.Course Outline: Understanding pivot tables ? one of Excel's most useful features. Why Pivot Tables? Pivot table advantages, Pivot charting, Pivot table guidelines, step by step guide to creating pivot tables, working with pivot tables.Course 401 - What If analysis with Excel.Course 501 - How to develop macros for Excel automation.Course 601 - How to develop VBA modules for your Excel.Course 701 - How to Control user inputs to your spreadsheets with VBA UserForms.
|
