Excel Level 1: Worksheet Fundamentals  

October 11 & 12, 2023 – 2PM to 5PM  

Instructor: Mike Rhodes, MediaTek

Note – this is a full day course split into two half days

Learn the fundamentals of excel. Perfect for a beginner who wants to learn the basics in excel. If you take this course, be sure to follow on with Level 2 offered later in the month!

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 & move cells
• Automatically compute a row or column total
• Insert & delete columns and rows
• 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 & columns of a worksheet
• Change the page setup of a worksheet
• Preview a worksheet
• Insert a manual page break into a worksheet
• Prince selected worksheet entries
• Use excel functions (Sum, average, max, min and count)

Register here