Computer Tutoring writes:
You will learn Excel Best Practices which will result in:
- Saving oodles of time on your spreadsheets
- Easy to read & edit spreadsheets
- The ability to professionally present your data using eye catching tables and charts
Our customers are finding these sessions extremeley helpful (Trust Pilot Reviews).
Live Online Training Benefits:
- 3 Hours Live Instructor Led hands-on training
- Comprehensive Online Courseware
- Online Certificate of Completion
- No need to travel
Microsoft Excel Beginners - Book Online - £40 + VAT
Thursday 20th August - 13:30 - 16:30
Course Outline:
Formulas
- Simple Formula
- Using Cell References
- Operators
- Operator Preference
- Functions
- Copying & Renaming Worksheets
- Calculating between Worksheets
- Calculating Between Workbooks
- Absolute References $
- Change Calculation Options
10 minute break - Stretch your legs - Get your tea
Formatting
- Formatting Numbers
- Font Size & Colour
- Fill Colour
- Borders
- Cell Alignment
- Text Wrapping
- Cell Styles
- Format Painter
Printing
- Selecting the Print Area
- Margins
- Printing a Large Spreadsheet
Microsoft Excel Intermediate - Book Online - £40 + VAT
Thursday 27th August - 09:30 - 13:30
Course Outline
Formulas
- Vlookup
- Index Match
- if Function
- COUNTIF
- SUMIF
10 minute break - Stretch your legs - Get your tea
Pivot Tables
- Creating a Pivot Table
- Using Slicers & Timelines
- Creating a Dashboard
- Formatting
- Create a Pivot Chart
Data Handling
- Creating a Table
- Filtering Data
- Conditional Formatting
- Removing Duplicate Data
We really look forward to seeing you! If you have any questions in the meantime, please feel free to ask! info@computertutoring.co.uk