Канал: Finex Skills Hub

Create a Balance Sheet Dashboard in Excel

Create a Balance Sheet Dashboard in Excel

Exploring Zoom Options in Power BI Shape Maps

Exploring Zoom Options in Power BI Shape Maps

Clean and Transform Data with Power Query and ChatGPT

Clean and Transform Data with Power Query and ChatGPT

Finex School Orientation Class in Data Analytics with Excel, Power BI, Copilot 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 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 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 a full PowerPoint presentation with Copilot in 5 minutes

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

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

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

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 Dynamic Commentary in your Power BI Reports with Smart Narrative

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

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

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

Create an Interactive Power BI with Waffle Chart and Global Shape Map | World Bank Data

Create an Interactive Power BI with Waffle Chart and Global Shape Map | World Bank Data

Create an interactive HR Dashboard in Excel using Power Query, Power Pivot and PivotTables.

Create an interactive HR Dashboard in Excel using Power Query, Power Pivot and PivotTables.

Create a Personal Actual vs Budget Dashboard in Excel | Power Query, PivotTables, Power Pivot

Create a Personal Actual vs Budget Dashboard in Excel | Power Query, PivotTables, Power Pivot

Create an Inventory Management Dashboard in Excel: No Functions, Just PivotTables and Power Pivot

Create an Inventory Management Dashboard in Excel: No Functions, Just PivotTables and Power Pivot

How to Analyze Google Form Responses with Power BI | Step-by-Step Tutorial

How to Analyze Google Form Responses with Power BI | Step-by-Step Tutorial

Create Interactive Visuals in Power BI with Bookmarks

Create Interactive Visuals in Power BI with Bookmarks

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

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

Create a Dynamic Actual v Budget Dashboard in Excel using Power Query, Power Pivot, DAX, and Cubes

Create a Dynamic Actual v Budget Dashboard in Excel using Power Query, Power Pivot, DAX, and Cubes

Online Lookup with Power Query and Power Pivot

Online Lookup with Power Query and Power Pivot

Unlock the Power of Forecasting with Power BI and Excel | Step-by-Step Tutorial

Unlock the Power of Forecasting with Power BI and Excel | Step-by-Step Tutorial

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

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

A CONTAINS FUNCTION IN MICROSOFT EXCEL? | Workaround with MATCH, OR, EXACT & More

A CONTAINS FUNCTION IN MICROSOFT EXCEL? | Workaround with MATCH, OR, EXACT & More

Unlock the Full Potential of Excel for Data Analysis with Power Pivot | Learn How!

Unlock the Full Potential of Excel for Data Analysis with Power Pivot | Learn How!

Combine Trial Balance Data with Power Query for Month on Month Analysis in Excel.

Combine Trial Balance Data with Power Query for Month on Month Analysis in Excel.

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

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

Finex School Training in Data Analytics with Power BI and Excel for Work - Season 14 Orientation

Finex School Training in Data Analytics with Power BI and Excel for Work - Season 14 Orientation

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

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

Topic 10 - Analysing Data with PivotTable - Part 2

Topic 10 - Analysing Data with PivotTable - Part 2

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

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

Topic 10 - Master PivotTables in Excel: A Comprehensive Guide for Beginners: Part 1

Topic 10 - Master PivotTables in Excel: A Comprehensive Guide for Beginners: Part 1

Free Payroll Template with new Income Tax (PAYE 2024)

Free Payroll Template with new Income Tax (PAYE 2024)

Demystifying Excel Icon Sets for Conditional Formatting: A Guide on when to use Number / Percentage.

Demystifying Excel Icon Sets for Conditional Formatting: A Guide on when to use Number / Percentage.

Reset or Clear all Slicers in your Excel Dashboard with One Click

Reset or Clear all Slicers in your Excel Dashboard with One Click

Calculate Year to Date Values with the TOTALYTD DAX Function

Calculate Year to Date Values with the TOTALYTD DAX Function

Topic 9 - Master Cell Referencing and Named Ranges to create effective formulas

