عربي
عربي
Passionately developing careers since 2000.
عربي
عربي
Why Attend
This training course delves into advanced, and most recently added, Excel functions like XLOOKUP, TEXTJOIN, TEXTSPLIT, UNIQUE, SORT, and FILTER, enabling you to streamline your data tasks with ease. The course will cover Power Query to import and transform data from various sources, such as Excel files, folders, PDFs, and websites, preparing it for further analysis and reporting. Additionally, the course introduces Power Pivots, which teaches you how to create sophisticated data models, establish relationships between tables, and craft decisive DAX measures for complex calculations. This course is designed to elevate your Excel skills, enhance your productivity, and provide you with the tools needed for advanced data analysis and reporting.
Overview
Course Outline
Schedule & Fees
Methodology
This is a hands-on course with practical applications using Microsoft Excel 2021 or Office 365 throughout the five days. All examples, exercises, and cases are practiced in Excel.
Course Objectives
By the end of the course, participants will be able to:
Apply key Excel functions to prepare data for analysis and reporting
Utilize pivot tables functions and calculations to generate a set of management and business analysis reports
Utilize Power Query to clean up and prepare data for reporting
Report and analyze big data using Power Pivots
Utilize Excel automation solutions to speed up work
Target Audience
Accountants, senior and junior accountants, business analysts, accounting and finance professionals, business analysts, research professionals, and staff from any function who need to master and upgrade their skills in Excel functions, pivot tables, Power Query, and Power Pivots and work with big data analysis.
Target Competencies
Excel functions
Power Query
Practicing pivot tables
Utilizing Power Pivot
Reporting
Analyzing business data
Larimar will help you find what you are looking for
