Microsoft Excel Training Course

By: Multitask Training - Microsoft Training Courses  12/06/2014
Keywords: charts, calculations, Formula

Course outlines are for guidance and can be adjusted to suit your requirements. Excel Foundation - 1 day Excel Basics • Exploring the screen • Understanding the concepts • Entering & editing data • Moving & copying • Selecting techniques • Autofill • Saving & opening Formats • Cell formatting • Row & column options Formula • Calculations (+-*/) • Autosum • Functions (i.e. average) • Percentages • Relative & Absolute Further Formats • Text wrap • Merging cells • Borders / shading • Conditional formatting Worksheets • Inserting / deleting / renaming sheets • Moving and copying sheets Printing and Viewing your Workbook • Setting up your printing options • Freezing the headings and other view options Introduction to Charts • Creating a simple chart • Chart elements • Format options Excel Intermediate - 1 day Excel Basics - Review • revisiting simple formula • Autosum • Percentages • Autofill Other Features • Comments • Range names • Hyperlinks • Absolute cell referencing • More on conditional formatting Functions • Counta, Count blank, Countif • Sumif • If statements • Date calculations • Tracing elements & the watch window Linking • Linking across sheets and workbooks • Grouping sheets Data Options • Sorting and filtering • Data form • Subtotals • Outline and grouping Charts • Further charting functionality • Multiple axis • Tricks and ideas Excel Advanced - 1 day Protection & Control • Protecting your worksheets and workbooks • Data validation • Further Formula & Lookups • Nesting formula • Logical functions (i.e. and, or, not) • Error handling • VLookups Pivot Tables • Creating and control pivot tables • Creating pivot charts • Slicers Data Consolidation • Summarising data from multiple worksheets Text & Date Functions • A guide to the text and date functionality to perform calculations Macros • Recording • Saving • Using Further Features (subject to time) • Goal seek • Auditing tools • Templates • Scenarios • Data tables

Keywords: calculations, charts, Excel Training Course Essex, Formula, Multitask Training, Pivot tables,

Contact Multitask Training - Microsoft Training Courses

Email

Print this page