GET THIS COURSE ONLINE
Do this course at home at your own pace
- Online videos 24x7 lifetime access
- Full written notes provided
- Ongoing support included
Ask for your money back within 30 days
for any reason if this isn't right for you !
This 1 day intermediate Excel course is designed to improve your productivity within Excel. You'll discover the most useful and most commonly used parts of Excel - the features that can be used by anybody in any type of business.
You'll master techniques to achieve quick results and produce slicker, more efficient workbooks that are better laid out, more consistent and easier to maintain.
This course is designed for people who have used Excel regularly for a minimum of 45 days. Please view the contents of the beginners Excel course and make sure that you are comfortable with 80% of the contents before considering this course.
If you're note sure what level you're really at, why not take our free Excel Health Check and get an instant scorecard?
Our computers are always installed with the latest version of Office. The current version is Excel 2019 / Excel 365 (desktop).
If you have an earlier or Excel such as Excel 2016 or Excel 2013 we will explain any key differences during the training.
Still using Excel 2010 or earlier? It's time to say goodbye to an old friend and upgrade! Microsoft don't support this version any more.
Want To Customise Your Training Content?
Don't see exactly what you want in the topic list below?
You are welcome to swap topics in and out from the different courses available to create your own custom course.
We can accommodate all requests. Customisation is 100% free.
Let us deliver a powerful course with useful content that you or your staff will actually use. Tailor the training around your own needs and requirements.
Working with Excel databases
- Entering data using AutoComplete
- Entering data using Pick From List
- Creating Spark Lines
- Flash Fill
- Filtering data using the standard and advanced filters
- Sorting rows by value, colour or icon.
- Sorting data using custom lists
- Multi-level sorting
- Re-ordering table columns without the mess
- Creating automatic subtotals
35 of Excel's Most Useful Formula Functions
- Brief recap of the five basic functions
- SUM, AVERAGE, MAX, MIN, COUNT
- Using the Function Wizard
- Smart ways to propagate formulas
- COUNT functions - COUNT, COUNTA, COUNTBLANK
- Invaluable COMBO functions - COUNTIF & COUNTIFS, SUMIF & SUMIFS, AVERAGEIF & AVERAGEIFS
- MAXIF & MAXIFS, MINIF and MINIFS
- Handy LOGICAL functions for tables - AND, OR, IF
- Date and Time functions
- TODAY, NOW, DAY, MONTH, YEAR, DATE, HOUR, MINUTE
- ROUNDING functions - ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, ABS, TRUNC
- PI (for engineers & mathematicians)
Advanced Formatting Techniques
- Establishing a theme
- Conditional formatting
- Using data bars, colour scales and icon sets
- Two ways to use the Format Painter tool
- Using styles and style sets to improve consistency and maintainability
Absolute vs Relative Cell Addressing
- Using AutoFill and Smart tags
- Absolute cell addressing?
- The importance of dollar signs
- F4 - The magic key
- Partially-absolute addressing
Naming Cells & Cell Ranges
- Naming a cell using the Name box
- Naming cells using the Name Manager
- Creating a constant
- Using named cells for navigation
- Using named cells within a formula
- Modifying and deleting named cells
- Creating names from existing headings
- Applying names to existing formulas
- Displaying a list of named cells
Tools To Validate Data
- Setting the rules
- Giving instructions to the user
- Alerting the user of an error
- Conveying the severity of invalid data
- Highlighting invalid data
- Creating a chart using the new Chart Ribbons
- Modifying a chart
- Changing the chart type
- Changing the source of the data
- Setting the chart options
- Showing or hiding different chart components
- Changing the chart location
- Selecting and formatting a chart component
- Applying a gradient, texture, pattern or picture fill to a chart component
- Manipulating 3D charts
- Using the Chart toolbar
- Creating and saving custom chart types
- Previewing and saving a chart as a web page
Grouping Data The Sophisticated Way
- Creating an outline manually or automatically
- Collapsing and expanding an outline
- Removing one or all groups
- Expanding the range of an group
- Using groups with charts