In-House Computer Training Available!
Have a large group that needs this training? We can bring this course to you!
For more information, call Suzanne Hills at 848-932-7234 or send an email to firstname.lastname@example.org.
We also Offer Other Excel Training Classes!
Please visit our Computer Classes page for all upcoming course offerings.
This workshop is designed for students looking to build on the advanced features learned in Excel – Level 3 of Microsoft Office Excel worksheets.
By attending this class, attendees will gain a functional knowledge of Excel and how to use it in conjunction with the other Microsoft sister products.
Upon successful completion of this course, students will be able to:
- Create a template
- Write visual basic programming script
- Use complex spreadsheet functions including Goal Seek and PMT
- Create macros
- Add notes and comments on cells
- Use Word Art as an object
- Add hyperlinks and attach spreadsheets to email
- Use MS Website to download additional features
- Use web toolbar and the form toolbar
Students will learn some timesaving tips and shortcuts to work more quickly and efficiently, and the instructor will set aside time to answer specific questions.
Computers will be provided for hands-on learning. Students will complete instructor-led practice exercises to reinforce new skills.
Note: While Microsoft Office Excel 2016 will be used for in-class demonstrations and hands-on practice, most of the skills taught in this class are also applicable to older versions of Excel. Windows operating system is used for instruction in all Microsoft Office workshops.
Prerequisite: Microsoft Office Excel Level 3 required
Want to read more about what you'll learn in Excel Level 4? View a detailed agenda.
- Creating a Template
- Using the Microsoft Website to Download Additional Features
- Creating Advanced Calculations
- Breakeven analysis
- Working with complex functions (using PMT)
- Learning how to understand additional functions
- Creating "adjusting" tables
- Enhancing Worksheets with Active X Controls
- Creating control objects in worksheets
- Creating a Macro
- Using Macros
- Protecting a worksheet
- Adding Notes and Comments on Cells of Worksheets