Microsoft Excel 2013
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1 student enrolled

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)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1 student enrolled
Last updated 9/2013
English
English [Auto-generated]
Price: $39.99
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Maximize productivity and accuracy using Excel
Requirements
  • Microsoft Excel 2013 (recommended)
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.

Who this course is for:
  • Microsoft Excel 2013 users
Course content
Expand all 116 lectures 07:05:33
+ Rearranging a Worksheet
5 lectures 18:35
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
+ Basic Formulas & Functions
12 lectures 46:48
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
+ Formatting a Worksheet
10 lectures 36:57
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
+ Creating Charts
8 lectures 31:03
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
+ Adding Art
4 lectures 15:22
ClipArt and Photos
03:53
Worksheet Backgrounds & Watermarks
04:04
SmartArt
03:09
Shapes
04:16
+ More Complex Functions
6 lectures 22:59
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
+ Working with Tables
6 lectures 20:45
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