Microsoft Excel Intermediate
MS Office Training Ltd
Small groups max 4 attendees, Trainer led Live online classes and 1 year email support
Summary
Classroom training - £275 for 1 day training
In Company training - £550 daily rate for...
- Tutor is available to students
Add to basket or enquire
Location & dates
Clifton Street
City Of London
London
EC2A4HB
United Kingdom
Overview
Description
Recap on Excel formulas and calculations
- Overview of formulas in Excel
- Relative, Absolute and Mixed cell references
Group editing worksheets
Autofill and Flash Fill
Changing Excel’s environment Options
- Changing the default number of sheets
- Creating an Autofill Custom List
- Adding tools to the Quick Access Toolbar
Mastering Excel Tables
- Introducing Excel Tables
- Formatting a Table
- Creating Calculated Columns
- Using Slicers to filter your data
- Using Totals to get statistics out of your data
- Removing duplicates
- Converting Tables back to normal Ranges
Using names Ranges
- In Excel formulas
- As a way of navigating through the workbook
Advanced Formulas
- Simple IF examples
- Using IF to check if a cell is blank
- Nested IFs
- VLOOKUP
- HLOOKUP
- Text Functions
- Date Functions
Conditional formatting
- Apply Conditional Formatting
- Customising Conditional Formatting
- Using Icons in Conditional Formatting
- Using Formulas to conditionally format cells
Linking spreadsheets and workbooks
- Making a reference to another worksheet
- Making a reference to another workbook
- Editing links
- Troubleshooting links
Analysing databases
- Quick analysis
- Sorting a database
- Apply filters to a database
- Advance filter
- Sorting and Filtering by Conditional Formats
Charts
- Analyse trends in data using Sparklines
- Creating charts from start to finish
- Exploring the different Chart Types
- Apply Chart Styles
- Formatting Chart Elements
- Filtering Charts by Series or Categories
- Adding a Trendline to a Chart
- Create a Chart Template
Attaching security to a spreadsheet and workbook
- Protect Cells
- Protect Structure of worksheets
- Protect a Workbook by adding passwords
Introduction to Pivot Tables
- What are Pivot Tables?
- Using recommended pivot tables to analyse your data
Who is this course for?
For those who want to explore in more detail formulas and functions, data analysis and data presentation.
Requirements
Preferably, delegates would have attended the Excel Introduction course.
Career path
Excel know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
Questions and answers
Reviews
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.