- Murilo Fonseca MarinExcel for Business - Formulas and FunctionsExcel for Business - Formulas and FunctionsNovember 5, 2024Excel for Business - Formulas and Functions

Murilo Fonseca Marin
Excel for Business - Formulas and Functions
Excel for Business - Formulas and Functions
November 5, 2024
Excel for Business - Formulas and Functions
Murilo Fonseca Marin
Working with data is part of everyone’s role and learning how to harness the power of Excel to improve productivity and efficiency is the becoming increasingly important for individuals, teams and companies to succeed. This one-day course builds on existing knowledge of simple formulas and enables participants to use more advanced formulas and functions to extract rich management information for business decision-making in diverse areas such as sales, projects, budgets, forecasts, and human resources. Using a real-world scenario, participants will have learnt how to construct formulas and use Excel’s inbuilt advanced functions in large data sets to extract business information.
Skills / Knowledge
- Prepare data - Use Power Query to clean and transform data
- Logical functions - Automate tasks by testing values in other cells and performing actions dependent upon the result of the tests
- Nest functions - Use one or more functions within another function to create more complex and powerful formulas to perform calculations, manipulate data, or make logical evaluations
- Conditional functions - Create logical calculations to automate “If (this), then (that)”
- Essential functions - Use essential array functions to make unique list and sort, filter, and transpose data; create geographical maps
- Lookup and reference functions - Work with ranges of data and cross reference between different data sets
- Date and time functions - Extract information from, and perform operations on dates and times
- Text functions – Manipulate strings to help work with names, addresses, customer lists, or any other text-based data
Issued on
November 5, 2024
Expires on
December 31, 2075