Finex Skills Hub

Clean and Transform Data with Power Query and ChatGPT

Finex School Orientation Class in Data Analytics with Excel, Power BI, Copilot and ChatGPT

Create an Inventory Management Dashboard in Power BI | Full Tutorial

Create a Dynamic Debtors Aging Report in Power BI with a Payment Tracker and Progress Bar

Create a full PowerPoint presentation with Copilot in 5 minutes

Create an Excel Reconciliation Report in 5 minutes with Copilot for Finance

Create an Annual Budget with Flexible Scenarios in Excel | Base, Best, and Worst Case Analysis

Create a Dynamic Aging Report in Excel | Automate Invoice Tracking with Power Query & Power Pivot

Stage Multiple Charts in an Excel Dashboard with Slicers | Dynamic Arrays & Cube Functions Tutorial

Create a Dynamic Commentary in your Power BI Reports with Smart Narrative

Create a Text Analytics Dashboard in Excel using Cartesian Join and Bubble Charts

Live Orientation Session: Training in Data Analytics with Excel and Power BI - Finex School 15

Master the New Excel Checkbox Feature: Create a Family-Time Dashboard Easily!

Create a Dynamic FIFO template in Excel to track Inventory

Create a Dynamic Investment Template with Dynamic Arrays: WRAPCOLS and SEQUENCE

Create Dynamic Labels for your Excel Dashboards with Picture in Cell

Create a Waterfall Calculation Using Excel's Dynamic Arrays: Capital Allowance Case Study

Getting Started with Power BI: Complete Power BI beginners Case Study - Full Course

Create your own shortcuts with Macros

Create a custom function to combine two lists into one dynamic list.(LAMBDA editor)

Lookup with Pictures in Excel

Create separate reports from your Pivot Table summary

5. Insert Slicers and Timelines in your formulas using Cube Functions

Separate Text from Number with Dynamic Array functions TEXTAFTER, TEXTBEFORE.

Create Custom Shape Maps in Power BI | Visualize Map Data with Native Shape Visual

Excel Hacks Challenge 1

Calculate Year to Date Values with the TOTALYTD DAX Function

Create an Annual Budget in 5 Minutes (Solution)

Convert Text to Date in Excel

6. Master 6 Excel Cube Functions: Practical Guide for CUBEVALUE, CUBERANKEDMEMBER, CUBESET and more!

Create a Personal Finance App using AppSheet (Money Matters App): Part 4

Unlock the Full Potential of Power BI: Master the "Publish to Web" Feature to Reach a Wider Audience

Use Slicer outputs in your formulas - Bernard Obeng Boateng

Create a Dynamic Layout for your Financial Model in Microsoft Excel

A short Data Viz Story: What Causes High Inflation in Ghana?

Next Level Logic Functions: IF, XOR, SWITCH in Microsoft Excel

Create engaging Business Presentations with the Zoom feature in PowerPoint

3. Create a Calendar Table in the Data Model - Bernard Obeng Boateng

Convert Numbers to Words in Microsoft Excel (3 options)

Microsoft Excel Business Intelligence Workflow Explained | Power Query, Power Pivot, DAX & Dashboard

Send Bulk Emails using Excel and Outlook

Group dates in pivot tables using different timelines

Apply conditional formatting to entire row

Finex School Orientation Class in Data Analytics with Excel, Power BI, Copilot, ChatGPT, Bricks etc.

Mail Merge with two versions of your document on one page

New Ways to Summarize Data with New Dynamic Array Functions GROUPBY and PIVOTBY: Actual v Budget 1

Use Date Intervals to Create Rows in Power Query

Create and display pop-up pictures in cells

Goal Seek for Multiple Cells in Excel | Payroll Case Study with PAYE Tax Calculations

Get linked images from Google Drive in Excel Dashboards using the IMAGE function

Python in Excel: Analyze Text Data in Google Form Responses

Topic 5: Manipulating Data in Excel with Text functions

Consolidate data from multiple sources into one Pivot Table

Actual v Budget Progress Chart with the new Card Visual in Power BI.

SNAKE SUM with Dynamic Array Functions FILTER, TOCOL, DROP in Microsoft Excel.

Create Maps in Power BI using the ArcGIS Visual

Create a Dynamic Actual v Budget Personal Finance Dashboard in Excel | Power Query, Power Pivot, DAX

Create separate rows from multiple Enumlist selections in AppSheet.

Create an Actual v Target Variance Chart