FINEX Skills Hub

22/05/2023

02/08/2022

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 Pivot Tables enable you to create and modify calculated fields, calculated items and create custom sets for your Pivot Table report...

25/07/2022

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

15/07/2022

5-minute learning: Insert data from pictures in .

All new feature in to insert data from pictures in Windows.

27/06/2022

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

30/05/2022

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:

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...

20/05/2022

5-minute learning: Create automatic abbreviations using TEXTSPLIT in

Get automatic abbreviations from text using the new TEXTSPLIT function in

19/04/2022

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

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

28/03/2022

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

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...

23/03/2022

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

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...

21/03/2022

5-minute learning: Create a direct download link for your files in 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.

16/03/2022

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

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...