Topic 9 - Master Cell Referencing and Named Ranges to create effective formulas

Unlock the Power of Excel Online! Learn a Simple Trick to Publish Data Model Excel Dashboards online

Unlock the Power of Excel Online! Learn a Simple Trick to Publish Data Model Excel Dashboards online

Master Excel for Accounting: Create a Dynamic Journal & Trial Balance Template.

Master Excel for Accounting: Create a Dynamic Journal & Trial Balance Template.

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

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

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

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

Dynamic Arrays and Cell Referencing in Excel

Dynamic Arrays and Cell Referencing in Excel

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

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 FIFO template in Excel to track Inventory

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

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

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

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

Excel Hacks Challenge 1

Excel Hacks Challenge 1

Create separate rows from multiple Enumlist selections in AppSheet.

Create separate rows from multiple Enumlist selections in AppSheet.

Convert Multiple Currencies with Slicers in your Excel Dashboards. | Bernard Obeng Boateng

Convert Multiple Currencies with Slicers in your Excel Dashboards. | Bernard Obeng Boateng

No more copy and paste presentations. Seamlessly connect Power BI and PowerPoint.

No more copy and paste presentations. Seamlessly connect Power BI and PowerPoint.

Create one custom script to truncate your values to 'M' Million or 'K' Thousand in Microsoft Excel

Create one custom script to truncate your values to 'M' Million or 'K' Thousand in Microsoft Excel

Create an Interactive Picture Album with Slicers in Microsoft Excel

Create an Interactive Picture Album with Slicers in Microsoft Excel

Create a Dynamic Layout for your Financial Model in Microsoft Excel

Create a Dynamic Layout for your Financial Model in Microsoft Excel

Create Dynamic Labels for your Excel Dashboards with Picture in Cell

Create Dynamic Labels for your Excel Dashboards with Picture in Cell

FINEX SCHOOL'S TRAINING IN MICROSOFT EXCEL, DATA ANALYTICS & FINANCIAL MODELING - ORIENTATION CLASS

FINEX SCHOOL'S TRAINING IN MICROSOFT EXCEL, DATA ANALYTICS & FINANCIAL MODELING - ORIENTATION CLASS

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

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

Create a Loans in Default Aging Analysis Heatmap in Microsoft Excel

Create a Loans in Default Aging Analysis Heatmap in Microsoft Excel

Create Dynamic Colors for your Charts in Excel

Create Dynamic Colors for your Charts in Excel

Topic 8 - Simulation in Excel Using Goal Seek, Solver, Scenario Manager & Data Tables

Topic 8 - Simulation in Excel Using Goal Seek, Solver, Scenario Manager & Data Tables

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

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

Free Payroll Template with new Income Tax (PAYE 2023)

Free Payroll Template with new Income Tax (PAYE 2023)

A Short Video: Visualizing the African IMF Race.

A Short Video: Visualizing the African IMF Race.

Connect Power Query to Personal OneDrive Files

Connect Power Query to Personal OneDrive Files

The Power of X in a LOOKUP: Discover how to use XMATCH and XLOOKUP to lookup results without sorting

The Power of X in a LOOKUP: Discover how to use XMATCH and XLOOKUP to lookup results without sorting

Dues Tracking Template for Clubs and Societies

Dues Tracking Template for Clubs and Societies

Use Excel's Filled Map and PowerPoint to create stunning visuals

Use Excel's Filled Map and PowerPoint to create stunning visuals

Convert Text to Date in Excel

Convert Text to Date in Excel

Topic 7 - Understand Excel Date Functions

Topic 7 - Understand Excel Date Functions

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

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

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

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

Topic 6 - Logic Functions in Excel

Topic 6 - Logic Functions in Excel

Use Glass Morphism to Design your Power BI Reports

Use Glass Morphism to Design your Power BI Reports

Career Options in Data

Career Options in Data

Create a Custom Map in Power BI

Create a Custom Map in Power BI

How to enable Appsheet's New Desktop Mode.

How to enable Appsheet's New Desktop Mode.

Data Analytics 101: Structuring your Data Properly

