Microsoft Excel – Intermediate

Once your conversant with the basics of Excel this course aims to provide you with the knowledge to use more advanced lookup and logical formulas to find and compare data. You will organise your raw data in Tables, possibly the “must know” formatting feature in Excel, before learning how to analyse the data with sorting and advanced filtering. You will also learn how to get started with Pivot Tables and present you data as charts.

Creating a Table
Adding and Removing Data
Working with the Total Row
Sorting a Table
Filtering a Table
Removing Duplicate Rows of Data
Formatting the Table
Using Data Validation
Summarising a Table with a Pivot Table
Converting to a Range

Choosing and Selecting the Source Data
Choosing the Right Chart
Inserting a Chart
Editing, Adding, and Removing Chart Data
Changing Chart Data
Changing Chart Layout and Style
Working with Chart Labels
Changing the Chart Gridlines
Changing the Scale Emphasising Data
Using Chart Templates
Changing Chart Type
Using Sparklines

Using Workbook Views
Selecting and Switching Between Worksheets
Inserting and Deleting Worksheets
Renaming, Moving, and Copying Worksheets
Splitting and Freezing a Window
Creating Headers and Footers
Hiding Rows, Columns, Worksheets, and Windows
Setting the Print Area
Adjusting Page Margins and Orientation
Adding Print Titles, Gridlines, and Row and Column Headings
Adjusting Paper Size and Print Scale
Printing a Selection, Multiple Worksheets, and Workbooks
Working with Multiple Workbook Windows
Creating a Template
Protecting a Workbook
Protecting Worksheets and Worksheet Elements
Sharing a Workbook

Formulas with Multiple Operators
Inserting and Editing a Function
AutoCalculate and Manual Calculation
Defining Names
Using and Managing Defined Names
Displaying and Tracing Formulas
Understanding Formula Errors
Using Logical Functions (IF)
Using Database Functions (DSUM)
Using Lookup Functions (VLOOKUP)

Sorting by One Column
Sorting by Colors or Icons
Sorting by Multiple Columns
Sorting by a Custom List
Filtering Data
Creating a Custom AutoFilter
Using an Advanced Filter

Related Courses

Microsoft Excel – Introduction

Get to grips with the basics of Excel. This course will enable you to perform simple calculations with confidence using formulas, navigate around the the Excel ribbon quicker and easier and learn the Excel shortcuts that will make your mouse redundant. See how to format your data to look professional both on screen or printed.

Microsoft Excel – Advanced

Turn unorganized data into useful information and quickly make spreadsheets your friends. Train IT Midlands’s lets people of any technical level learn exactly what they need to know at their own pace. The course starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.