Microsoft Excel from Beginner to Advanced

24 Reviews

2488 Enrolled

15 Hours

$10.99$44.00

You save 75%

190 Lessons (15h)

Microsoft Excel Course Introduction
Welcome to the Ultimate Microsoft Excel Course7:12
Course Exercise Files1:09
Microsoft Excel Fundamentals
Launching Excel2:34
Introduction to the Excel Interface4:50
Customizing the Excel Quick Access Toolbar3:53
Understanding the Structure of an Excel Workbook5:02
Saving an Excel Document2:44
Opening an Existing Excel Document2:02
Entering and Editing Text and Formulas
Entering Text to reate Spreadsheet Titles5:35
Working With Numeric Data in Excel3:31
Entering Date Values in Excel4:44
Working with Cell References3:55
Creating Basic Formulas in Excel7:02
Relative Versus Absolute Cell References in Formulas10:38
Understanding the Order of Operation3:20
Working with Basic Excel Funtions
The structure of an Excel Function3:40
Working with the SUM() Function4:50
Working with the MIN() and MAX() Functions3:47
Working with the AVERAGE() Function2:38
Working with the COUNT() Function2:15
Using the AutoSum Command4:55
Using the AutoFill Command to Copy Formulas3:09
Modifying an Excel Worksheet
Moving and Copying Data in an Excel Worksheet4:34
Inserting and Deleting Rows and Columns5:27
Changing the Width and Height of Cells5:06
Hiding and Unhiding Excel Rows and Columns2:51
Deleting an Excel Worksheet2:53
Renaming an Excel Worksheet1:58
Moving and Copying and Excel Worksheet4:12
Formatting Data in an Excel Worksheet
Working with Font Formatting Commands3:53
Changing the Background Color of a Cell2:50
Adding Borders to Cells3:33
Formatting Data as Currency Values5:21
Formatting Percentages2:17
Using Excel's Format Painter2:47
Creating Styles to Format Data8:12
Merging and Centering Cells2:50
Using Conditional Formatting4:34
Inserting Images and Shapes into an Excel Worksheet
Inserting Images4:09
Inserting Excel Shapes3:55
Formatting Excel Shapes4:39
Working with Excel SmartArt6:46
Creating Basic Charts in Excel
Creating an Excel Column Chart4:53
Working with the Excel Chart Ribbon5:23
Adding and Modifying Data on an Excel Chart3:08
Formatting an Excel Chart4:40
Moving a Chart to another Worksheet2:31
Working with Excel Pie Charts5:06
Printing an Excel Worksheet
Viewing your Document in Print Preview2:11
Changing the Margins, Scaling and Orientation8:06
Working with Page Layout View3:49
Adding Header and Footer Content4:35
Printing a Specific Range of Cells2:58
Working with Excel Templates
Intro to Excel Templates1:31
Opening an Existing Template5:33
Creating a Custom Template4:36
Congratulations! You've Built a Solid Microsoft Excel Foundation
Congratulations!0:52
Working with an Excel List
Understanding Excel List Structure5:39
Sorting a List Using Single Level Sort3:46
Sorting a List Using Multi-Level Sorts3:46
Using Custom Sorts in an Excel List4:33
Filter an Excel List Using the AutoFilter Tool4:56
Creating Subtotals in a List6:36
Format a List as a Table7:30
Using Conditional Formatting to Find Duplicates3:52
Removing Duplicates4:10
Excel List Functions
Excel Function: DSUM()6:35
Excel Function: DAVERAGE()2:47
Excel Function: DCOUNT()3:02
Excel Function: SUBTOTAL()6:15
Excel Data Validation
Understanding the Need for Data Validation5:13
Creating a Validation List5:37
Adding a Custom Validation Error4:37
Dynamic Formulas by Using Validation Techniques4:24
Importing and Exporting Data
Importing Data from Text Files5:34
Importing Data from Microsoft Access4:14
Exporting Data to a Text File4:13
Excel PivoTables
Understanding Excel PivotTables3:44
Creating an Excel PivotTable6:20
Modifying Excel PivotTable Calculations6:37
Grouping PivotTable Data4:43
Formatting PivotTable Data4:24
Drilling Down into PivotTable Data3:31
Creating PivotCharts4:40
Filtering PivotTable Data3:47
Filtering with the Slicer Tool3:44
Working with Excel's PowerPivot Tools
Why PowerPivot?4:50
Activating the Excel PowerPivot AddIn2:26
Creating Data Models with PowerPivot6:37
Creating PivotTables based on Data Models3:51
PowerPivot Calculated Fields3:51
PowerPivot KPIs7:06
Working with Large Sets of Excel Data
Using the Freeze Panes Tool3:39
Grouping Data (Columns and/or Rows)4:17
Print Options for Large Sets of Data7:32
Linking Worksheets (3D Formulas)4:08
Consolidating Data from Multiple Worksheets5:30
Congratulations! You're an Intermediate Excel User
Congratulations!0:42
Working with Excel's Conditional Functions
Working with Excel Name Ranges5:10
Using Excel's IF() Function6:09
Nesting Functions7:43
Using Excel's COUNTIF() Function3:55
Using Excel's SUMIF() Function5:40
Using Excel's IFERROR() Function6:05
Working with Excel's Lookup Functions
Using Excel's VLOOKUP() Function7:39
Using Excel's HLOOKUP() Function4:22
Using Excel's INDEX() and MATCH() Functions13:20
Working with Excel's Text Based Functions
Using Excel's LEFT(), RIGHT() and MID() Functions6:18
Using Excel's LEN() Function6:15
Using Excel's SEARCH() Function12:19
Using Excel's CONCATENATE() Function3:10
Auditing an Excel Worksheet
Tracing Precendents in Excel Formulas4:01
Tracing Dependents in Excel Formuals2:52
Working with the Watch Window4:19
Showing Formulas2:46
Protecting Excel Worksheets and Workbooks
Protecting Specific Cells in a Worksheet8:05
Protecting the Structure of a Workbook4:12
Adding a Workbook Password3:15
Mastering Excel's "What If?" Tools
Working with Excel's Goal Seek Tool7:41
Working with Excel's Solver Tool9:32
Building Effective Data Tables in Excel6:17
Creating Scenarios in Excel7:51
Automating Repetitive Tasks in Excel with Macros
Understanding Excel Macros3:50
Activating the Developer Tab in Excel1:42
Creating a Macro with the Macro Recorder7:39
Editing a Macro with VBA5:16
Creating Buttons to Run Macros3:11
Congratulations!
Congratulations on Competing the Microsoft Excel 1030:58
Microsoft Excel Macros and VBA Course Introduction
Welcome to the Course5:50
Understanding the Why and How Behind Excel Macros5:15
Course Exercise Files - Download these First!
Project #1: Using Excel's Macro Recorder Tool
Introduction to Project #1: Inserting and Formatting Text2:01
Project #1: Start Recording!7:40
Running A Macro2:43
Project #1: Running a Macro with a Button3:35
Project #1: Opps! I Need to Edit My Macro4:27
Practical Uses of Excel Macros2:16
Excel VBA Concepts
New Lecture
Excel VBA Concepts3:32
The Visual Basic Editor (VBE)3:25
Excel VBA Modules2:01
Creating an Excel VBA Procedure8:17
Adding Code to a VBA Procedure4:04
Understanding Excel VBA Variables7:01
Building Logic with an IF Statement6:18
Working with Excel VBA Loops to Repeat Blocks of Code9:42
Project #2: Moving Beyond the Basics and into VBA
Introduction to Project #2: Interacting with the User2:56
Project #2: Breaking Down the VBA Code3:34
Project #2: Prompting the User for Information6:54
Continue Excel VBA InputBox7:20
Project #2: Building Logic into Your Macros4:31
Project #2: Alerting the User of Errors10:29
Other Practical Uses of Message and Input Boxes3:17
Project #3: Preparing and Cleaning Up Data with a Little VBA
Introduction to Project #3: Cleaning Up and Formatting Data3:06
Project #3: Preparing to the Use the Macro Recorder2:54
Project #3: Inserting the Headers3:26
Project #3: Formatting the Headers2:21
Project #3: Putting it all Together with a Little VBA10:47
Running the Loop2:54
Project #4: Using VBA to Automate Excel Formulas
Introduction to Project #4: Automate Excel Formulas2:10
Project #4: Automate the SUM() Function through Code8:01
Continue Automate SUM Function6:28
Test the SUM Function3:45
Project #4: Loop the SUM() Function Over Multiple Worksheets6:17
Project #5: Bringing it All Together and a Weekly Report
Introduction to Project #5: Creating the Final Report2:59
Project #5: Creating the Final Report Loop7:45
Project #5 - Copying and Pasting Data with VBA9:26
Project #5 - Running the Final Report Procedure3:14
Project #6: Working with Excel VBA User Forms
Introduction to Project #6: Working with Excel VBA User Forms3:01
Project #6: Creating an Excel User Form5:05
Project #6: Adding Controls to the Form4:01
Project #6: Adding VBA Code to the Initialize Event8:49
Project #6: Adding VBA Code to the ComboBox Change Event4:32
Project #6: Adding VBA Code to the Add Worksheet Button3:28
Change Worksheet Name3:58
Project #6: Adding VBA Code to the Create Report Button8:52
Project #6: Showing the Form4:02
Project #7: Importing Data from Text Files
Project #7: Opening a Text File for Import2:42
Project #7: Opening a Text File for Import6:45
Project #7: Get Data from Text File5:30
Project #7: Importing Multiple Text Files with the GetOpenFilename Method9:32
Project #7: Creating a Loop to Read Each File7:26
Project #7: Adding a New Sheet for Imported Data2:36
Project #7: Clear the Clipboard3:38
Project #7: Working with the ScreenUpdating Property3:16
Project #7: Creating Reusable Code with a VBA Function7:44

