Excel Intermediate
This course is suitable for people who have either attended an introductory Excel course or have a working knowledge of Excel functions that they wish to build on.
This course is delivered over 1 day from 9.30am to 4.30pm
Topics covered will include:
Building Spreadsheets
- Introduction, Outline & Objectives
- Functions and Formulae - Entering and Copying Formulae, Searching for Functions
- Naming Ranges - Creating Named Ranges, Using Names in Movement, Inserting Names in Formulae
- Formatting - Number Formatting, Cell Styles, Copying and Clearing formatting
Printing and Charting
- Printing - Setting up the Print Area, Previewing and Print Settings, [Page Layout] Choices
- Page Breaks - Inserting and Removing Page Breaks, Page Break Preview, Repeating Page Titles, Page Layout View
- Charting - Chart Types, Creating Charts, Customising Charts, [Design] options, [Layout] options, [Format] options
Printing and previewing Charts
What if?
- Conditional Formatting - Adding Rules, Modifying Rules, Date Driven Formatting
- Input Cells - Entering percentage Cells, Absolute ($) cell references
- IF() Function - Arguments, Entering conditions
- SumIf() and Countif()
Counting & totalling with conditions
Look Up Tables
- Using VLOOKUP () - Referencing Tables, Returning Columns
Exact Matching
Organising Worksheets and Workbooks
- Opening Workbooks
- Arranging Workbook Windows
- Creating Workspaces
- Opening Workspaces
- Totalling
- Copy and Paste Special
- Linking Formulae
- Editing Links
- Updating Linked Information
- Trusting Links
- Worksheets
- Inserting Worksheets
- Moving & Copying Worksheets
- Managing Worksheets
- Grouping Worksheets
- Hyperlinks
- Inserting Hyperlinks
- Hyperlink Targets
Lists
- Lists - Selecting Lists, Formatting as Table, [Table Tools]
- Sorting - Single Column Sorting, Multi Column Sorting
- Filtering - Text Filters, Number Filters, Date Filters
- Totals - Inserting Total Row, Adding Totals
- Pivot Tables - Creating Pivot Table, Adding Rows, Columns and Values, Manipulating Elements
Further Information and Booking
If you're interested in this course, please contact us:
Business Partnerships, York College, Sim Balk Lane, York, YO23 2BB
Email: businesspartnerships@yorkcollege.ac.uk
Tel: 01904 770368 option 1
Fee:
From August 2022 - £100
From August 2023 - £110
Next Course Dates
(Utilising laptops)
05/06/2023 (Campus@Northallerton)
20/06/2023
10/07/2023
17/07/2023
30/10/2023
31/10/2023
23/01/2024
27/02/2024
25/03/2024
05/04/2024
07/05/2024
03/06/2024
04/07/2024
05/07/2024
