Excel 2013 Advanced
4.4 (9 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.
31 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Excel 2013 Advanced

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more
4.4 (9 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.
31 students enrolled
Last updated 8/2016
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use SUMIF, AVERAGEIF, and COUNTIF
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Work with What-If Analysis Tools
  • Protect Worksheets and Workbooks
  • Use Advanced PivotTables and PowerPivot Features
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Collaborate in Excel
  • Import and Export Data to a Text File
View Curriculum
Requirements
  • Basic computer skills and Excel 2013 Introduction and Excel 2013 Intermediate courses or equivalent experience.
Description

This course will teach students advanced concepts and formulas in Microsoft Excel 2013. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions including INDEX and MATCH, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Who is the target audience?
  • Students who want to expand their Excel knowledge.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
64 Lectures
02:47:31
+
Introduction
1 Lecture 01:03
+
Using SUMIF, AVERAGEIF, and COUNTIF
3 Lectures 08:40
+
Using Advanced Lookup Functions
7 Lectures 21:18
Using VLOOKUP with TRUE to Find an Approximate Match
04:10

Using HLOOKUP with TRUE to Find an Approximate Match
01:48

Using the INDEX Function
02:58

Using the MATCH Function
02:05


Comparing Two Lists with VLOOKUP
02:36

Comparing Two Lists with a Combined VLOOKUP and ISNA
04:50
+
Using Complex Logical and Text Functions
5 Lectures 14:58
Creating a Nested IF Function
02:53

Using the IFERROR Function
04:00

Using the LEN Function
03:55


Using the SUBSTITUTE Function
02:46
+
Formula Auditing
4 Lectures 09:52
Showing Formulas
02:00

Tracing Precedents and Dependents
02:47


Error Checking
03:20
+
What-If Analysis Tools
3 Lectures 10:44
Using the Scenario Manager
05:53


Analyzing with Data Tables
02:39
+
Worksheet and Workbook Protection
5 Lectures 15:21
Protection Overview
01:42

Excel File Password Encryption
04:36

Allowing Specific Worksheet Changes
02:29

Adding Protection to Only Certain Cells in a Worksheet
03:52

+
Advanced Use of PivotTables and PowerPivot
7 Lectures 16:42
Using the PivotTable and PivotChart Wizard
02:08


Adding a Calculated Item
01:24

Applying Conditional Formatting to a PivotTable
02:35

Filters in the PivotTable Fields Pane
01:56

Creating Filter Pages for a PivotTable
02:23

Enabling the PowerPivot Add-In
03:20
+
Automating with Macros
8 Lectures 26:49
What are Macros?
02:39

Displaying the Developer Tab & Enabling Macros in Excel
02:56

Creating a Basic Formatting Macro
04:55

Running a Macro
01:37

Assigning a Macro to a Button
02:18

Creating a More Complex Macro
04:05

Viewing and Editing the VBA Code for an Existing Macro
06:17

+
Working with Form Controls
3 Lectures 07:04
What are Form Controls?
02:37

Adding Spin Buttons and Check Boxes to a Spreadsheet
02:47

4 More Sections
About the Instructor
Intellezy Trainers
4.4 Average rating
4,602 Reviews
26,904 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.