Intermediate Microsoft Excel Formulas

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
I’ve put together just a few new techniques that are very powerful. When used together, you can process large sums of inconsistent data. I usually see these particular techniques taught in isolation. It’s not until you combine them that they become very powerful. 

TARGET AUDIENCE
You’ll need to be quite familiar with how Excel formulas work. In particular nested formulas which combines multiple formulas in one cell. 

STRUCTURE
This is a very short course with just a few videos. 

DIFFICULTY
This is designed for intermediate to expert users. 

COURSE OUTCOMES

  • Absolute Referencing
  • Cell concatenation
  • Precedents and Dependents tool
  • Formula Auditing

 

Course Structure

  • Intermediate Microsoft Excel Formulas
    • Introduction
      00:00:00
      • Download the file below to follow along!
    • Absolute Referencing
      00:00:00
    • Combine Formulas and Text using Concatenation
      00:00:00
    • Tracing Precedents and Dependents
      00:00:00
    • Formula Auditing using the Show Formulas Function
      00:00:00
    • Thanks for Watching
      00:00:00

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.