Overview
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.
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
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