FINEX Skills Hub

Fields, Items and Sets in Pivot Tables enable you to create and modify calculated fields, calculated items and create custom sets for your Pivot Table reports. Watch this short video to see how you can use all three to to create custom reports in your .

Fields, Items and Sets in Microsoft Excel Pivot Tables Fields, Items and Sets in Pivot Tables enable you to create and modify calculated fields, calculated items and create custom sets for your Pivot Table report...

How do I lookup a result with more than two lookup values in a database? SUMPRODUCT? What if the result column contains text? Let's explore some solutions in this short video:
https://www.youtube.com/watch?v=2Rv7elJ5Go0&ab_channel=FinexSkillsHub

5-minute learning: Insert data from pictures in .

Insert Data from Picture in Microsoft Excel - Windows All new feature in to insert data from pictures in Windows.

Looking for a way to reference your worksheet name into a cell? In this short video, we will explore two formulas to get this done. The old way or the new way? You decide.

https://www.youtube.com/watch?v=_TBzxQ8Xfcg&ab_channel=FinexSkillsHub

Mastering how to name Cells, Ranges and Tables for calculations in Microsoft Excel can be a real time saver.

In this second episode of our Excel for Work virtual training, we take a look at how you can use these features to work faster in .

Watch video and download workbook to practice along using link below:

Topic 2: Working with Cells, Ranges and Tables in Microsoft Excel Mastering how to name Cells, Ranges and Tables for calculations in Microsoft Excel can be a real time saver. In this second episode of our Excel for Work tra...

5-minute learning: Create automatic abbreviations using TEXTSPLIT in

Create automatic abbreviations using TEXTSPLIT Get automatic abbreviations from text using the new TEXTSPLIT function in

TEXTBEFORE and TEXTAFTER : Exploring two time-saving scenarios for routine office activities.

TEXTBEFORE and TEXTAFTER to extract text strings We explore these two new text functions in and apply them to some common use cases: - Separating text from numbers- Extracting date compone...

5-minute learning: Create a video presentation of your data using 3D Maps in

Create a video presentation of your data using 3D Maps Use 3D Maps to visualize data and save your final report in a video format.Download workbook for practice here: https://onedrive.live.com/d...

5-minute learning: Analyze Data with Cube Functions. Create a Calendar Table in your Data Model
https://www.youtube.com/watch?v=YwhU9RQo0JY

3. Create a Calendar Table in the Data Model - Bernard Obeng Boateng In this episode we will learn how to create a Calendar Table in the Data Model. The Calendar Table helps us analyze our data by Year, Month or Quarter dimens...

5-minute learning: Create a direct download link for your files in OneDrive and Google Drive

Create a direct download link for your files (OneDrive and Google Drive) In this video we show you two ways to create a direct download link for files you have saved in OneDrive and Google Drive.

5-minute learning: Analyze Data with Cube Functions. Create a Data Model for your formulas.

2. Create your Data Model for Cube Formula Calculations - Bernard Obeng Boateng We continue with our build up towards the final Sales Dashboard with Cube Functions. In this episode we explore the Data Model. The Data Model helps us calcu...