Microsoft Excel 2013

Get the most out of Excel by focusing on tools that maximize productivity and accuracy from a business perspective.
0.0 (0 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1 student enrolled
$40
Take This Course
  • Lectures 116
  • Contents Video: 7 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course Description

This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp. This title is a self-paced software training course delivered via pre-recorded video. We do not provide additional information outside of the posted content. Work files for this course can be downloaded from the first lecture.

What are the requirements?

  • Microsoft Excel 2013 (recommended)

What am I going to get from this course?

  • Maximize productivity and accuracy using Excel

What is the target audience?

  • Microsoft Excel 2013 users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Excel Basics
About Excel
Preview
03:50
Start Screen
Preview
02:41
Ribbon QAT and Status Ba
Preview
04:14
Backstage View
Preview
03:09
Menus / Mini Toolbar / Task Panes
Preview
03:38
Get Help
Preview
03:37
Section 2: Getting Started
Open and Close a Workbook
Preview
02:54
Move Around in a Workbook
Preview
03:23
Save a Workbook
Preview
04:33
Work with Accounts in Excel
Preview
04:19
Create a New Workbook
Preview
01:43
Use an Excel Template
Preview
03:19
Section 3: Entering Data
Enter Text and Headings
Preview
04:15
Enter Numbers
Preview
04:10
Enter Dates
Preview
03:36
AutoFill Dates
Preview
03:48
AutoFill Numbers
Preview
03:32
AutoFill Text
Preview
03:55
Create an AutoFill Series
Preview
04:02
Enter Hyperlinks
Preview
03:57
Section 4: Rearranging a Worksheet
Size Columns and Rows
04:39
Insert & Delete Rows & Columns
03:45
Copy or Move Data
04:17
Copy or Move a Worksheet
03:31
Transpose Data
02:23
Section 5: Basic Formulas & Functions
Using SUM and AutoSum
04:24
Doing Simple Math
04:24
Order of Operations
03:20
Calculating Averages
03:53
Quick Analysis - Totals
02:26
Adding & Subtracting Dates
03:08
Copy Formulas
04:19
Absolute & Relative Addressing
04:00
Naming Ranges
04:14
Calculating Using Names
04:11
Understanding Errors
04:17
Evaluating a Formula
04:12
Section 6: Formatting a Worksheet
Format Numbers
04:48
Format Dates
02:25
Format with Color
03:15
Use Worksheet Themes
03:38
Add Borders
04:27
Conditional Formatting pt. 1
04:18
Conditional Formatting pt. 2
04:22
Borrow Table Formats
03:01
Create and Use Styles
04:20
Paint and Clear Formats
02:23
Section 7: Creating Charts
Create a Chart
04:42
Add Chart Titles and Legends
03:21
Format a Chart pt. 1
03:37
Format a Chart pt. 2
04:18
Create a Pie Chart
04:28
Understanding Chart Types
03:23
Plot Data on Multiple Axes
03:10
Create Sparklines
04:04
Section 8: Adding Art
ClipArt and Photos
03:53
Worksheet Backgrounds & Watermarks
04:04
SmartArt
03:09
Shapes
04:16
Section 9: More Complex Functions
Using IF to Make Calculations
04:03
Using SUMIF & COUNTIF
04:14
Calculating with SUMPRODUCT
02:20
Random Numbers with RANDBETWEEN
03:44
Find and Use Functions
04:16
Building a Mortgage Calculator
04:22
Section 10: Working with Tables
Create and Format a Table
03:37
Create a Chart of Table Data
01:58
Calculations in a Table
03:26
Use the Subtotal Function
03:59
Filter Table Data
04:22
Sort Data in a Table
03:23
Section 11: Working with PivotTables
PivotTables Introduction
02:50
Create a PivotTable
03:02
Query a PivotTable
04:04
Use Slicers
03:36
Create a PivotChart
02:04
Section 12: Working with Large Worksheets
Freeze Panes
03:59
Headers & Footers
04:05
Views
04:07
Find & Replace
04:00
Manipulate Data with Flash Fill
03:44
Remove Duplicate Data
04:21
Section 13: Advanced Tools & Techniques
Goal Seek
03:38
Create and Use a Watch Window
02:59
Create and Save a Template
04:00
Calculate Across Multiple Worksheets
03:19
Working with Comments
03:49

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

VTC Software Training, Affordable, Comprehensive Software Training

VTC is one of the world's leading producers of online computer and software training, supplying richly diverse courses of informative and inspiring tutorials. Created on the idea that anyone should have the ability to learn to use computer software on their own time, VTC has produced tens of thousands of hours of extraordinarily valuable, insightful, and easy to follow tutorials and delivers them for a fraction of the cost of other training methods. Our training authors are some of the most accomplished in their respective fields. The tutorials that could make the difference in your new job, promotion, or school advancement are always available and only a click away.

Ready to start learning?
Take This Course