Microsoft Excel Essentials: Level Two

No Rating(0)
See all reviews

This course is designed to supercharge your Excel skills by learning powerful and little-known techniques to enable you to build your own powerful solutions with Excel, create multiple projects together, step-by-step, and in depth to guarantee your understanding, combine multiple functions in a simple way to create powerful solutions.

Watch Free For 30 Days

start free access

-or-

buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This CourseBeginner

Excel is the most commonly used and in demand tool for making sense of data. When you can harness that power, you will become a more valuable employee. If you run a business, being proficient in Excel can help you see your business in a completely different light. 

You will learn powerful and little-known techniques to enable you to build your own powerful solutions with Excel. We will do this by creating multiple projects together, step-by-step, and in depth to guarantee your understanding. Each project builds on the last, so your skills develop as you progress though the course.

You will learn how to combine multiple functions in a simple way to create powerful solutions that most users believe can’t even be done in Excel! Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and to show you what is really possible.   

This isn’t just a course with a bunch of formulas, it’s hands on guide through real life projects. You will learn how to build complex solutions using the very same methods used. Become the Excel super-user I know you can be, with the help of this course.

Our Promise to You

By the end of this course, you will have learned the next step to supercharging your skills in Excel.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked. 

Get started today and learn more about Microsoft Excel essentials’ second installment.

Course Curriculum

Course Sections

Welcome, And Thank You For Choosing This Course

Downloadable Materials – Microsoft Excel Essentials: Level Two

Proof Of Concept

Planning Ahead

Creating Our Data Entry Screen

Custom – Formatting Dates And Times

Simple Calculations With Time

More Useful Calculations With Time

It’s About Time, And Dates

Adding With Time

Creating A Template From An Image

Importing A Template From An Existing Excel File

Converting Time To A Decimal

A Little Bit Of Simple Data Entry

Simple Conditional Formatting For A Cleaner View

Calculating Time Out Of House Using Travel Time

Simple Logical Testing And Nested Logical Testing

Building Complex Text Strings With A Formula

Before We Move On, Accessing The Developer Ribbon

A Tick Box Exercise Of Sorts

Auto-Populating Check Boxes

Practice Exercise One – Time To Add A New Entry

Defining A Working Area And Protecting Your Work

Practice Exercise Two – Set Up A Working Area And Limit User Entry

Simple VLookUps

Get Some Data In And Split It

Using Data Validation To Get The Right Input

Let’s Build Our Database

Importing Data From A Text File

Importing Data From A Word File

Pulling Data From Multiple Sources

Using Other LookUps To LookUp

LookUp From A LookUp With No Intermediary Step

Data Arrays Don’t Have To Start At A1

Some Common Reasons VLook-Ups Fail

One Inherent Flaw In VLook-Up

Power User – A Breakdown Of Looking Up Backwards

Power User – The Other Way Of Looking Up Backwards

Backwards Look-Ups In Action

Power User – Dealing With Inconsistencies In User Entry

Power User – Fuzzy VLookUps

Power User – VLookUps With Multiple Inputs

Power User – Looking Up From Multiple Inputs Using An Array Formula

VLookups Brother, HLookup

Power User – The Holy Grail – How To Return Multiple Values From A Single LookUp

What To Look For When That Formula Didn’t Work

The Fastest Way To Modify Your Column Numbers

Power User – VLookUps With Moving Columns

Putting It All Together

The Finishing Touch: How Many Records Did I Find

A Simple Static Named Range Using A Single Cell

Creating A Named Range Using A Range Of Cells

Using Row Labels To Name Multiple Ranges

Power User – A Magic Trick Using Row And Column Labels

Power User – Dynamic Named Ranges

Power User – What To Do With Dynamic Names Ranges With Titles

Power User – Dynamic Charts

Horizontal Dynamic Named Ranges For Charts

Welcome To What Can I Have For Dinner, Or What Would I Use That For

Hyperlinking To A Different Sheet In The Same Workbook

Creating Our First Macro

Assigning A Macro To A Button

Creating A List For Our Drop Down Using A Dynamic Named Range

Using A Conditional Format To Know When A Value Is Missing

Copying Conditional Formats And Creating Our Drop Downs

Building Our Formula – Indirect Function

Building Strings For Indirect Sheet And Cell References

It’s A One Or A Zero

Working The Percentages And Adding Traffic Lights

Power User – The Hyperlink Function, And Problem

Exercise One – Fill In The Blanks

Exercise Two – Pretty It Up With A Macro

Exercise Three – Create A VLookUp Using A Built String With Indirect

Creating A Gantt Chart Using A Worksheet

Building The First Part Of Our Logical Test

Multiple Logical Tests At Once Using AND

Conditional Formatting – Where The Magic Happens

Gantt Charts Using The Built In Charting Tools

SQA – Gantt Charts With Different Colours For Different Categories

How I Created Randomly Generated License Plate Numbers

Calls Text Data – Or How To Return A Column Title If Value is >1

Calls Text Data Two – This Time Using Text

Extracting Phone Numbers From A Cell

What Is The Choose Function Really Used For

Casing And Text Functions

Dynamic Charting From A Drop Down

Extracting A Unique List, And Summing The Money

SumIf With Dynamic Sum Range

VLookUps With Pictures

Data Validation With Dependent Drop Downs

Data Validation With Dependent Drop Downs – Dynamic Named Range Workaround

Using Two Labels As A Lookup From Drop Downs

Tiered Pricing – SUMming So Many At One Price, So Many At Another, And So On

The Middle Name Problem, And Solution

Finding Matches, And Counting Entries

Fee Calculator, Or LookUps That Are True, Not False

Reviews

No Reviews found for this course.