Skip to main content

Microsoft Excel Core Productivity Online

ID : 76941   
« back to classes page
Our Microsoft Office Core Productivity online classes teach users the skills to be more productive when using these applications in their daily personal and business lives.  These classes are fully-interactive and self-paced.  Students will learn skills and new tips/tricks by actively engaging in the lessons and "learning by doing" rather than passively just watching videos.

Basic Outline
1.1     Understand the Excel Screen
1.2     Create Workbooks
1.3     Navigate Worksheets
1.4     Open Workbooks
1.5     Save Workbooks
1.6     AutoRecover
1.7     The Quick Access Toolbar
1.8     Print
1.9     Help
1.10   Close and Exit
2.1     Select Cells and Ranges
2.2     Edit Cell Data
2.3     Cut, Copy, and Paste
2.4     Undo, Redo, Repeat
2.5     More Pasting Options
2.6     Insert and Move Cells
2.7     Delete Cells
2.8     Check Spelling
2.9     Find and Replace Text
2.10   Hide Columns and Rows
2.11   Document Properties
3.1     Formula Basics
3.2     AutoFill
3.3     Sums and Averages
3.4     MIN and MAX
3.5     COUNT
4.1     Format Text a Cell
4.2     Align and Merge Cells
4.3     Format Numbers and Dates
4.4     Borders and Background Colors
4.5     Copy Formatting
4.6     Row Heights and Column Widths
5.1     Images
5.2     Shapes
5.3     Hyperlinks
5.4     Object Properties and Alt Text
6.1     View Worksheets
6.2     Multiple Windows
6.3     Move and Copy Worksheets
6.4     Insert, Rename, and Delete Worksheets
6.5     Freeze Rows and Columns
6.6     Hide Worksheets and Gridlines

Intermediate Outline
1.1     Create Charts
1.2     Move and Resize
1.3     Chart Types
1.4     Layout and Style
1.5     Titles and Legends
1.6     Gridlines, Labels, and Data Tables
1.7     Chart Elements
1.8     Modify Chart Data
1.9     Filter Charts
1.10   Trendlines
1.11   Dual-Axis Charts
1.12   Chart Templates
1.13   Sparklines
2.1     Page Size and Scale
2.2     Print Area and Page Breaks
2.3     Print Titles, Gridlines, and Headings
2.4     Headers and Footers
2.5     Margins and Orientation
2.6     Inspect for Issues
3.1     Reference External Worksheets
3.2     Absolute and Relative References
3.3     Order of Operations
3.4     Cell and Range Names
3.5     Insert Functions
3.6     CONCAT Function
3.7     PMT Function
3.8     Display Formulas
3.9     Date Formulas      
4.1     Quick Analysis
4.2     Outline and Subtotal
4.3     Data Validation
4.4     Flash Fill
4.5     Import and Export Data
5.1     Insert a Table
5.2     Sort Data
5.3     Filter Data
5.4     Add Rows and Columns
5.5     Table Styles
5.6     Remove Duplicates
5.7     Slicers
5.8     Structured References
6.1     Apply Conditional Formatting
6.2     Apply and Remove Cell Styles
6.3     Create and Modify Cell Styles
6.4     Find and Replace Formatting
6.5     Apply a Theme
7.1     Cell Comments
7.2     Share Workbooks
7.3     Co-author Workbooks
7.4     Version History
7.5     Protect a Worksheet
7.6     Protect Workbook Structure
7.7     Password Protection
 

Class Details

77 Sessions
Online 24/7

Location
SPC D2L

Instructor
Dan Fumano 

Class Price: 

$99.00


Registration Closes On
Friday, July 26, 2019 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
5/11/2019 - 7/26/2019 Online 24/7 12:00 AM - 12:00 AM N/A - Online Dan Fumano 

Other Class Offerings

Microsoft Excel Core Productivity Online
ID: 76632

12/08/18 - 05/10/19
Online 24/7

Location
SPC D2L

Instructor
Dan Fumano

You may also be interested in these classes