Learn Basic Microsoft Excel Formulas | Excel 2016 Tutorial

Microsoft Excel

Rs. 199

Excel 2016 : Learn Basic Math Operations and Formulae

Equip yourself with the knowledge of Microsoft Excel math operators and basic formulae. Learn techniques which will greatly enhance your productivity.

34m

Lifetime access

5.0

out of 5

116 learners

Course Introduction:

This Microsoft Excel 2016 course for beginners takes you through the basics of the world’s most popular spreadsheet software. Excel can be a complex and confusing software to use. This course offers easily consumable bite-sized pieces of information in simple language, thereby, simplifying Excel.

Course Objectives:

By the end of this course, you will:

Learn how to use Basic Math operators of Addition, Subtraction, Multiplication and Division in Excel.
Gain a good understanding of how to write formulae using these operators.
Understand the difference between absolute and fixed references.
Understand the significance of brackets in Excel formulae.

Pre-requisites and Target Audience:

As the course is designed for beginners, there are no pre-requisites to take up this course. The only requirement for this course is that you must have MS Excel 2013 or MS Excel 2016 installed on your computer.

RECENTLY ENROLLED

Course Plan

1. Introduction to this course

2mins

Preview

1 video

Introduction 02:13

2. Maths operations for beginners

11mins

Preview

4 videos

Multiplying in Excel 02:00

Adding in Excel 05:29

Subtracting in Excel 02:07

Dividing in Excel 02:03

3. Formula tips for beginners

19mins

4 videos

Using Brackets in Excel 04:55

Understanding Absolute and Fixed References 10:03

Best Way For editing Excel Absolute And Relative References 01:48

Excellent Key while Writing Excel Formulas 02:39

4. Wrap up section

20mins

1 video · 1 test

Conclusion 00:55

Test 1 20:00

Meet the Author

Mach 42 Productions

Excel Tutoring/Consulting Services

Mach 42 Productions is an Excel and App Development Consultancy. They are known for their expertise in three areas:

Excel online courses
Excel consulting
App feasibility consulting.

Their Excel courses use real life examples to empower their students with proper skills that can be effectively used at the workplace. Navin, their Excel IT Consultant/ Instructor, has been in the IT industry for approximately 10 years. Recently, he was featured nationwide in Costco Magazine.

He is a Certified Microsoft Office Specialist in Excel since the year 2010. His work in Excel has been varied ranging from automating and streamlining reports to building and deploying real-time dashboards to monitor performance.