Data Analytics 101: Structuring your Data Properly

Topic 5: Manipulating Data in Excel with Text functions

Topic 5: Manipulating Data in Excel with Text functions

Convert Numbers to Words in Microsoft Excel (3 options)

Convert Numbers to Words in Microsoft Excel (3 options)

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

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

FINEX SCHOOL'S TRAINING IN MICROSOFT EXCEL, DATA ANALYTICS & POWERPOINT - ORIENTATION CLASS

FINEX SCHOOL'S TRAINING IN MICROSOFT EXCEL, DATA ANALYTICS & POWERPOINT - ORIENTATION CLASS

Create engaging Business Presentations with the Zoom feature in PowerPoint

Create engaging Business Presentations with the Zoom feature in PowerPoint

Create an Income Statement Dashboard in Power BI to compare two years of Financials

Create an Income Statement Dashboard in Power BI to compare two years of Financials

Create a Dynamic Calendar Slicer for your Dashboards

Create a Dynamic Calendar Slicer for your Dashboards

Thank You for an Exciting 2022

Thank You for an Exciting 2022

Format your Lookup Values Automatically

Format your Lookup Values Automatically

Year over Year % (YoY) Change with Pivot Tables, DAX and Cube Formulas

Year over Year % (YoY) Change with Pivot Tables, DAX and Cube Formulas

Filter by Columns in Microsoft Excel | Daniel Owusu Yeboah

Filter by Columns in Microsoft Excel | Daniel Owusu Yeboah

Simulate Calculation Scenarios in your Excel Dashboards using Slicers and SELECTEDVALUE in Excel.

Simulate Calculation Scenarios in your Excel Dashboards using Slicers and SELECTEDVALUE in Excel.

TOPIC 4: Lookup with Ease Using INDEX + MATCH, XLOOKUP & FILTER Functions

TOPIC 4: Lookup with Ease Using INDEX + MATCH, XLOOKUP & FILTER Functions

Convert a Flat Table with Data into a Lookup Summary Report using Power Query

Convert a Flat Table with Data into a Lookup Summary Report using Power Query

Create a Personal Finance App using AppSheet (Money Matters App): Part 2 | Daniel Yeboah Owusu

Create a Personal Finance App using AppSheet (Money Matters App): Part 2 | Daniel Yeboah Owusu

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

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

Excel Our Girls Season II - Graduation and Low-Code App Development Competition

Excel Our Girls Season II - Graduation and Low-Code App Development Competition

Create an Income Statement Dashboard to compare two years of Financials | Bernard Obeng Boateng

Create an Income Statement Dashboard to compare two years of Financials | Bernard Obeng Boateng

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

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

Calculate Dynamic Customer Balances using the Data Model

Calculate Dynamic Customer Balances using the Data Model

Create a Mobile App to update your Excel Dashboards | Daniel Owusu Yeboah

Create a Mobile App to update your Excel Dashboards | Daniel Owusu Yeboah

SUM by YEAR and MONTH with Conditional Formatting in Microsoft Excel - 3 options

SUM by YEAR and MONTH with Conditional Formatting in Microsoft Excel - 3 options

FINEX SCHOOL'S TRAINING IN MICROSOFT EXCEL, DATA ANALYTICS & FINANCIAL MODELING - ORIENTATION CLASS

FINEX SCHOOL'S TRAINING IN MICROSOFT EXCEL, DATA ANALYTICS & FINANCIAL MODELING - ORIENTATION CLASS

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

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

E-Levy Dashboard: Create a Dynamic Data Label for your Charts

E-Levy Dashboard: Create a Dynamic Data Label for your Charts

Visualizing Ghana's Population by Region and Religion using an Excel Dashboard

Visualizing Ghana's Population by Region and Religion using an Excel Dashboard

Creating a Calendar Chart in Microsoft Excel | Daniel Yeboah Owusu

Creating a Calendar Chart in Microsoft Excel | Daniel Yeboah Owusu

Building Dashboards with Microsoft Excel - OUI Bootcamp Nigeria

