Excel Essentials and Hacks

This course includes lifetime access so you can complete the course at your own speed.

By taking this course today, you can improve your Excel skills and learn the most important aspects of Excel and master them! This course will teach you about the Excel Essentials, 20+ quick and killer excel hacks and the bulls-eye formula blueprint!

Benefits of taking this course include:

• Unlimited and lifetime access to the course
• Learn the course at your own pace
• Course can be accessed on any platform
• 24/7 Customer support

Certificate of completion

Digital certificate - Included

Here’s the truth – Excel is extremely complex and is not an easy thing to master. However, I truly believe that you can hack your way through learning it – that is, know exactly what the most important aspects in Excel are and master them one by one. That’s why I organized this course into so-called “Hacks”, so that you can focus on the most important information first and foremost.

Have you ever been confused by the sheer complexity of Excel? Ever struggled with an annoying problem that you couldn’t solve fast enough? Or maybe you’re just looking to start learning to use Excel and master it quickly…

A lot of the Excel Trainings out there throw a bunch of formulas at you and teach you how to use them. However, they neglect to tell you their practical applications and what the most important shortcuts are.

After taking this course, you will have learned the following:

• The Excel Essentials – discover the quickest ways to navigate and manipulate data in Excel so that you can master the basics straight away
• 20+ Quick & Killer Hacks – These are individual lectures focused on particular Excel hacks which boost your productivity & use of Excel
• Bulls-Eye Formula Blueprint – master Excel Formulas by shifting the focus away from HOW they work to WHAT their usability is in practical scenarios

The Excel Essentials and Hacks will cover the following topics:

Topic 1: Introduction To This Course

• Welcome To This Course!
• The Truth About Learning Excel
• What I Recommend When Watching This Course
• Excel Hacking – Course Material Download

Topic 2: Functionality & Formatting Basics

• Introduction To The Basics
• Download This First: Spreadsheet For This Section
• Getting Started & Auto-Fill
• Getting Smart With Alignment-Based Formatting
• Customising The Format With Borders
• How To Effectively Manipulate Rows And Columns
• Quick Hack #1: Insert Several Rows More Effectively
• Beginners’ Guide: Cell-Level Formatting
• The Fundamental Excel Tool You Must Be Aware Of
• Quick Hack #2: The Double Click Trick
• Use Hide & Group To Your Advantage
• Quick Hack #3: Effortlessly Select The Whole Sheet

Topic 3: Manipulating Data In Excel: The Hacks You Need To Know

• Introduction
• Download This First: Spreadsheets For This Section
• The Tool To Effortlessly Replicate Formulas & Values
• Quick Hack #4: Auto-Fill… With A Twist!
• The Easy Solution To Transposing Your Tables
• Excel Hack #1: The Essential Functionality I Heavily Used To Build Spreadsheets
• Quick Hack #5: Searching With Wildcard
• How To Make Sense Of Data-Packed Tables
• Sorting Efficiently In Excel
• Quick Hack #6: Fast Navigation With A Few Keys Preview
• Ultimate Guide: Filtering
• How To Get Rid Of Duplicates In Your Data
• Using Subtotals To Your Advantage
• Quick Hack #7: How To Copy Visible Cells Only
• Excel Hack #2: Introducing Flash-Fill

Topic 4: Introduction To Formulas In Excel

• Introduction To This Chapter
• Download This First: Spreadsheet For This Section
• Formula Syntax Explained
• A Complete Guide To Absolute & Relative Referencing
• 3 Essential Formulas To Master
• Quick Hack #8: Verify Formulas Fast
• 2 Ways To Identify Maximum & Minimum Values
• How To Use The IF Function The Right Way
• 3 Operators To Expand Your Condition-Based Formulas
• No-Nonsense Guide To Solving Nested IFs
• Excel Hack #3: Organised Formula Writing For Enhanced Visibility & Productivity

Topic 5: Manipulate Text Using Formulas

• Introduction
• Download This First: Spreadsheet For This Section
• Formulas To Ensure Proper Formatting
• How To Stick Text Strings Together
• Quick Hack #9: Combine Strings Without A Formula
• 3 Ways To Extract Bits Of Text
• Ultimate Guide: Extracting Text By Identifying Specific Strings
• Quick Hack #10: Ensure Text Accuracy
• The Built-In Functionality To Customise Text Strings

Topic 6: Advanced Excel Formulas For Heavy Users

• Introduction
• Download This First: Spreadsheet For This Section
• Time Saver: How To Define Names In Excel
• Beginners Guide: Using VLookup
• Quick Hack #11: Vlookups For 100% Accuracy
• How To Identify Row & Column Indicators With Unique Values
• Quick Hack #12: The VLookup & Match Combo
• When To Use Nested VLookups
• Excel Hack #4: Extract Values From A Database With Row & Column Indicators
• The Tidiest Way To Deal With Errors
• Excel Hack #5: Looking Up Values With 2+ Unique Criteria
• The Fastest Way To Sum Up Different Sheets
• The Easy Way To Transpose Tables With Formulas
• Quick Hack #13: Excel Goal-Seeker

Topic 7: Excel Tables & Conditional Formatting

• Introduction
• Download This First: Spreadsheet For This Section
• Beginners’ Guide: Excel Table Creation
• Table Design Basics
• Quick Hack #14: Adding Total Rows To Tables
• Quick Hack #15: 3 Awesome Table Functionalities
• Conditional Formatting Essentials
• How To Manage Conditional Formatting
• Conditional Formatting With Formulas
• Excel Hack #6: 3 Features To Take Conditional Formatting To The Next LEvel
• Excel Chart Creation Tutorial
• Quick Hack #16: How Do I Know What Type Of Chart To Choose?
• Customising Excel Charts
• Excel Hack #7: How To Make Snap Judgements On Large Sets Of Data

This course is designed for anyone who is interested in learning how to improve their Excel skills.

No prior knowledge is required to take this course.

Currently there are no Q&As for this course. Be the first to ask a question.