Microsoft Excel Intermediate - In-company

Course Objectives

The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.

'

Customer Feedback

• Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.

• Kelly Moreley - TACT

• Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.
• Jenny Price - Acer

1 year email support service

Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk

With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.

Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.

Tailored training courses:

In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.

Certificate of completion

Digital certificate - Included

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

For those who want to explore in more detail formulas and functions, data analysis and data presentation.

Preferably, delegates would have attended the Excel Introduction course.

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