Accelerate Your Career with This 4-Part, A-Z Excel Course

Kyle Pew

Instructor

Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
Excel, Word, PowerPoint, Outlook, Access and Visio
SharePoint End-User 2007, 2010, 2013
VBA (Excel and Access)
Adobe Suite
Photoshop, Illustrator, InDesign
Maya (Modeling and Animation)
Unity3d (Game Design)
HTML, CSS and JavaScript
Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Description

Microsoft Excel is the most widely used office software in the United States and, as such, is a basic requirement for many jobs. If you're great at it, it may even make the difference in earning a promotion. This single course comprises four courses covering the absolute basics through to advanced Excel techniques. By the completion of the course, you'll have mastered the most popular Excel tools and have the confidence to complete any Excel task with efficiency and grace.

Access 190 lectures & 15 hours of content 24/7
Create effective spreadsheets
Manage large sets of data
Master the use of some of Excel's most popular & highly sought-after functions
Create dynamic reports w/ Excel PivotTables
Unlock the power & versatility of Microsoft Excel's AddIn and PowerPivot
Automate your day to day Excel tasks by mastering the power of Macros & VBA

Specs

Important Details

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner

Requirements

Microsoft Excel 2010, 2013, or 2016

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your cart is empty. Continue Shopping!

Processing order...