Excel Formulas and Functions

Frontier Education

Course

Online

£ 19 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Beginner

  • Methodology

    Online

  • Duration

    Flexible

Enroll now to go through popular excel formulas and functions.Microsoft certified trainer with a number of years of experience will guide you through the formulas and functions.

Everyday work and home excel formulas and functions are fundamental to complete Excel tasks with efficiency.

At completion of this course you will have mastered the most popular Excel formulas and functions and come out with confidence to complete any Excel tasks with efficiency.

In this Excel formula and function course, you will learn and understand the core theories and practices in Excel formula and function, developing a solid base of knowledge. You will understand core Excel formula and function theories and practices and be able to think critically, actively contributing towards the body of knowledge in the industry and pushing the boundaries with Excel formula and function skills .

Bridging the gap between Excel analysis, the formulas and functions equips you with the necessary technical skills and expertise to take your career to the next level. You’ll gain the knowledge, problem-solving and decision-making skills that are vital in today’s business world, opening your career to a host of exciting career roles.

The Excel formulas and functions course not only sets you up with a deeper understanding of formulas and functions, it equips you with the personal acumen so you can put knowledge into practice and take your career to the next level

About this course

Below are just a few of the topics that you will master:

Building basic maths
Applying auto-sum and relative & absolute references
Mastering the use of named ranges,
Linking sheet and workbooks
If,And,Or and nested functions
Countif, sumif, averageif and other if functions
Vlookup, Hlookup, match index, date, time formula and functions
Text formula, tracing formulas and more
Practical examples to practice this formulas and functions

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel Formula
  • Excel Sheet
  • Excel for Accounting
  • Compressor
  • Computing

Teachers and trainers (1)

Frontier Education

Frontier Education

Education

Course programme

Master Microsoft Excel formulas and functions

Build a solid understanding on the basic functions

Learn the most common Excel functions used in the Office

Harness the full power of Microsoft Excel by automating your day to day tasks

Impress your employer or colleagues by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

This Excel formulas and functions course enables you to delve deeply into the excel formulas and functions, in order to better explore, understand and apply excel skills.

Through this Excel formulas and functions course, you will gain a world-class knowledge and understanding with a focus on the auto-sum and relative & absolute references, linking sheet and workbooks,If,And,Or and nested functions and much more based on solving real life excel applications.

Frontier Education provides working professionals, or those with no previous experience, with trailblazing, practice-based teaching, aimed to inspire and prepare you for a career where applications is the key.

See related categories

Excel Formulas and Functions

£ 19 VAT inc.

The best Excel courses

See all

See all