Building Dashboards with Microsoft Excel - OUI Bootcamp Nigeria

Create a Personal Financial Dashboard to compare your Actual v Budget numbers| Bernard Obeng Boateng

Create a Personal Financial Dashboard to compare your Actual v Budget numbers| Bernard Obeng Boateng

Fields, Items and Sets in Microsoft Excel Pivot Tables

Fields, Items and Sets in Microsoft Excel Pivot Tables

Boolean Lookup: Search with more than two lookup values in Microsoft Excel

Boolean Lookup: Search with more than two lookup values in Microsoft Excel

Insert Data from Picture in Microsoft Excel - Windows

Insert Data from Picture in Microsoft Excel - Windows

Link Worksheet Names to Cells using TEXTAFTER

Link Worksheet Names to Cells using TEXTAFTER

Topic 3: Creating Conditional Totals | Microsoft Excel Training Ghana

Topic 3: Creating Conditional Totals | Microsoft Excel Training Ghana

Topic 2: Working with Cells, Ranges and Tables in Microsoft Excel | Microsoft Excel Training Ghana

Topic 2: Working with Cells, Ranges and Tables in Microsoft Excel | Microsoft Excel Training Ghana

Extract Taxable Amount from a Calculated Tax Value: Value Added Tax VAT Ghana

Extract Taxable Amount from a Calculated Tax Value: Value Added Tax VAT Ghana

Topic 1: Overview of Microsoft Excel and useful shortcuts | Microsoft Excel Training Ghana

Topic 1: Overview of Microsoft Excel and useful shortcuts | Microsoft Excel Training Ghana

Create automatic abbreviations using TEXTSPLIT

Create automatic abbreviations using TEXTSPLIT

Show Red for Overspend in Dynamic Actual v Budget Doughnut Chart

Show Red for Overspend in Dynamic Actual v Budget Doughnut Chart

Data Normalization: Creating the best layout for your data in Microsoft Excel

Data Normalization: Creating the best layout for your data in Microsoft Excel

Use Date Intervals to Create Rows in Power Query

Use Date Intervals to Create Rows in Power Query

TEXTBEFORE and TEXTAFTER to extract text strings

TEXTBEFORE and TEXTAFTER to extract text strings

Sharing the "Excel our Girls" experience - Ewurabena Benyiwa Biney

Sharing the "Excel our Girls" experience - Ewurabena Benyiwa Biney

Sharing the "Excel our Girls" experience - Monanyun Nmon Grace

Sharing the "Excel our Girls" experience - Monanyun Nmon Grace

Sharing the "Excel our Girls" experience - Ewuradwoa Nkrumah Nyameye Odum

Sharing the "Excel our Girls" experience - Ewuradwoa Nkrumah Nyameye Odum

Sharing the "Excel our Girls" experience - Jessica Sem

Sharing the "Excel our Girls" experience - Jessica Sem

Sharing the "Excel our Girls" experience - Jennifer Eyram Quarcoo

Sharing the "Excel our Girls" experience - Jennifer Eyram Quarcoo

Sharing the "Excel our Girls" experience - Patience Ama Mensah

Sharing the "Excel our Girls" experience - Patience Ama Mensah

Sharing the "Excel our Girls" experience - RACHEAL ARKORFUL

Sharing the "Excel our Girls" experience - RACHEAL ARKORFUL

Consolidate multiple worksheet reports into one using VSTACK

Consolidate multiple worksheet reports into one using VSTACK

Green Team: Urbanization. Can it be sustained? - Excel our Girls 1

Green Team: Urbanization. Can it be sustained? - Excel our Girls 1

Red Team: Diffusing the Demographic Bomb - Excel our Girls 1

Red Team: Diffusing the Demographic Bomb - Excel our Girls 1

Yellow Team: Overpopulation and Housing Deficit in Accra - Excel our Girls 1

Yellow Team: Overpopulation and Housing Deficit in Accra - Excel our Girls 1

Blue Team: Solving Housing Problems in Ghana the Ghanaian way - Excel our Girls 1

