My promise to you
I never cancel or postpone a course, even if you're the only one attending. Nor will mess you around in any way.
I will provide you with Excel training of the highest calibre .
I will bend over backwards to make sure I give you all the best tips and shortcuts, warn you of every dangerous pitfall and answer every last question you have.
I will customise your training to make it more useful and relevant .
I will keep each class at just 4 hours, so it doesn't consume your whole day… Show more (but you still get all the good bits!).
This course trumps all others for outstanding value .
Groups are kept small and friendly, so you get individual attention when you need it.
I will give you back 100% of your course fee if you are not happy in any way.
Description
This course is designed to improve a user's productivity within Excel. It teaches the real meaty bits of Excel - the features that you'll find useful on an everyday basis. It shows techniques to achieve quick results and produce slicker, more efficient workbooks that are better laid out, more consistent and easier to maintain.
Pre-requisites
Before considering this course, students should be comfortable with 80% of the content on the beginners Excel course.
If you are not sure, use my free Excel health check at: www.thatexcelguy.co.uk/offer/thatexcelguy/health-check
You Must have a minimum of 2 months Excel experience behind them and Must Not attend the intermediate course immediately after the beginners course.
Inclusions
A laptop (or you can use your own if you prefer).
A full training manual valued at £20.
A certificate of completion.
Complimentary login to my Excel video training, valued at £70. Recap on your training, fill in your knowledge gaps and strengthen your weaker areas. Watch the videos in your pyjamas if you want!
The full set of course files so you can practice the exercises as many times as you want.
Ongoing support for as long as you need it.
Direct access to me.
An tax invoice/receipt will be issued for your records.
Free parking at venue.
TOPICS COVERED:
Following is a list of the topics that will be covered (time permitting). Some of these sections will be taught quite quickly, while more time will be given to key sections like formulas and functions.
Using Excel Functions
Using the Auto Stats on the Status Bar
Common truths about Excel functions
Using AutoSum
The five basic functions - Sum, Average, Max, Min & COUNT
Typing a function directly into a formula
Entering and editing a function using the function wizard
Using Count functions - Count, Counta & Countblank
Using Logical functions - And, Or & IF
Using Date and Time functions - Day, Month, Year, Date & TODAY
Using functions that manipulate numbers - Round, Roundup, Rounddown, Ceiling, Floor & TRUNC
Using combination functions - Countif & SUMIF
Conditional Formatting
Conditional Formatting
Highlighting values that fall in a range
Reviewing and changing your rules
Clearing Conditional Formats
Highlighting Duplicate Values
Highlighting the top 10 items in a list
Highlighting values that are above or below average
Using Data Bars
Using Colour Scales
Using Icon Sets
Customising data bars, colour scales & icon sets
Using the Format Painter tool to copy cell formatting
Changing the worksheet background
How to quickly format a table
Relative & Absolute Cell Addressing
Using AutoFill to copy a formula
Using the AutoFill Smart Tag
Relative Cell Addressing
Absolute Cell Addressing
F4 – The magic key
An example of completely-absolute cell referencing
An example of partially-absolute cell referencing
Naming Cells & Ranges
Why name cells?
Naming a cell using the Name Box
Naming a cell using the Name Manager
Creating a constant
Using a named cell within a formula
Using a named cell as a navigation tool
Changing the cell(s) that a name refers to
Removing a name from a cell
Using existing headings to name ranges
Applying names to existing formulas
Displaying a list of named cells
Creating Charts & Graphs
How to create a chart with 1 key press or 2 clicks
Creating a simple chart
Changing the chart type
Setting the chart title
Labelling the chart axes
Showing or hiding the gridlines
Displaying or hiding the Legend
Adding data labels
Showing a data table with the chart
Changing the chart colours
Adding or changing source data
Plotting hidden data
Switching rows and columns
Changing where a chart is placed
Formatting a chart component
Applying a gradient effect to a chart component
Applying a textured effect to a chart component
Using a picture to format a chart component
Manipulating 3D charts
Creating and saving customised chart types
Saving a chart as a web page
Analysing Data With Excel Databases
What is an Excel database?
Things to consider when creating an Excel database
Adding data to an existing table
Using the Auto-Complete feature
Picking an item from a drop-down list
Entering data using a Data Form
Entering data with flash fill
Using Sparklines to show data trends
Filtering data using the standard filter
Using a selection data filter
Using a numerical filter
Using a top 10 filter
Filtering data using the advanced filter
Sorting rows into order
Sorting rows using icon sets
Using custom lists to sort data
Sorting columns into order
Generating sub-totals for your data, automatically
Show less