Excel Online

Cost: $250

Register now!

Course Objectives:

1. Introduction
Excel 2013 Interface
Templates, Workspace, Quick Access
More Commands, Popular Commands
Camera Button
Customize Ribbon

2.Navigating Excel
Touch Screen
Basic Navigation

3. Shortcuts
Esc Key, Undo, Right Click
Three Windows Shortcuts
Function Key Shortcuts
Ctrl Key Shortcuts
Copy, Past, Print, Select All
Select Data Range, Save
New Document
Alt Key Shortcuts
Insert Column, Row, Worksheet
Visible Keys
Drop-Down, Ribbon

4. Creating and Manipulating Data
Entering Data
Auto Fill
Expand Data
Working with Auto Fill
Custom Lists
Creating Custom Lists
Text Strings
Active Cells
Grouping Worksheets
Ungrouping Worksheets
Flash Fill
Colum Headings

5. Managing Worksheets
Managing Worksheet, Copy and Move
Copy and Move Workbook
Rename, Inserting, Deleting Worksheets

6. Paste Special
Windows Copy and Paste Rule
Four Steps of Paste
Quick Multiplication
Benefits of Paste Special
Format Painter
Removing Duplicates

7. Changing Views
Changing Views
Changing Workbook View
Mirror Images
Freeze Panes
Split the Window
Page Layout
Custom View
View Show

8. Formatting Data
Formatting Data, Color, Size
Change Sheet, Tab Color, Office Workbook
Change Office Themes
Backgrounds/ Watermarks

9. Modify Cells
Modify Cell Alignment, Wrap Text
Indentation
Merge Cells
Apply Number Formats, Special Formats
Custom Format
Text to WordArt
Existing Text to WordArt

10. Tables
Find and Replace
Asterisk, Question Mark
Sorting
Filtering
Create Tables
Modify Tables
Total Rows
Define Titles, Go To
Remove Duplicates

11. Text Formulas
Concatenate
Edit Formula
Correct Columns
Split Cell Contents Apart
Convert Formulas to Text
Delimiters
Upper, Lower, Proper
Left
Right, Mid
Trim

12. Operations
Define Order of Operations
Four Most Popular Operators
More Operators
Sum
Average, Min, Max
Count, Counta
AutoCalculate
Formula Auditing
Relative, Absolute Cell References
Mixed Cell References

13. Totals and Sparklines
Totaling Multiple Sheets
Working with Totaling Sheets
Quick Analysis, Grand Totals
Sparkline Graphics
Sparkline Tools
Incorrect Data
Consolidation
Subtotals

14. VLOOKUP
What is VLOOKUP?
VLOOKUP Specifications
Name the Range
Column Index Number
VLOOKUP with Optional Argument

15. Nested Formulas
Using Nested Formulas
Absolute Value Formula
Nesting a Formula
Nested Formula Logic
FIND Formula
LEFT Formula
ROW, COLUMN Formula

16. Conditional Logic
Using Conditional Logic
IF Formula
Nested IF
Maintain Backward Compatibility
Text Wrap Within Cells
Formula Wizard, AND
OR
NOT
IFERROR
SUMIF
COUNTIF
AVERAGEIF
SUMIFS
AVERAGEIFS
COUNTIFS