Excel Level 1: Worksheet Fundamentals
Wednesday, October 11, 2023, 2:00 PM - 5:00 PM ADT
Category: Continuing Professional Development
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
Contact: [email protected]
|