Excel 2013 Intermediate
5.0 (2 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.
7 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Excel 2013 Intermediate

Expand your Excel abilities with charts, PivotTables and PivotCharts, advanced functions, and more.
5.0 (2 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.
7 students enrolled
Last updated 10/2016
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Customize Excel
  • Link Workbooks & Worksheets
  • Work with Range Names
  • Analyze Data with Common Logical Functions
  • Analyze Data with Common Lookup Functions
  • Sort and Filter Range Data
  • Analyze and Organize with Tables
  • Use Conditional Formatting
  • Outline with Subtotals and Grouping
  • Display Data Graphically
  • Understand PivotTables, PivotCharts, and Slicers
  • Work with Flash Fill
  • Work with Date and Time Functions
  • Work with Common Text Functions
View Curriculum
Requirements
  • Excel Introduction course or equivalent experience.
Description

This course is designed to be the intermediate level and increase knowledge of Excel 2013. Students will learn intermediate functions and formulas, including creating and using range names, and logical, lookup, date and time, and common text functions. Students will analyze large amounts of data by creating, manipulating, and modifying PivotTables, PivotCharts, and Excel’s Table features. In addition, students will display data graphically by creating and modifying Charts, and applying Conditional Formatting. Students will learn to master Flash Fill, create automatic subtotals with the Subtotals feature and apply outlining. Finally, students will learn how to customize the Excel environment to suit their needs.

Who is the target audience?
  • Students who want to take their Excel knowledge to the next level.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
78 Lectures
04:05:41
+
Introduction
1 Lecture 01:16
+
Customizing Excel
6 Lectures 21:00

Customizing the Quick Access Toolbar
05:26

Customizing General Formula Options
01:58

Customizing AutoCorrect Options
02:46

Customizing Save Defaults
01:56

Customizing Advanced Excel Options
02:11
+
Linking Workbooks & Worksheets
4 Lectures 13:19

Linking Worksheets with 3D References
03:01

Updating Workbook Links
01:43

Understanding the Consolidate Feature
04:56
+
Working with Range Names
5 Lectures 16:06

Creating Range Names Using the Name Box and Define Name
03:52

Creating Range Names Using Create From Selection
02:23

Using the Name Manager to Manage Range Names
02:11

Using Range Names in Formulas
04:36
+
Analyzing Data with Common Logical Functions
5 Lectures 16:34

Evaluating Data with the AND Function
02:53

Evaluating Data with the OR Function
02:34

Understanding IF Functions
04:08

Nesting AND & OR Inside an IF Function
04:36
+
Analyzing Data with Common Lookup Functions
3 Lectures 12:51

Using VLOOKUP
07:38

Using HLOOKUP
02:38
+
Sorting and Filtering Range Data
3 Lectures 09:12

Sorting Lists
03:50

Filtering Lists
03:40
+
Analyzing and Organizing with Tables
9 Lectures 24:55

Elements of a Table
04:06

Formatting a Table
03:30

Sorting Tables
01:50

Filtering Tables
02:29

Filtering with Slicers
03:02

Calculating with Tables
02:57

Removing Erroneous Table Data
02:26

Exporting, Refreshing, and Converting Tables
02:21
+
Using Conditional Formatting
6 Lectures 17:52

Using Highlight Cells and Top/Bottom Rules
03:55

Using Data Bars, Icon Sets, and Color Scales
04:47

Using Custom Fonts and Colors
02:07

Using Custom Conditional Formatting
02:39

Modifying or Removing Conditional Formatting
02:49
+
Outlining with Subtotals and Grouping
3 Lectures 06:21

Creating Subtotals
03:16

Grouping and Ungrouping Data
01:30
6 More Sections
About the Instructor
Intellezy Trainers
4.4 Average rating
4,573 Reviews
26,704 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.