Solid Excel spreadsheet skills are essential in today’s business world. Learn the basics of Excel spreadsheets with this comprehensive introductory course. Gain confidence and develop skills that can be transferred immediately to the workplace with this ‘hands-on’ training.
Convenient and cost-effective training at your offices or online. The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate.
Certificates
Certificate of Completion
Digital certificate - Included
Description
This one day course will give you a solid foundation, with an emphasis on developing practical, real-world skills. It is suitable for people in any type of business.
Topics covered:
Excel Application window
Enter labels and values into a worksheet
Enter a formula into a worksheet
Adjust column width and row height in a worksheet
Open a new workbook
Use the Spelling Checker
Use an Excel template to create a workbook
Automatically fill a range
Copy and move cells
Automatically compute a row or column total
Insert and delete rows and columns
Realign cell entries
Reset font options for cell entries
Reset the number format of cell entries
Add borders and shading to a worksheet
Sort the records of a list
Filter the records of a list
Excel Tables
Insert comments into a worksheet
Split the Worksheet window into panes
Freeze the Worksheet window
Hide rows and columns of a worksheet
Change the page setup for a worksheet
Preview a worksheet
Insert a manual page break into a worksheet
Print selected worksheet entries
Use Excel functions (SUM, AVERAGE, MAX, MIN and COUNT)
Who is this course for?
This course is suitable for anyone who wishes to learn Microsoft Excel or become more proficient in the program.
Requirements
Basic keyboard and mouse skills. No prior knowledge of Microsoft Excel is required.