4.4 (9 ratings)
31 students enrolled
Wishlisted 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)
31 students enrolled
Last updated 8/2016
English
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
Preview 01:03
+
Using SUMIF, AVERAGEIF, and COUNTIF
3 Lectures 08:40
Preview 04:27

Summarizing Data with AVERAGEIF
02:10

Preview 02:03
+
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

Preview 02:51

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

Preview 01:24

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

Tracing Precedents and Dependents
02:47

Preview 01:45

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

Preview 02:12

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

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

Preview 02:56

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

Preview 02:02
+
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

Preview 01:40
4 More Sections