Excel advanced 1 – importing data and calculations
Aika: 13.11.2023 klo 09:00
Paikka: Online
In Excel advanced 1 training, we get familiar with the most important features of Excel, including importing data from different sources and calculation and functions. This training is the first part of the Excel advanced course. Second part is its own separate training, that focuses on dynamic calculations and Pivot. GoalYou learn how to import data from different sources and analyze it with functions. We take a look at Xlookup, Vlookup and Sumifs – functions and how to use functions inside of a function. Target audienceThe training is suitable for Excel users who already know the basics of Excel like how to use tables and how to calculate with different formulas. VersionThis training is suitable for Excel 2013, 2016, 2019, and 2022 for Windows and Excel 2016 on Mac ContentAdvanced use of Excel
Advanced calculating
|