Excel Formula Blueprint

5 (1 rating)
 · 3 students enrolled

About This Course

What if you mastered Excel formulas to the point where you could create Investment Banking quality spreadsheets that are efficient, automated and easy to maintain?

Here’s the blunt truth: I can’t give you a magic pill to learn Excel overnight. What I can do is show you the fastest way to master formulas if you are willing to take action.

Instead of cramming useless Excel theory during 8 boring and confusing hours, why not apply the formulas that you will use on a daily basis whilst also having the spreadsheets in front of you?

This course will allow you to hack over 40 Excel Formulas including:

  • The Formula Bootcamp: Excel beginners will learn the fundamental formulas and IF clauses to have a firm grip over Excel
  • Excel Text Manipulator: Know exactly how to manipulate any Excel text string
  • Excel Pro Formulas: Master the more complex excel functionalities which will completely transform your efficiency in Excel

Take this course today and improve your Excel skills.

Our Promise to You
By the end of this course, you will have learned how to improve your Excel skills.

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 how to improve your Excel skills!

Course Curriculum

Course Sections

Welcome To This Course!

Quick Win: The Excel Shortcuts You Need To Know

Introduction (Spreadsheet Attached)

Beginner’s Guide: Writing Simple Formulas In Excel

Master These 2 Essential Excel Functionalities

Ultimate Guide To Absolute & Relative Referencing

How To Make Sense Of Unfamiliar Formulas

ACTION: Section 2 Class Test (Spreadsheet Attached)

XLS: Section 2 Solution (Spreadsheet Attached)

Introduction (Spreadsheet Attached)

Fundamental Excel Formatting Principles You Need To Know

How To Count & Perform Averages In Excel

Why You Should Use These 2 Variations Of Count

Understanding Minimum & Maximum Values

ACTION: Section 3 Class Test (Spreadsheet Attached)

XLS: Section 3 Solution (Spreadsheet Attached)

Introduction (Spreadsheet Attached)

The IF Function Blueprint

Use These 3 Operators To Add Variety To Your IF Clauses

Hack: Write & Understand Formulas Better By Using This Nifty Trick

Ultimate Guide To Using Nested IFs

Formula Combo: The 3 Formulas That Use IF Clauses

ACTION: Section 4 Class Test (Spreadsheet Attached)

XLS: Section 4 Solution (Spreadsheet Attached)

Introduction (Spreadsheet Attached)

Ensure Proper Text Formatting

The 2 Approaches To Joining Text Strings Together

Use These 4 Formulas To Extract Any Piece Of Text

Here’s How To Ensure Text Accuracy

ACTION: Section 5 Class Test (Spreadsheet Attached)

XLS: Section 5 Solution (Spreadsheet Attached)

Introduction (Spreadsheet Attached)

The 2 Formulas To Search Horizontally OR Vertically In A Spreadsheet

Avoid These Most Common Lookup Mistakes

Here’s How To Approach Nested Lookups

Formula Combo: Using VLookup & Choose

The MATCH Function & Why I Use It All The Time

ACTION: Section 6 Class Test (Spreadsheet Attached)

XLS: Section 6 Solution (Spreadsheet Attached)

Introduction

Match + Index: The Formula Combo That Changed The Way I Worked In Excel

Using Indirect + Address For Accurate Data

The Ultimate Guide To 2 Way Lookups

A Guide To The SumProduct Formula

Dealing With Errors In Excel

About The Instructor

Dragos

I'm an Internet Entrepreneur with a background in both the Management Consulting & Telecommunications industries. The skills that I have acquired during those stints and in previous years in general have unleashed my passion to teach. I have a wide array of skills that I share with you via my courses: (1) Social Media One of my true passions, I have invested a lot of time building a presence online. Highlights include: Creating a connection base of 100+ people in a large Management Consulting firm within weeks of starting the job. Met with a handful of Managing Directors & Senior Managers after approaching them on Social Media Trained Partners on how to effectively make use of LinkedIn & Twitter to network and generate leads Conducted Workshops with Project Teams and Small Enterprises on the use of Twitter and LinkedIn. (2) Resume/CV & Interviewing With 30+ Job applications, I have gained a deep understanding of the recruiting process I have never failed to get an interview (phone or face-to-face) after submitting my Resume Participated in over 20 Job Interviews & Assessment Centres Worked for a leading Management Consulting firm in a highly competitive market. (3) Productivity Heavy user of Microsoft Excel & PowerPoint. I completely rebuilt the spreadsheets inherited from one of my teams, reducing the monthly updating time by over half the time (a few business days) Co-produced reports that were ultimately held by members of the Board of Directors in one of the Multinationals I worked in (using Excel & PowerPoint) General productivity freak, I love technology and always look for ways to make it work for me. How I got here… Until recently I never really envisioned myself starting my own business. In fact, it was quite the opposite - my dream was to work for a large Multinational Consulting company and enjoy the riches of the Corporate life… I soon found myself in what I thought would be my "dream job" only to do work that wasn't at all fulfilling, spending hours every day commuting and paying enormous rent (almost half of my salary) in one of the largest cities in the world. I felt stuck, limited and didn't think much of my future prospects. I look back now and find it funny how at our lowest points we make life-changing decisions. Since a few members of our Mastermind Group had launched online businesses, I decided I would give it a try. I made up my mind that whatever happened, I absolutely HAD to launch an online product before my birthday. Within two months, I launched my first course. One month later I decided to quit my job (to the utter amazement of my colleagues, managers, friends & family - they probably thought I was crazy) and never looked back since. My Goal What I aim for is simple: I want to get you real results in the fastest possible time. Whether it's improving your presence on Social Media, getting your dream job, improving your productivity or self-development, I want you to walk away from my courses with a sense of achievement. The courses I create are structured in a step-by-step manner so that you can implement them straight away. They do require your effort & commitment, but if you do that I'm extremely confident you can get to the next level. Ultimately, receiving a message from a satisfied student detailing how I've helped him or her is immensely gratifying, more so than any number of sales. Get in touch!

Reviews

Average Rating by 1 students
5
  1. Profile photo of Lesha Lesha says:

    Excellent
    This course was good in dealing with formulas and how to apply them.

  • $199.00 USD
  • UNLIMITED ACCESS
  • Course Certificate
  • 24/7 Support