Cube Functions - Where the Worksheet Meets the Data Model with Mike Thomas @ExcelExciting
Cube Functions - Where the Worksheet Meets the Data Model with Mike Thomas  @ExcelExciting
Uploaded December 2022 | Updated November 2026, 6 days ago
Join us at this Excel Meetup to hear from Mike Thomas from United Kingdom ๐Ÿ‡ฌ๐Ÿ‡ง about Cube Functions - Where the Worksheet Meets the Data Model

We hear a lot about the benefits of storing your data in Excel's Data Model instead of the worksheet cells. Larger capacity, better performance and the ability to create Pivot Tables from multiple data sources.

But dive a little deeper and you'll find a whole magical world of DAX, Measures and CUBE functions which will help you to take your reporting and data analysis skills to the next level

This session will include...
An overview of the benefits of using The Data Model to store your data
How to create simple Measures using DAX
How to use Excel's family of CUBE functions to pull aggregated values (Sum, Count etc) from the Data Model to the Worksheet
Using CUBE functions to create dynamic Slicers and drop downs

---------------------------
About the Speaker
---------------------------
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.

He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.

Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a diverse range of industries including healthcare, pharmaceutical and public sector.

In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

--------------------------------
Connect with Speaker
--------------------------------
Website : theexceltrainer.co.uk
LinkedIn : linkedin.com/in/thomasmik
YouTube : theexceltrainer.co.uk/youtube
Twitter : twitter.com/thomasmike

-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)

------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.

-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.

**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.

--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
Cube Functions - Where the Worksheet Meets the Data Model with Mike ThomasThe Secrets of Parameters in Power Query (Excel) by Tanja KuhnHow to filter Min & Max Value (Power Query - Excel & Power BI)Extract Number & Text from a Cell in Excel | Solution 02 by Power QueryTwo Best Excel Tricks by Excel Experts (Andreas & Faraz)The Power of 7 Visuals- Exploring Diagrams with Nurana NovruzovaThe lesser known parts of Excel with David StavegรฅrdExcel & Power Automate (Work Best Together) with Faraz ShaikhHow to Install & Setup WhatsApp on Apple Macbook M1 ProExcel Tips & Tricks with Bob UmlasType for you as you speak - New Feature of Office365 | mac & windowsExcel Trick# 20 - Stop dragging! Fill numbers automatically #shorts #excel #excelexciting #micros
Faraz Shaikh |

Cube Functions - Where the Worksheet Meets the Data Model with Mike Thomas

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER