Microsoft Excel 365 – Intermediate: Student Manual (Black & White)

Note: This is the black & white version of the student reference manual designed for instructor-led computer training. Can also be used as a self-paced tutorial for learning intermediate concepts of Microsoft Excel 365. To download the exercise files that accompany this title, please visit http://www.ezref.com/exercise-files/ For the color instructor guide, search for ISBN-13: 9798639331107 For the black and white instructor guide, search for ISBN-13: 9798639058028 For the color student manual, search for ISBN-13: 9798639056062 For the black and white student manual, search for ISBN-13: 9798639048142 For information regarding unlimited printing with the ability to customize our courseware, please visit our website: www.ezref.com Topics Covered for Microsoft Excel 365 – Intermediate (6-8 hours): Find/Replace Using Block Names Working With Dates Advanced Functions Creating a Database Sorting Records AutoFilter & Custom Filters Working with Tables Creating an Array Formula Linking Files Creating a Workspace Protecting Blocks/Worksheets Freezing Panes Splitting the Screen Hiding Columns/Blocks Multiple Worksheets & Tabs Working with Chart Sheets Hyperlinks Sharing Workbooks Tracking Changes Adding Cell Comments Conditional Formatting Formatting Shortcuts Custom Formats