Excel - Building Blocks

Easy

Text

Text

Business Knowledge

9 Lessons

0% Not started

This introductory Excel course is aimed at complete novices with little to no prior Excel experience.

It is intended to give the candidates a good grounding on the use of Excel and start them on their journey to becoming confident users of this very powerful and useful programme.

Excel - Building Blocks

Excel Building Blocks

9 Lessons

By the end of this lesson, you will understand the difference between a function and a formula.

Text lesson

By the end of this lesson, you will understand the difference between a function and a formula.

Text lesson

By the end of this lesson you will understand the components of a cell reference and the difference between a relative reference and an absolute reference, vital in building powerful formulas.

Text lesson

At the end of this lesson you have mastered how to reference other worksheets within the same workbook.

Text lesson

Use of the SUM( ) function to explain the concepts of arguments in functions and the required syntax

Text lesson

When you want to see the total, count etc WITHOUT using a function to do so.

Text lesson

Essential knowledge about how Excel performs calculations.

Text lesson

These functions are among the easiest to use and, arguably, the most useful.

Text lesson

In this section we thought we would look at one of Excels most useful Functions: IF( )

Text lesson

Follow

About the teacher

Ashraf Rahman

I am an experienced Analyst and Reporting Manager with a verifiable track-record for the delivery of Information Enhancements that balance requirements against realistic goals.

I produce complex Excel-based dashboards, using VBA & SQL to leverage its automation and production

Comments are closed.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}