Excel Essentials
Functions and Formulas
Excel features a wealth of built-in computation tools that can add value to your data analysis. In this course, you’ll discover the most useful functions and formulas to use, as well as how to write, manipulate and audit your own to suit your specific data needs.
Beginner    17 Lessons    210 Minutes    CPD Credits
About This Course
The next step in mastering Excel is to explore the formulas and functions you can use to analyse your data.
Starting with the basics, each lesson in this course will expand your capabilities. You’ll delve into simple calculation formulas and learn how to consolidate data from multiple sheets, discovering how to save time on mundane tasks.
By the end of this course, you’ll become so adept in using functions, that you’ll learn how to create your own to better suit your data’s needs. This customisation will speed up the calculation process and offer you more time to work on what really matters.
Learning Outcomes
-
Use basic arithmetic functions like SUM and AVERAGE
-
Perform conditional arithmetic
-
Use logical operators such as IF, AND, and OR
-
Anchor cells in your formulas
-
Use array formulas
-
Generate and use random numbersAudit your formulas to identify errors
-
Use fill commands to copy formulas between cells
-
Understand how Excel displays and stores numbers
Lessons
1. Basic Arithmetic Operations
2. Conditional Arithmetic
4. Logical Operators
5. Using the Switch Function
6. Naming and Anchoring Cells
Read More
7. Array Formulas
8. More On Array Formulas
9. Using SUMPRODUCT for Conditional Arithmetic
10. Adding Multiple Conditions to SUMPRODUCT
11. Consolidating Multiple Datasets
12. Generating Random Numbers
13. Formula Auditing
14. Fill Commands
15. Information Functions
16. Rounding Numbers
17. Creating Your Own Functions
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