Blue Team: Solving Housing Problems in Ghana the Ghanaian way - Excel our Girls 1

Money Matters with Excel: Calculate and Visualize Breakeven units in Microsoft Excel

Money Matters with Excel: Calculate and Visualize Breakeven units in Microsoft Excel

4. Create your Measures for Cube Formulas

4. Create your Measures for Cube Formulas

Create a video presentation of your data using 3D Maps

Create a video presentation of your data using 3D Maps

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

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

Create a direct download link for your files (OneDrive and Google Drive)

Create a direct download link for your files (OneDrive and Google Drive)

2. Create your Data Model for Cube Formula Calculations - Bernard Obeng Boateng

2. Create your Data Model for Cube Formula Calculations - Bernard Obeng Boateng

1. Overview of Sales Dashboard with Cube Functions - Bernard Obeng Boateng

1. Overview of Sales Dashboard with Cube Functions - Bernard Obeng Boateng

Highlight the results of your 2-way lookup

Highlight the results of your 2-way lookup

Analyze your Data with Microsoft Excel Cube Functions - Bernard Obeng Boateng

Analyze your Data with Microsoft Excel Cube Functions - Bernard Obeng Boateng

Create an Actual v Target Variance Chart

Create an Actual v Target Variance Chart

Analyze your Actual and Budget with one Pivot Table - Bernard Obeng Boateng

Analyze your Actual and Budget with one Pivot Table - Bernard Obeng Boateng

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

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

Happy "Excel" Valentine from Finex Skills Hub

Happy "Excel" Valentine from Finex Skills Hub

Use Slicer outputs in your formulas - Bernard Obeng Boateng

Use Slicer outputs in your formulas - Bernard Obeng Boateng

Saving Towards a Target Amount - Bernard Obeng Boateng

Saving Towards a Target Amount - Bernard Obeng Boateng

SUM based on a string of characters

SUM based on a string of characters

Create and Analyze your Budget - Bernard Obeng Boateng

Create and Analyze your Budget - Bernard Obeng Boateng

Calculate Income Tax (PAYE) using Graduated Tax Rates (LAMBDA) - Bernard Obeng Boateng

Calculate Income Tax (PAYE) using Graduated Tax Rates (LAMBDA) - Bernard Obeng Boateng

Get your Top 5 Income and Expense lines - Bernard Obeng Boateng

Get your Top 5 Income and Expense lines - Bernard Obeng Boateng

Grouping Criteria using SUMPRODUCT and Pivot Tables

Grouping Criteria using SUMPRODUCT and Pivot Tables

Comparing Cell Referencing in Legacy and Dynamic Array Excel

Comparing Cell Referencing in Legacy and Dynamic Array Excel

Create a dynamic drop down list to show Income and Expense classes - Bernard Obeng Boateng

Create a dynamic drop down list to show Income and Expense classes - Bernard Obeng Boateng

2-way lookup using XLOOKUP and INDEX and MATCH

2-way lookup using XLOOKUP and INDEX and MATCH

My Dancing Christmas Tree in Excel present for you - Bernard Obeng Boateng

My Dancing Christmas Tree in Excel present for you - Bernard Obeng Boateng

How to set up a basic Income and Expense Template with Excel - Bernard Obeng Boateng

How to set up a basic Income and Expense Template with Excel - Bernard Obeng Boateng

Webinar: Using Data Analytics for Better Business Operations - Bernard Obeng Boateng

Webinar: Using Data Analytics for Better Business Operations - Bernard Obeng Boateng

Create a full PowerPoint presentation in seconds using a Word document - Bernard Obeng Boateng

Create a full PowerPoint presentation in seconds using a Word document - Bernard Obeng Boateng

Get and analyze Google Form responses in Excel

Get and analyze Google Form responses in Excel

Visualize data with Power Pivot's KPI feature

Visualize data with Power Pivot's KPI feature

Extract a Trial Balance from a simple Double Entry sheet using Power Query - Bernard Obeng Boateng

Extract a Trial Balance from a simple Double Entry sheet using Power Query - Bernard Obeng Boateng

