They write:
Seeing as Microsoft Excel is one of the most popular software applications now, crafting a one-day training course that reflects the variety in the way that companies use Excel today is problematic.
The purpose of a beginners training course is to not only introduce new skills to each student. But, also, to give each learner the confidence to use those skills in everyday life. Hence, we at Computer Tutoring, have drawn on the experience we have gained in the 20 years of training Microsoft Excel in designing this Excel 2019 beginners training course.
Course Outline
Find your way around Excel 2019
- Working out the new spreadsheet interface
- Using Shortcuts in Excel (Best Practices)
- Create and Save a Basic Workbook
- Pinning often used files
- Searching for Files
- Quick Access Toolbar - (No more searching for buttons)
- Entering Cell Data
- Tips on Speeding up Data Entry in a Spreadsheet
- Using Excel Help - Accessing Free Video Tutorials
- Using the different zoom options
Learn how to Modify Worksheets in Microsoft Excel 2019
- Inserting, Deleting and Adjusting Cells, Columns, and Rows (Inc Shortcuts)
- Finding and Replacing Data
- How to make use of Smart Lookup?
- How to use Version History to Undo Mistakes?
- Using Spellcheck
- Adding, Renaming and Deleting Worksheets
Emphasising Spreadsheets by using Formatting
- See how to adjust the Font and Alignment
- Dealing with different currency formats & percentages
- Get the hang of date formats
- Gridlines, Borders and Background colours
- Learn how to change the colour of a cell based on value
- Gain consistency by using Styles in Excel 2019
How to Enter Calculations in Excel 2019?
- Learn how to enter basic arithmetic in Microsoft Excel (Addition, Subtraction, Multiplication, Division)
- Find out how to apply operator preference by using brackets in your formulas
- See how to copy down formulas by using AutoFill
- Discover how to use Absolute References ($) thereby opening up formula flexibility
- Explore the use of Functions in formulas, making everyday tasks easier
- Learn how to avoid common errors in Formulas?
- Reusing Formulas and Functions
- Create summary pages by calculating between worksheets
- Handling Common Errors (#NAME? | #N/A | #DIV)
Get to Grips with Printing in Excel 2019
- Discovering 2 new views to help you in printing your Excel files
- Learn how to set a print area
- Get the hang of fitting data onto a page
- See how to configure headers and footers
- Find out how to add page numbers
Everyday tips in working with Excel 2019
- View multiple spreadsheets
- Get the hang of using multiple windows
- Learn how Synchronous Scrolling can help
- See how freezing columns and rows makes data entry easier
- Find out how to use Custom Views