Microsoft Excel 2013: Beginner to Advanced

Learn useful features and helpful functions with this online Microsoft Excel 2013 course.

4.40 (13 reviews)
Udemy
platform
English
language
Microsoft
category
65
students
10.5 hours
content
May 2015
last update
$44.99
regular price

What you will learn

Organize worksheet and table data using various the Options.

Create and modify charts.

Customize workbooks and enhance the Microsoft Office Excel 2013 Environment.

Modify graphic objects in a worksheet.

Analyze data using Pivot Tables, slicers and Pivot Charts and more!

Description

Whether you have never used Excel, or want to master the more advanced features and functions of Excel 2013, this course will make you proficient in no time at all!

In this Microsoft Excel 2013 Training course, you will learn by watching the instructor actually conduct the exercises as she explains step-by-step how to perform these functions. The training starts with the absolute basics of creating your very first worksheet and slowly progresses through learning numerous capabilities of this very powerful program. The topics range from creating very basic formulas to more advanced functions like table editing, the help function and more.

The Microsoft Excel 2013 course will also strengthen the skills that you have already, while also giving you some new techniques for Excel:

  • To organize your worksheet and table data using various Options.
  • Create and modify charts.
  • Customize workbooks and enhance your Microsoft Office Excel Environment.
  • Modify graphic objects in a worksheet, analyze data using Pivot Tables, slicers and Pivot Charts.

Taking this course will explain the processes of how to accomplish some common tasks you need in Excel. You will learn to automate common tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Check what you've learned at the end of each lesson with our quizzes.

Our Microsoft courses help you to prepare for the official Microsoft Office Specialist exam.

Content

Excel 2013, Beginner - Course Overview

Course Overview

Lesson One - Getting Started with Excel 2013

Getting Started with Excel 2013 - Lesson Introduction
Identify the Elements of the Application Window
Identify the Elements of the Workbook Window
Create a Basic Worksheet
Use the Help System
Getting Started with Excel 2013 - Summary
Getting Started with Excel 2013 - Quiz

Lesson Two - Performing Calculations

Performing Calculations - Lesson Introduction
Create Formulas in a Worksheet
Insert SUM and AVERAGE Functions in a Worksheet
Insert MIN and MAX Functions in a Worksheet
Cut and Paste Commands
Absolute Cell References
Performing Calculations - Summary
Performing Calculations - Quiz

Lesson Three - Modifying a Worksheet

Modifying a Worksheet - Lesson Introduction
The Auto Fill Feature
The Undo and Redo Commands
Column Width and Row Height Alteration Methods
The Hide and Unhide Options
The Insert and Delete Options
Cell Names and Range Names
The Find and Replace Commands
Spell Check a Worksheet
Modifying a Worksheet - Summary
Modifying a Worksheet - Quiz

Lesson Four - Formatting a Worksheet

Formatting a Worksheet - Lesson Introduction
Modify Fonts
Add Borders and Color to Cells
Apply Number Formats
Align Cell Contents
Apply Cell Styles
Formatting a Worksheet - Summary
Formatting a Worksheet - Quiz

Lesson Five - Printing Workbook Contents

Printing Workbook Contents - Lesson Introduction
Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Printing Workbook Contents - Summary
Printing Workbook Contents - Quiz

Lesson Six - Managing Large Workbooks

Managing Large Workbooks - Lesson Introduction
Format Worksheet Tabs
Manage Worksheets
Manage the View of Worksheets and Workbooks
Managing Large Workbooks - Summary
Managing Large Workbooks - Quiz

Lesson Seven - Customizing the Excel Environment

Customizing the Excel Environment - Lesson Introduction
Customize General and Language Options
Customize Formula Options
Customize Proofing and Save Options
Customize the Quick Access Toolbar
Customize the Ribbon
Customize the Functionality of Excel by Enabling Add-Ins
Customize Advanced Options
Customize Trust Center Options
Customizing the Excel Environment - Summary
Customizing the Excel Environment - Quiz

Excel 2013, Beginner - Course Follow-Up

Course Follow-Up

Excel 2013, Intermediate - Course Overview

Course Overview

Lesson One - Creating Advanced Formulas

Creating Advanced Formulas - Lesson Introduction
Add Range Names
Edit and Delete Range Names
Use Range Names in a Formula
Use Specialized Functions
Use the SUM Function
Use the AVERAGE Function
Use the MIN Function
Use the MAX Function
Use COUNT, COUNTA and COUNTIF Functions
Use the ROUND Function
Use the AND Function
Use the CONCATENATE Function
Use HLOOKUP and VLOOKUP Functions
Creating Advanced Formulas - Summary
Creating Advanced Formulas - Quiz

