Mastering Microsoft Excel

ID : 6699

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.
Agenda
Unit 1
Excel From The Ground Up
Why businesses use Excel for spreadsheet management
Technical requirements to use Excel (and all Office modules)
Launch Excel and create your first Excel worksheet
Discover how to protect and save your document
Set your document’s Properties and Attributes including Subject, Title and Author
Unit 2
Excel Document Creation
Explore the different parts of the Excel worksheet and document navigation
Understand cells and their makeup
Learn how to populate, format and merge cells
Create multiple worksheet “workbooks”
Learn how to insert comments and check spelling
Unit 3
Advanced Features and Functionality
Create and manage formulas and functions
Filter and sort tables and data
Create “live” connections between multiple worksheets
Create effective and informative table and charts
Unit 4
Excel Management and Sharing
Create meaningful file names and understand filing systems to manage Excel documents
Organize your documents on your hard drive and learn how to copy and move documents
Manage track changes when co-authoring documents
Printing and PDF file creation including setting print areas
Learn how to export Excel tables and charts to PowerPoint presentations and Word documents
Use Outlook to send Excel worksheets and workbooks to other users