Microsoft Excel 2013
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
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 to your Wishlist.

Add to Wishlist

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
Last updated 9/2013
English
Price: $40
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Maximize productivity and accuracy using Excel
View Curriculum
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 is the target audience?
  • Microsoft Excel 2013 users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
9 More Sections
About the Instructor
VTC Software Training
3.9 Average rating
164 Reviews
2,381 Students
48 Courses
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.