Microsoft Office 365 gives you the familiarity and power of Office with the flexibility of the cloud. With Office in the cloud, your applications and files are with you wherever you go, whether you’re working offline at your desktop, online, or on one of your devices.
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 45m
Skills Learned
After completing this online training course, students will be able to:
How to enter and work with data
Creating formulas, using SUM and AVERAGE
How to format font and utilize conditional formatting
Adding and subtracting columns and rows
Chart creation, formatting, and elements
How to adjust the view of the worksheet
How to use multiple worksheets
VLOOKUP and Power functions
How to protect worksheets and unlock cells
Create PivotTables
Manipulating PivotTable data
Creating and running a simple macro
Anyone who utilizes Excel 2013 and would like to learn more.
None
01. Getting Started with Excel 2013
- Using the menu system
- The Quick Access Toolbar
- The structure of a worksheet or workbook
- Using the Formula bar
- Using the Status bar
- Navigation and mouse pointers
- Shortcut menus and the Mini toolbar
- Using the built-in help
- Creating new files
02. Entering Data
- Exploring data entry and editing techniques
- Entering data with AutoFill
- Working with dates and times
- Using Undo and Redo
- Adding comments
- Using Save or Save As
03. Creating Formulas and Functions
- Creating simple formulas: Totals and averages
- Copying a formula for adjacent cells
- Calculating year-to-date profits
- Creating a percentage-increase formula
- Working with relative, absolute, and mixed references
- Using SUM and AVERAGE
- Using other common functions
04. Formatting
- Exploring font styles and effects
- Adjusting row heights and column widths
- Working with alignment and Wrap Text
- Designing borders
- Exploring numeric and special formatting
- Formatting numbers and dates
- Conditional formatting
- Creating and using tables
- Inserting shapes, arrows, and other visual features
05. Adjusting Worksheet Layout and Data
- Inserting and deleting rows and columns
- Hiding and unhiding rows and columns
- Moving, copying, and inserting data
- Finding and replacing data
06. Printing
- Exploring the Page Layout tab and view
- Previewing page breaks
- Working with Page Setup and printing controls
07. Introduction to Charting
- Creating charts
- Exploring chart types
- Formatting charts
- Working with axes, labels, gridlines, and other chart elements
- Creating in-cell charts and sparklines
08. Adjusting Worksheet Views
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically
- Showing necessary information with the Outlining feature
09. Multiple Worksheets and Workbooks
- Displaying multiple worksheets and workbooks
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets
- Using formulas to link worksheets and workbooks
- Locating and maintaining links
10. IF, VLOOKUP, and Power Functions
- Using IF functions and relational operators
- Getting approximate table data with the V LOOKUP function
- Getting exact table data with the V LOOKUP function
- Using the COUNTIF family of functions
11. Security and Sharing
- Unlocking cells and protecting worksheets
- Protecting workbooks
- Assigning passwords to workbooks
- Sharing workbooks
- Tracking changes
12. Database Features
- Sorting data
- Inserting subtotals in a sorted list
- Using filters
- Splitting data into multiple columns
- Removing duplicate records
13. PivotTables
- Creating PivotTables
- Manipulating PivotTable data
- Grouping by data, time, and other factors
- Using slicers to clarify and manipulate fields
- Using PivotCharts
14. Introduction to Macros
- Definition and examples
- Creating a simple macro
- Running a macro
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
How to enter and work with data
Creating formulas, using SUM and AVERAGE
How to format font and utilize conditional formatting
Adding and subtracting columns and rows
Chart creation, formatting, and elements
How to adjust the view of the worksheet
How to use multiple worksheets
VLOOKUP and Power functions
How to protect worksheets and unlock cells
Create PivotTables
Manipulating PivotTable data
Creating and running a simple macro
WHO SHOULD ATTEND
Anyone who utilizes Excel 2013 and would like to learn more.
PREREQUISITES
None
COURSE OUTLINE
01. Getting Started with Excel 2013
- Using the menu system
- The Quick Access Toolbar
- The structure of a worksheet or workbook
- Using the Formula bar
- Using the Status bar
- Navigation and mouse pointers
- Shortcut menus and the Mini toolbar
- Using the built-in help
- Creating new files
02. Entering Data
- Exploring data entry and editing techniques
- Entering data with AutoFill
- Working with dates and times
- Using Undo and Redo
- Adding comments
- Using Save or Save As
03. Creating Formulas and Functions
- Creating simple formulas: Totals and averages
- Copying a formula for adjacent cells
- Calculating year-to-date profits
- Creating a percentage-increase formula
- Working with relative, absolute, and mixed references
- Using SUM and AVERAGE
- Using other common functions
04. Formatting
- Exploring font styles and effects
- Adjusting row heights and column widths
- Working with alignment and Wrap Text
- Designing borders
- Exploring numeric and special formatting
- Formatting numbers and dates
- Conditional formatting
- Creating and using tables
- Inserting shapes, arrows, and other visual features
05. Adjusting Worksheet Layout and Data
- Inserting and deleting rows and columns
- Hiding and unhiding rows and columns
- Moving, copying, and inserting data
- Finding and replacing data
06. Printing
- Exploring the Page Layout tab and view
- Previewing page breaks
- Working with Page Setup and printing controls
07. Introduction to Charting
- Creating charts
- Exploring chart types
- Formatting charts
- Working with axes, labels, gridlines, and other chart elements
- Creating in-cell charts and sparklines
08. Adjusting Worksheet Views
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically
- Showing necessary information with the Outlining feature
09. Multiple Worksheets and Workbooks
- Displaying multiple worksheets and workbooks
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets
- Using formulas to link worksheets and workbooks
- Locating and maintaining links
10. IF, VLOOKUP, and Power Functions
- Using IF functions and relational operators
- Getting approximate table data with the V LOOKUP function
- Getting exact table data with the V LOOKUP function
- Using the COUNTIF family of functions
11. Security and Sharing
- Unlocking cells and protecting worksheets
- Protecting workbooks
- Assigning passwords to workbooks
- Sharing workbooks
- Tracking changes
12. Database Features
- Sorting data
- Inserting subtotals in a sorted list
- Using filters
- Splitting data into multiple columns
- Removing duplicate records
13. PivotTables
- Creating PivotTables
- Manipulating PivotTable data
- Grouping by data, time, and other factors
- Using slicers to clarify and manipulate fields
- Using PivotCharts
14. Introduction to Macros
- Definition and examples
- Creating a simple macro
- Running a macro
SCHEDULE