Excel Training in Brighton and Beyond

Brian Roberts

Excel Trainer since 2009
Computer Systems Developer since 1982
Tailored to your needs
Flexible dates and times

Excellent Excel Training

My Training Deck includes illustrated explanations and worked examples.

I use these to demonstrate each Excel feature, step-by-step.

I then watch you do the practice exercises in the Training Deck.

Here's a snippet from the Training Deck:

I provide a copy of the Training Deck so that you can focus on understanding - rather than writing notes.

The training refers to Case Studies from consultancy I have performed for previous customers such as:

Stock Control systems for a golf equipment retailer and a beauty products manufacturer
Portfolio Reporting and Analysis for a crypto currency trader and a stock market investor
Exercise Monitoring and Reporting for a fitness trainer
Bookkeeping and Cash Control for an international charity

Prices

£420 for half a day (3.5 hours) to train up to six students at your office in Brighton.
The Beginner's Course and the Advanced Course each take half a day.
For one-to-one training or consultancy, I charge £60/hour on weekdays, £80/hour at weekends. I will be happy to provide a competitive quote for:
- teaching selected Excel features
- teaching outside Brighton
- helping with particular questions related to your own spreadsheets
- restructuring and rebuilding your spreadsheets to help you work more efficiently.

Contact

Press here to send an email to
briandroberts@hotmail.com

If you omit the d in my email address, your email will go to another Brian Roberts!!
Press here to phone
0777-569-5059

Recommendations

'Dear Brian

I rate your training as super excellent!

I was extremely nervous that I had forgotten lots and worried that I wouldn't be able to do the Excel training.

But with your excellent, calm, comprehensive training - I felt much more confident.
I learnt so much and we covered so much more than I could've hoped. Fantastic idea to show you and explain how to do tasks. And then practice on your laptop for full understanding.

Highly recommend.

I definitely won't worry about going for jobs now with Excel experience.

Thank you so much I will tell all my pals about you'.

Sharon

Sharon was learning Excel for a job interview.

Qualifications

BSc (Honours), Maths,
Southampton University
PTLLS teaching qualification,
City College, Brighton

MSc Management Science, Imperial College. Specialised in Operational Research - the use of mathematical modelling to analyse complex situations and make more effective decisions in industry, commerce and government.

Beginner's Excel Course

Introduction to Excel: The Excel Screen, Using the Ribbon, The Quick Access Toolbar, Saving, Opening, Closing a Workbook, Moving around the Worksheet
Entering Data: Entering, editing and deleting data, Undo and Redo, Filling Cells, Cut Copy and Paste, Using the Windows Clipboard
Working with Rows and Columns: Inserting and Deleting Columns and Rows, Change Column Width, Change Row Height, Hide and Un-Hide Columns
Formatting Cells: Highlighting Methods, Formatting Text, Formatting Numbers, Alignment of Cells, Merging Cells, Wrapping Text, Borders and Shading,
Working with Worksheets: Renaming, Inserting Worksheets, Moving and Copying, Deleting

Advanced Excel Course

Absolute Cell Addressing: (Recap) Using Absolute References
Naming Cells and Ranges: Setting up Range Names, Scoping a Range Name, Using the Range Name Manager, Using Names in Formulas
Data Consolidation: Linking Worksheets with Formulas, Linking Workbooks, Viewing Links
Conditional Functions
Introduction to If
Using Nested Ifs
Using SumIf and CountIf
Lookup Functions: Using Vlookup, Using Hlookup
Data Validation: Using the Data Validation feature, Finding Invalid Data
Conditional Formatting: Setting Up Conditional Formats, Using Formulae in Conditional Formats, Using Conditional Formats to find MIN and MAX
Working with Data Lists: Sorting, Subtotals, Filtering
Pivot Tables: Using the Pivot Table Wizard, Modifying the Pivot Table
Data Tables: Creating Data Tables, One Way and Two Way Tables