Microsoft Excel Formula Design for Beginners
4.0 (227 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,450 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Formula Design for Beginners to your Wishlist.

Add to Wishlist

Microsoft Excel Formula Design for Beginners

Master how to create formula's from the ground up! You'll learn arithmetic, nested functions and automated formula's!
4.0 (227 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,450 students enrolled
Created by Jed Guinto
Last updated 12/2014
Current price: $10 Original price: $100 Discount: 90% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 35 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Manual Calculations
  • Addition, Subtraction, Multiplication and Division
  • Decimal Place Setting
  • Nested Formula's
  • Basic Logic Functions (True and False)
  • Cell Linking
  • Formula Tracing
  • Show Formula's
  • AutoSum Functions - Sum, Average, Count, Max and Min
  • Text and Formula Concatenation
View Curriculum
  • Pen and Paper To Take Notes
  • Microsoft Excel 2007 or Later
  • Access to a Computer/Internet



Created: 2 January 2015

Last Updated: 17 April 2015


Course Achievements

  1. Over 2,300 Students in first two weeks of release!
  2. Over 40 Reviews in first two weeks of release
  3. Over 8,000 minutes consumed in first two weeks of release


Course Description: Formula Design

The proper use and understanding of formula's in Microsoft Excel is essential in mastering the full program. It is a foundation skill that should not be ignored!

I'll teach you from the ground up how to construct and perform manual calculations, nested formula's, logic based functions, cell linkages, autosum functions and text/number concatenation.

Along with these functions I'll also cover additional techniques such as decimal place setting and formula expansion.


Course Details

  1. This course has the shortest and simplest tutorial video's you will ever see! Clear, concise and to the point!
  2. It is designed for the beginner but if you're looking to freshen up on your skills, come on in!
  3. I've intentionally made the video's around 2 minutes or less so that you get your information instantly. NO MORE USELESS CHATTER!!
  5. All future lectures, videos, documents and upgrades included FREE


Instructor Achievements

  1. Member of the Udemy Council
  2. +19,000 students (totalling ~40,000 enrolments)
  3. Average of 300-500 enrolments per day (Highest enrolment rate in one day was 1400 students)
  4. +500 Positive Reviews (5 Star Average Rating across all courses)
  5. +18 Live courses (+20 courses in production)
  6. Incorporated my Udemy courses into RMIT University Laboratory Tutorials for Undergraduate Aerospace Engineers


What Udemy has said about the Instructor

'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'


What students have already said about this course

  1. Benz3311 Excellent Excel Demonstrations. Jed does an exceptional job of explaining specific formulas, functions, tricks and calculations. In only a few brief clicks he has shown me many basic things that I had no idea how to accomplish and didn't overwhelm me with a huge spreadsheet. Just little by little, one step following another step. Hooray for you Jed and thanks for sharing your knowledge!
  2. Ed Chambers Knowing what you are doing! I have worked with Excel for many years, but had to start over every time I had a project. This simple course helped me to understand what needs to be done when working with formulas. The instructor was very good in convening the information to me, as well as entertaining. The production quality of program was very good, enlarged to single in on what the instructor was teaching.
  3. Gbenga Simply amazing! This course was so simple, so quick and straight to the point. In less than 30 minutes I can immediately start using this program thanks to Jed! I can't wait for your next course!
  4. Thaer Sadi Taha Great, effective and very easy to understand. I know enough about Excel, but even though, I learned many things that made me feel Excel is much easier and more creative than I thought. Although I am not a native English speaker, I never felt that way when I watched this course. So, I really want to thank you a lot and recommend everybody to watch your courses. The first video course ever and I never felt bored and never skipped a second.
  5. Inez Bailey Great for someone who knows nothing about Excel. I have a new job and will have to use Excel. I have been looking online for help in learning Excel and have found courses that cost $800. This course was free! It starts with the very basics and is easy to understand. I am looking forward to completing more courses.


Enrol Now and Experience the Benefits

  1. I'll show you step-by-step, I'll explain and highlight every single button I press, I'll draw around important area's and icons with on-screen drawing tools, I'll zoom into small and hard to see area's so you don't miss a single thing!
  2. With over 15 years of experience using Microsoft Excel, I'll let you look over my shoulder as I teach you the fundamentals.
  3. I'll show you exactly how to master this technique in a fraction of the time it takes the average person to learn on their own from books, YouTube videos, blogs and forums!
  4. By mastering this technique you'll become the most productive and most efficient person at your job and at home!
  5. New doors and opportunities will begin opening up for you personally and professional with each new technique you acquire!

Click the “TAKE THIS COURSE" button, top right, NOW!!...every hour you delay you're missing out on huge opportunities!!

Who is the target audience?
  • You should have basic knowledge of Excel; navigation, data inputting, formatting, etc
  • If you’re intermediate or expert and want to freshen up on the fundamentals, no problem, come on in!!
  • People from any country
  • People of all ages
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Demonstration and Uses
2 Lectures 04:14
Formula's, Functions and Calculations
8 Lectures 16:15
Formula Auditing
2 Lectures 05:32

Show Formula's
Bonus Features
3 Lectures 07:42
AutoSum Functions: Sum

Formula and Text Concatenation
1 Lecture 01:11
Course Quiz!
15 questions

About the Instructor
Jed Guinto
4.4 Average rating
5,178 Reviews
62,278 Students
21 Courses
Aerospace Engineer, Business Analyst and Programmer


'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'


'Jed Guinto is something of an Udemy wunderkind!'

'There are all-stars, such as Mr. Guinto, who do well by any metric!'


  1. Member of the Udemy Council
  2. Over 60,000 students
  3. Over 130,000 enrollments
  4. Over 5,000 Positive Reviews


Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! 

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short need to google and waste time finding the perfect approach.


Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world.

In 2011 he traveled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747 and developed his programming and automation skills. 

In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics.

From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries. During this time, he began teaching Excel online. 

In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%. 

In 2016, he founded Paperclip Learning which teaches Microsoft Excel online. 

In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology.