MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Microsoft Excel 2013

### Course Summary

Get the most out of Excel by focusing on tools that maximize productivity and accuracy from a business perspective.

• +

### Course Syllabus

• Excel Basics
• Start Screen
• Ribbon QAT and Status Ba
• Backstage View
• Get Help
• Getting Started
• Open and Close a Workbook
• Move Around in a Workbook
• Save a Workbook
• Work with Accounts in Excel
• Create a New Workbook
• Use an Excel Template
• Entering Data
• Enter Numbers
• Enter Dates
• AutoFill Dates
• AutoFill Numbers
• AutoFill Text
• Create an AutoFill Series
• Rearranging a Worksheet
• Size Columns and Rows
• Insert & Delete Rows & Columns
• Copy or Move Data
• Copy or Move a Worksheet
• Transpose Data
• Basic Formulas & Functions
• Using SUM and AutoSum
• Doing Simple Math
• Order of Operations
• Calculating Averages
• Quick Analysis - Totals
• Copy Formulas
• Naming Ranges
• Calculating Using Names
• Understanding Errors
• Evaluating a Formula
• Formatting a Worksheet
• Format Numbers
• Format Dates
• Format with Color
• Use Worksheet Themes
• Conditional Formatting pt. 1
• Conditional Formatting pt. 2
• Borrow Table Formats
• Create and Use Styles
• Paint and Clear Formats
• Creating Charts
• Create a Chart
• Add Chart Titles and Legends
• Format a Chart pt. 1
• Format a Chart pt. 2
• Create a Pie Chart
• Understanding Chart Types
• Plot Data on Multiple Axes
• Create Sparklines
• ClipArt and Photos
• Worksheet Backgrounds & Watermarks
• SmartArt
• Shapes
• More Complex Functions
• Using IF to Make Calculations
• Using SUMIF & COUNTIF
• Calculating with SUMPRODUCT
• Random Numbers with RANDBETWEEN
• Find and Use Functions
• Building a Mortgage Calculator
• Working with Tables
• Create and Format a Table
• Create a Chart of Table Data
• Calculations in a Table
• Use the Subtotal Function
• Filter Table Data
• Sort Data in a Table
• Working with PivotTables
• PivotTables Introduction
• Create a PivotTable
• Query a PivotTable
• Use Slicers
• Create a PivotChart
• Working with Large Worksheets
• Freeze Panes
• Views
• Find & Replace
• Manipulate Data with Flash Fill
• Remove Duplicate Data
• Goal Seek
• Create and Use a Watch Window
• Create and Save a Template
• Calculate Across Multiple Worksheets
• Use a Lookup Table pt. 1
• Use a Lookup Table pt. 2
• Import Data into Excel
• Find Precedents and Dependents
• Use Data Validation
• Enter Data Using Data Validation
• Work with Other Office Programs
• Printing a Worksheet
• Set Up a Worksheet for Printing
• Shrink to Fit
• Configure Printing Options
• Print a Chart
• Print a Selection
• Print to PDF
• Design Basics
• Create a Data Area
• Work with Multi-Sheet Workbooks
• Protect a Worksheet
• Error Checking and Testing
• Spell Check and AutoCorrect
• Automating with Macros
• Understanding Macros
• Record a Macro
• Run a Macro
• Explore the Visual Basic Editor
• Working with SkyDrive
• SkyDrive Introduction
• Save and Open SkyDrive Files
• Work in the Excel Web App
• How to Use SkyDrive
• Conclusion
• Course Wrap Up
• Credits

Course Fee:
USD 89

Self-Study

### Course Status:

Active

1 - 4 hours / week

Related Posts: