Year: 2015

Manufacturer: Mach 42 Productions / Udemy

Manufacturer Website: udemy.com

Duration: 0:34

Type dispensed material: videos

Language English

Description: Hi there, are you fairly new to Excel?

This very short bite size course will simply teach you in Excel 2016, how to do the following:

1) Basic Excel math operations- add, subtract, multiply and division

2) Teach core concepts to writing calculations / formulas in Excel

Each lecture is simple and concise and there are short quizzes to reinforce your knowledge.

Excel is one of the power tools of the world. Every business uses it. So a basic level and understanding is needed. This course aims to give you that. Note you can use any version of Excel from 2007 onwards for Windows for this course. The concepts are the same for each version of Excel!

Thank you for taking the time to read this and I look forward to seeing you on the other side.













Using Formulas in Excel 2016



Section 1: Introduction

Introduction



Section 2: Basic math operations

How to add in Excel

Excel Adding quiz - 2 questions

How to subtract in Excel

Excel Subtraction quiz - 2 questions

How to multiply in Excel

Excel multiplication quiz - 2 questions

How to divide in Excel

Excel division quiz - 1 question



Section 3: Beginners formula tips

Brackets matter! Key rule to Excel success

Excel brackets quiz - 6 questions

Absolute and fixed references explained

Handy shortcut key for editing Excel absolute and relative references

Excel references quiz - 4 questions

Super handy shortcut when writing Excel formulas



Section 4: The end!

End lecture



Section 5: Bonus section

Add your course completion certificate to LinkedIn - Text







Example Files: None

Video Format: MP4

Video: AVC, 1234x720 (1.714: 1) / 1152x720 (16:10), 30fps, 319kbps

Audio: AAC, 44.1kHz, 64kbps, stereo