WeAreExcel have now introduced bitesize 1 hour Excel training sessions as well as MS Word and PowerPoint sessions held virtually via zoom!
Our bitesize training sessions are suitable for companies with employees who are unable to have a whole day out of the office or for companies who just want topic focused sessions.
Scroll further down this page to see further information on our bitesize training sessions.
Alternatively you can click one of the below buttons.
Contact Us Today
Bitesize 1 Hour Excel Training
L1 Excel Bitesize topics
- Session 1 – Shortcuts and Data fundamentals, including Dates, Text, Numerical values and Time
- Session 2 – Arranging data the correct way and Sorting, Filtering and applying SUBTOTALS
- Session 3 – Basic calculations SUM, AVERAGE and Percentages and Use of $ with absolute references
- Session 4 – Page Layout Settings for PDF conversion and Printing, Useful viewing features e.g., freezing panes and Splitting screen and working on your files through multiple windows
- Session 5 – Creating basic charts – inc. Bar charts, Line charts and Pie charts and other Visualisation features
- Session 6 – Worksheet protection features to prevent and/or limited users from making unwanted changes to your spreadsheet
L2 Excel Bitesize topics
- Session 1 – Automatic formatting with Conditional Formatting and controlling data entry with Data Validation – including creating Drop-Down menus for accurate and consistent data
- Session 2 – Working with Dates and Time to age things and forecast date through Date and Time Functions
- Session 3 – Using formulas to make decisions using the IF Function
- Session 4 – Adding, Counting and Averaging subsets of data from a table using SUMIF(s), COUNTIF(s), AVERAGEIF(s)
- Session 5 – Finding & copying data with XLOOKUP
- Session 6 – Excel Intermediate 7 – Analysing data with Pivot Tables and Pivot Charts
- Session 7 – Understanding Dynamic arrays and troubleshooting formulas errors like #VALUE, #NAME, #DIV/0 and #SPILL
- Session 8 – Clean and manipulate data with text functions like TRIM, LEFT, RIGHT, FIND and others – including use of FlashFill
- Session 9 – Using Range Names as an alternative to adding $ symbols to cell references and using formula Auditing tools
L3 Excel Bitesize topics
- Session 1 – Making decisions through Nested Logical Functions – IF, AND, OR
- Session 2 – Finding and copying data with Nested XLOOKUP functions – sophisticated Lookup techniques
- Session 3 – Finding and copying multiple records using FILTER function
- Session 4 – Introduction to Automating repetitive spreadsheet tasks with use of simple recorded macros (VBA)
- Session 5 – using WhatIF analysis tools such as Goal Seek and Data Tables to forecast results from formulas
- Session 6 – Using Conditional Formatting with Logical formulas and Functions like AND and OR and NOT
1 Hour Excel Training Pricing:
| Number of Delegates | Price Excl VAT (Per Hour) |
|---|---|
| 1 – 3 Delegates | £ 150.00 + VAT |
| 4 – 6 Delegates | £ 190.00 + VAT |
| 7 – 8 Delegates | £ 210.00 + VAT |
| 9 – 10 Delegates | £ 230.00 + VAT |
| 11 – 12 Delegates | £ 250.00 + VAT |
| 13 – 15 Delegates | £ 290.00 + VAT |
Maximum 2 x 1 hour sessions per day
To enquire about Bitesize Excel training please call 020 7183 7740 or email enquiries@weareexcel.co.uk
Read here what our customers have said about our Bitesize 1 Hour Excel Training sessions!
Bitesize PowerPoint Training
Introduction/Intermediate PowerPoint Bitesize topics
Session 1:
- Using different Views including the OUTLINE VIEW to create the structure of a presentation
- Creating and adding objects to slides – including Tables, Charts and Diagrams
- Linking objects to Excel spreadsheets and other external files
Session 2:
- Using Design Themes and other presentation formatting tools
- Using predesigned content templates and creating individual templates
- Using slide transitions and content animation effects
- Use of the Slide Masters
Session 3:
- Using embedded and on-line Videos
- Inserting and modifying pictures
- Using Screenshot to insert pictures
Session 4:
- Navigating presentation slides with Hyperlinks and, Actions buttons
- Use of Custom Shows
Session 5:
- Organising, rehearsing, and recording slide presentations
- Adding speaker notes
Our Pricing:
| Number of Delegates | Price Excl VAT (Per Hour) |
|---|---|
| 1 – 3 Delegates | £ 150.00 + VAT |
| 4 – 6 Delegates | £ 190.00 + VAT |
| 7 – 8 Delegates | £ 210.00 + VAT |
| 9 – 10 Delegates | £ 230.00 + VAT |
| 11 – 12 Delegates | £ 250.00 + VAT |
| 13 – 15 Delegates | £ 290.00 + VAT |
Maximum 2x 1 hour sessions per day
To enquire about Bitesize PowerPoint training please call 020 7183 7740 or email enquiries@weareexcel.co.uk
Read here what our customers have said about our Bitesize PowerPoint Training sessions!
Bitesize Word Training
Introduction Word Bitesize topics
Session 1:
- Creating documents including use if Templates
- Shortcuts for navigating around your Word document and selecting data.
- Adding text, Bulleted lists, numbered lists to your Word document
- Managing Paragraphs
- Tabulating data in your document
- Saving options including file formats and protection options
Intermediate Word Bitesize topics
Session 1:
- Working with Page Breaks and Section Breaks
- Using Page Layout settings including margins and column formatting
- Working with Pictures, Tables, Diagrams and Chart objects
- Creating and managing Headers & Footers including Page numbering
Session 2:
- Using and managing Styles throughout your Word document
- Creating and managing Table of Contents
- Using Footnotes and Endnotes
- Sophisticated use of Headers & Footers between sections
Session 3:
- Tracking changes throughout your document
- Reviewing and proofing your documents
Our Pricing:
| Number of Delegates | Price Excl VAT (Per Hour) |
|---|---|
| 1 – 3 Delegates | £ 150.00 + VAT |
| 4 – 6 Delegates | £ 190.00 + VAT |
| 7 – 8 Delegates | £ 210.00 + VAT |
| 9 – 10 Delegates | £ 230.00 + VAT |
| 11 – 12 Delegates | £ 250.00 + VAT |
| 13 – 15 Delegates | £ 290.00 + VAT |
Maximum 2 x 1 hour sessions per day
To enquire about Bitesize Word training please call 020 7183 7740 or email enquiries@weareexcel.co.uk
Read here what our customers have said about our Bitesize Word Training sessions!
There are currently no reviews for this provider
Looking for Excel Open courses? Please click here