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:
£110
Next Course Dates
Next course dates (Utilising laptops):
25/03/2024
5/04/2024
7/05/2024
3/06/2024
4/07/2024
5/07/2024
7/10/2024
5/11/2024
5/12/2024
27/1/2025
25/02/2025
27/03/2025
29/04/2025
19/05/2025
16/06/2025
15/07/2025
