Excel 365- Spill Formulas and New Functions: Clearer and Faster Training Course
This course is designed for participants who have previously worked with Microsoft Excel. We focus exclusively on functions available in Excel 365: spill formulas and the # operator, the dot (.) operator, new lookup functions, sorting and filtering functions, array helpers, text functions, and functions that improve readability and speed. Participants will learn practical patterns for building short, readable formulas without helper columns and for using dynamic arrays in everyday tasks.
This course is available as onsite live training in Azerbaijan or online live training.Course Outline
- Spill formulas.
- The # operator and the dot (.) operator.
- New lookup functions (XLOOKUP, XMATCH).
- New sorting and filtering functions (SORT, FILTER, UNIQUE).
- New array helpers (VSTACK, HSTACK, TOCOL, TOROW).
- New text functions (TEXTJOIN, TEXTBEFORE, TEXTAFTER).
- Functions that improve readability and performance (LET, LAMBDA, MAP).
Need help picking the right course?
azerbaijan@nobleprog.com
Excel 365- Spill Formulas and New Functions: Clearer and Faster Training Course - Enquiry
Testimonials (2)
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
Related Courses
Working with spreadsheet in Microsoft Excel
14 HoursExcel Advanced with VBA
21 HoursVisual Basic for Applications (VBA) in Excel (intermediate level)
14 HoursMicrosoft Office Excel - working effectively with the spreadsheet
14 HoursVisual Basic for Applications (VBA) for Analysts
21 HoursThis instructor-led, live training in Azerbaijan (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.
By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.
Microsoft Office Excel - intermediate level
14 HoursExcel is a popular spreadsheet program created by Microsoft. Jest used to store, organize and analyze data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array consisting of cells arranged in rows and columns. It allows you to create multiple sheets in one file, which allows you to organize different data sets. 2. Calculations and Formulas: Allows you to perform a variety of mathematical, statistical and logical calculations using formulas. It has a wide set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: Provides tools for formatting data, including changing font, color, style, and creating charts, pivot tables and diagrams. 4. Sorting, Filtering and Grouping: Allows you to sort data according to specific criteria. Allows you to filter data to display only selected information. Possibility to group data depending on needs. 5. Data analysis: Tools for performing advanced analyzes such as scenario analysis, trends, forecasting, and creating macros. 6. Data Sharing: Enables real-time data sharing and collaboration, allowing multiple users to work on the same data simultaneously. 7. Task automation: Ability to create macros and automate tasks using the programming language VBA (Visual Basic for Applications). Excel is widely used in various fields, from business to science and education. Its comprehensive features enable data analysis, creation of reports, budgets, schedules, data management and many other applications.
Advanced Excel for Sales Professionals: Data Analysis, Reporting, and Automation
35 HoursThis 5-day Advanced Excel for Sales Professionals course is designed to equip sales teams with the skills needed to manage, analyze, and automate sales data efficiently. Participants will learn advanced Excel functions, data analysis techniques, and automation tools to enhance reporting accuracy, create dynamic dashboards, and forecast sales performance. Through hands-on exercises, sales professionals will gain practical insights into building interactive sales reports, automating repetitive tasks, and using advanced tools like Power Query, Power Pivot, and Macros. This course is ideal for those looking to leverage Excel to drive data-driven sales strategies.
Excel - Best Practices for Everyday Work
7 HoursExcel in One Day
7 HoursThis live instructor-led training (onsite or remote) will guide you through the most important tools of MS Excel. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the vast possibilities of excel spreadsheet use.
In compartision to other typical excel courses, this tarining will uncover many uniqe excel functionalities that will speed up and enhance your work.
Analysing Financial Data in Excel
14 HoursExcel Basics
14 HoursLearn essential Microsoft Excel skills in this beginner-focused training in Azerbaijan. The course covers data entry, formatting, formulas, functions, tables, and data visualization, helping participants build a strong foundation for data analysis and reporting in real-world environments.
Microsoft Excel (Basic, Intermediate, and Advanced)
28 HoursThis instructor-led, live training in Azerbaijan (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.
By the end of this training, participants will be able to:
- Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
- Apply advanced formulas, functions, and conditional formatting for data analysis.
- Create and manage pivot tables and charts for data visualization.
- Use tools like Power Query, Power Pivot, and perform data analysis.
- Automate tasks using macros and VBA to streamline workflows.