Lesson Two - Analyzing Data with Logical Functions

Analyzing Data with Logical Functions - Lesson Introduction
Work with Logical Functions
Use the Nested IF Function
Analyzing Data with Logical Functions - Summary
Analyzing Data with Logical Functions - Quiz

Lesson Three - Organizing Worksheet Data with Tables

Organizing Worksheet Data with Tables - Lesson Introduction
Create and Modify Tables
Sort Data
Filter Data with the Auto Filter
Filter Data with the Advanced Filter
Remove Duplicates
Total Row
Organizing Worksheet Data with Tables - Summary
Organizing Worksheet Data with Tables - Quiz

Lesson Four - Visualizing Data with Charts

Visualizing Data with Charts - Lesson Introduction
Create Charts
Change the Default Chart Type
Modify Charts
Edit Axes
Format Charts
Create a Trendline
Create Advanced Charts
Visualizing Data with Charts - Summary
Visualizing Data with Charts - Quiz

Lesson Five - Analyzing Data with PivotTables, Slicers, and PivotCharts

Analyzing Data with PivotTables, Slicers, and PivotCharts - Lesson Introduction
Create a PivotTable
Advanced Field Settings
Filter Data by Using Slicers
Analyze Data by Using PivotCharts
Analyzing Data with PivotTables, Slicers, and PivotCharts - Summary
Analyzing Data with PivotTables, Slicers, and PivotCharts - Quiz

Lesson Six - Inserting Graphics

Inserting Graphics - Lesson Introduction
Insert and Modify Graphic Objects
Insert and Group Shapes
Incorporate SmartArt
Inserting Graphics - Summary
Inserting Graphics - Quiz

Lesson Seven - Enhancing Workbooks

Enhancing Workbooks - Lesson Introduction
Comments
Hyperlinks
Watermarks
Manage Themes
Create and Use Templates
Protect Files
Enhancing Workbooks - Summary
Enhancing Workbooks - Quiz

Excel 2013, Intermediate - Course Follow-Up

Course Follow-Up

Excel 2013, Advanced - Course Overview

Course Overview

Lesson One - Automating Worksheet Functionality

Automating Worksheet Functionality - Lesson Introduction
Update Workbook Properties
Apply Conditional Formatting
Edit a Conditional Formatting Rule
Add Data Validation Criteria
Automating Worksheet Functionality - Summary
Automating Worksheet Functionality - Quiz

Lesson Two - Auditing Worksheets

Auditing Worksheets - Lesson Introduction
Trace Cells
Troubleshoot Invalid Data
Troubleshoot Invalid Formulas
Evaluate Formulas
Watch Formulas
Create a Data List Outline
Add Subtotals to Grouped Data
Auditing Worksheets - Summary
Auditing Worksheets - Quiz

Lesson Three - Analyzing and Presenting Data

Analyzing and Presenting Data - Lesson Introduction
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Analyzing and Presenting Data - Summary
Analyzing and Presenting Data - Quiz

Lesson Four - Working with Multiple Workbooks

Working with Multiple Workbooks - Lesson Introduction
Consolidate Data
Link Cells in Different Workbooks
Merge Workbooks
Working with Multiple Workbooks - Summary
Working with Multiple Workbooks - Quiz

Lesson Five - Exporting Excel Data

Exporting Excel Data - Lesson Introduction
Export Excel Data
Import a Delimited Text File
Integrate Excel Data with the Web
Create a Web Query
Exporting Excel Data - Summary
Exporting Excel Data - Quiz

Excel 2013, Advanced - Course Closing

Course Closing

Screenshots

Microsoft Excel 2013: Beginner to Advanced - Screenshot_01Microsoft Excel 2013: Beginner to Advanced - Screenshot_02Microsoft Excel 2013: Beginner to Advanced - Screenshot_03Microsoft Excel 2013: Beginner to Advanced - Screenshot_04

Charts

Price

Microsoft Excel 2013: Beginner to Advanced - Price chart

Rating

Microsoft Excel 2013: Beginner to Advanced - Ratings chart

Enrollment distribution

Microsoft Excel 2013: Beginner to Advanced - Distribution chart

Related Topics

464114
udemy ID
3/31/2015
course created date
11/22/2019
course indexed date
Bot
course submited by