Course Excel Formulas and Functions
The Excel formulas and functions training is focused on a detailed explanation of creating formulas and functions in Excel. The aim of the course is to gain an overview of the most commonly used functions from various areas.
Minimum input knowledge
Standard PC operation, experience with Excel: moving around a document, working with worksheets, working with toolbars, setting cell format, copying content and format, basics of working with formulas and functions.
Course dates Excel Formulas and Functions
Daily courses (2 days): 09:00 - 15:00
Course price: 159.00 / 195.57 EUR
without VAT / incl. VAT
The manual is included in the training price.
Training syllabus Excel Formulas and Functions
Basics of Using Formulas and Functions
- Syntax of formulas and functions, nesting functions, division of functions into categories, working with names and references, naming ranges, naming ranges also with formulas, absolute and relative references, dynamic ranges and their intersections, linking worksheets - reference to another worksheet
Debugging Formulas
- Watch window, formula checking mode and panel, arrows, tools, evaluate formula, error checking
Circular References
- Removing intentionally circular references
Conditional Calculations and Logical Functions
- IF, nested IF, AND, OR, SUMIF, COUNTIF
Lookup Functions
- HLOOKUP and VLOOKUP, INDEX and MATCH, INDIRECT and ADDRESS
Date Functions
- TODAY, NOW, DATE, YEAR, MONTH, DAY, DATEDIF, NETWORKDAYS
Text Functions
- CODE, CHAR, TEXT, FIND, LEN, LEFT, RIGHT, MID, SEARCH, REPLACE, SUBSTITUTE, REPT, CONCATENATE
Information Functions
- INFO, ISNUMBER, ISERROR etc.
Array Formulas
- Their use, one-dimensional and two-dimensional arrays, discussion, conclusion
Output knowledge
Creating formulas and functions in Excel at an advanced level. This will lead to more efficient work thanks to more frequent use of automatic data processing in various areas.
Recommended courses after completing Excel Formulas and Functions
Show all courses from category Excel courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Excel Formulas and Functions
Average rating