Microsoft® Office Excel® Intermediate
Full day of hands-on, instructor-led training! Follow along on assigned PC.
Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates.
Using multiple worksheets and workbooks
Using multiple workbooks
Linking worksheets with 3-D formulas
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting
Outlining and subtotals
Outlining and consolidating data
Cell and range names
Creating and using names
Lists and tables
Sorting and filtering lists
Working with tables
Web and Internet features
Saving workbooks as Web pages
Chart formatting options
Documenting and auditing
Comments in cells and workbooks
Templates and settings
Creating and managing templates
All training classes must be pre-paid at least 5 business days prior to the class date. Due to the nature of training, and the need to maintain a minimum number of students in each class, cancellations are not allowed unless submitted in writing at least 5 business days prior to the class date. Cancellations must be submitted to email@example.com. No refunds are given. Payment will be applied as credit toward a future class, less a cancellation fee of $29.
Should you have any questions, please contact firstname.lastname@example.org.
Thank you for choosing AKUITY Technologies for your training needs.