About this course
Microsoft Office Excel 2013 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. You will learn how to print spreadsheets, add hyperlinks, save worksheets as web pages, and more!
* You have 4 weeks to complete this course from date of your enrollment.
Microsoft Excel 2013 Module 1 Chapters 1 - 5
Excel Basics
Module one introduces you to the basic features that Microsoft Excel 2013 provides. You'll become familiar with user Ribbon interface, commonly used tabs and command buttons, as well as how to customize the Quick Access toolbar. Creating a basic spreadsheet, how to enter data and create cells will also be covered. You'll also learn the importance of creating custom headers and footers to keep information organized.
- Ribbon User Interface
- Creating a Spreadsheet
- Cell Formatting
- Page Setup
- Headers and Footers
Microsoft Excel 2013 Module 2 Chapters 6 - 9
Managing Worksheets and Data
Module two focuses on organization and managing worksheets, data and reports. You will learn how to name your cells and formulas, attach comments and control when you recalculate a worksheet. Filtering and data analysis tools are also introduced as an easy way to keep your information organized.
- Maintaining the Worksheet
- Naming Formulas
- Summary Reports
- Formatting Tables
- Filtering Reports, Columns and Rows
Microsoft Excel 2013 Module 3 Chapters 10 - 11
Working with Media and Data Lists
Module three provides you with easy solutions for creating professional looking charts with just a few clicks. You will be introduced to the steps for adding graphics, inserting clip art, WordArt and SmartArt and how to represent data visually. Learning how to move and embed charts, as well as applying filters and various styles will enhance your data lists and help with organization.
- Creating Charts
- Adding Graphics
- Using Custom Filters
- Sorting on Multiple Fields
- Moving and Resizing Charts
Microsoft Excel 2013 Module 4 Chapters 12 - 14
Excel Features
Module four addresses add-ins for automating Excel 2013 to increase productivity, as well as tips and tricks for formatting worksheets efficiently. You will become familiar with how to add hyperlinks to workbooks, Office documents or e-mail and how to automate frequently-used formulas with macros. Various ways of sharing your worksheets on the internet and through web applications is also covered.
- Excel Add-Ins
- Linking Spreadsheets
- Top Ten Beginner Basics
- Ten Commandments of Excel 2013
- Adding Hyperlinks