Group dates in pivot tables using different timelines

Group dates in pivot tables using different timelines

Create a dynamic loan repayment schedule using SEQUENCE

Create a dynamic loan repayment schedule using SEQUENCE

Use Custom Data Types in Excel to simplify your formulas

Use Custom Data Types in Excel to simplify your formulas

Create a dynamic report with Excel's new functions (UNIQUE, FILTER, TRANSPOSE) - Bernard Boateng

Create a dynamic report with Excel's new functions (UNIQUE, FILTER, TRANSPOSE) - Bernard Boateng

Analytics with Excel: 1. Introduction to Tables and Structured Referencing

Analytics with Excel: 1. Introduction to Tables and Structured Referencing

Calculate Value Added Tax (VAT) using the LAMBDA function in Microsoft Excel - Bernard Obeng Boateng

Calculate Value Added Tax (VAT) using the LAMBDA function in Microsoft Excel - Bernard Obeng Boateng

Create Custom Views for your Workbook

Create Custom Views for your Workbook

Merge and extract common rows in two tables

Merge and extract common rows in two tables

Unpivot data using Power Query

Unpivot data using Power Query

Sort columns in your data in a particular order

Sort columns in your data in a particular order

Filter your Data with a Single Formula

Filter your Data with a Single Formula

Declutter your Pie Chart using this option

Declutter your Pie Chart using this option

Sum Values by Month with Formulas and Pivot Tables

Sum Values by Month with Formulas and Pivot Tables

Import and Clean pdf Bank Statement in Excel

Import and Clean pdf Bank Statement in Excel

Simulate Calculations using Goal Seek and Data Tables

Simulate Calculations using Goal Seek and Data Tables

3 Formula Options Using an Approximate Match Lookup

3 Formula Options Using an Approximate Match Lookup

Tips and Tricks to Format Numbers in Excel

Tips and Tricks to Format Numbers in Excel

Fuzzy Lookup for "not exactly matching" names

Fuzzy Lookup for "not exactly matching" names

3 Alternatives to VLOOKUP in Microsoft Excel

3 Alternatives to VLOOKUP in Microsoft Excel

Create an Annual Budget in 5 Minutes (Solution)

Create an Annual Budget in 5 Minutes (Solution)

Speed up Calculations with Mixed and Relative Referencing

Speed up Calculations with Mixed and Relative Referencing

Excel for Work, Analytics with Power BI and Financial Modeli

Excel for Work, Analytics with Power BI and Financial Modeli

Excel Tables and 5 Reasons you should use them.

Excel Tables and 5 Reasons you should use them.

Create a Budget v Actual Chart

Create a Budget v Actual Chart

Financial Modeling Webinar with members of the Institute of Chartered Accountants ICA (Ghana)

Financial Modeling Webinar with members of the Institute of Chartered Accountants ICA (Ghana)

Create a Cash Flow Report "without formulas"

Create a Cash Flow Report "without formulas"

Assign Ranks or Positions to Scores or Values with different criteria.

Assign Ranks or Positions to Scores or Values with different criteria.

Highlight the Maximum Value in a Dynamic Chart

Highlight the Maximum Value in a Dynamic Chart

Limit Entry of Prior Dates using Data Validation

Limit Entry of Prior Dates using Data Validation

Create a Speedometer Gauge Chart

Create a Speedometer Gauge Chart

Send Bulk Emails using Excel and Outlook

Send Bulk Emails using Excel and Outlook

Lookup more than one result and on many criteria

Lookup more than one result and on many criteria

Create an in-cell chart that fills up to 100% in #Excel

Create an in-cell chart that fills up to 100% in #Excel

Create and display pop-up pictures in cells

Create and display pop-up pictures in cells

Mail Merge with two versions of your document on one page

Mail Merge with two versions of your document on one page

Build interactive charts with Form Controls

Build interactive charts with Form Controls

Split Data into separate cells

Split Data into separate cells

Insert a portrait and landscape view in the same Word docume

Insert a portrait and landscape view in the same Word docume