2011 – Microsoft Excel 2013 Core EssentialsDownload Course Outline
Title: Microsoft Excel 2013 Core Essentials 2011; 1 Day; Instructor-led
Description: This course covers all the essentials of Microsoft Excel 2013. Topics covered include the new Flash Fill feature and other time saving features, using formulas and functions and customizing the interface. Material is also included on how to format text, data, and workbooks, how to chart data, and how to print and share workbooks in different formats.
At Course Completion:
Audience & Prerequisites:
Course Outline Details: Module 1: Customizing the Interface Lessons Collapse and Expand the Ribbon Customize the Quick Access toolbar Module 2: The Basics Lessons Examining parts of a workbook How to create, open, and save workbooks How to enter, select, and delete data Using undo and redo Using cut, copy, and paste functions Module 3: Working with Data Lessons Inserting rows and columns How to merge and split cells Using Paste Special Find and replace Hiding and unhiding cells Module 4: Using Basic Excel Tools Lessons Basic formulas Using Cell references in formulas Using basic functions Using sorting and filtering tools Module 5: Using Timesaving Tools Lessons Using AutoFill Using Flash Fill Using AutoSum Using AutoComplete Using AutoCalculate Module 6: Formatting Text, Data and Workbooks Lessons Changing font face, size, and color Adding borders and fill to cells Clearing formatting from text How to adjust text wrapping Changing the size of rows and columns Adjusting cell alignment Changing text direction Applying number formatting How to use cell styles Formatting data as a table Inserting page break Module 7: Charting Data and Other Graphics Lessons Creating Charts Chart Formatting Tools Inserting Text Boxes Module 8: Viewing, Printing, and Sharing Your Workbook Lessons Using workbook views Saving a workbook as PDF Printing a worksheet E-mailing a workbook Sharing a workbook on OneDrive
Start Date: 10/04/2019
End Date: 10/04/2019