Category archives: Microsoft Excel Training Courses
How to use Google sheets
Micrsoft Excel Intermediate 1 day
Microsoft Excel Advanced
Microsoft Excel Intermediate
Microsoft Excel Pivot Tables
Lesson 1Create a Pivot Table report and manage the report’s layout.Lesson 2Extract data using Label, Value and report filters.Lesson 3Insert and manage Slicers to filter data.Lesson 4Generate additional subtotals by grouping both dates and numbers.Lesson 5Output statistics using COUNT, MAX and AVERAGE functions.Lesson 6Control Pivot Table number formatting.Lesson 7Summarise numbers with percentage analyses.Lesson 8Create a …
Get to grips with Microsoft Excel Macros
Lesson 1Plan your macro before the recording process, and understand the principles of recording.Lesson 2Recognise the versatility of a Relative Referenced macro.Lesson 3Name a macro, record and run macros in an Excel file.Lesson 4Run macros with keyboard shortcuts, Quick Access toolbar and Ribbon buttons.Lesson 5Save files containing macros as Excel Macro-Enabled Workbook file type.Lesson 6Produce …
Microsoft Excel Foundation
Lesson 1Create a Table: Creating an Excel table from scratch. Wrapping text in cells. Formatting table content. Speed up data entry with AutoFill. Sorting columns.Lesson 2Inserting Functions: Inserting and managing function calculations. Using AutoSum to sum numbers. Inserting statistical calculations AVERAGE, MAX and MIN.Lesson 3Managing Rows and Columns: Inserting and deleting table rows and columns. …