OUR LATEST BLOG POSTS

Learn all about the new XLOOKUP Function in Excel!
Learn all about the new XLOOKUP Function in Excel!
Abdelrahman Abdou Comments are off
Keep Reading
Abdelrahman Abdou Comments are off
Keep Reading
FOR EACH Loop in Excel VBA
FOR EACH Loop in Excel VBA
Abdelrahman Abdou Comments are off
Keep Reading
SUMPRODUCT function | Multiple uses [Video]
SUMPRODUCT function | Multiple uses [Video]
Abdelrahman Abdou Comments are off
Keep Reading
Map Chart/Dashboard using Excel
Map Chart/Dashboard using Excel
Abdelrahman Abdou Comments are off
Keep Reading
Power Query Tutorial | Get list of File Names from a folder
Power Query Tutorial | Get list of File Names from a folder
Abdelrahman Abdou Comments are off
Keep Reading
Slicers | Using Slicers to create an Interactive Report
Slicers | Using Slicers to create an Interactive Report
Abdelrahman Abdou Comments are off
Keep Reading
SUM and Count Between Times in Excel
SUM and Count Between Times in Excel
Abdelrahman Abdou Comments are off
Keep Reading
Sum Between Dates using SUMIFS
Sum Between Dates using SUMIFS
Abdelrahman Abdou Comments are off
Keep Reading
SUMIF COUNTIF SUMIFS COUNTIFS | Summing and Counting with Criteria
SUMIF COUNTIF SUMIFS COUNTIFS | Summing and Counting with Criteria
Abdelrahman Abdou Comments are off
Keep Reading
INDIRECT Function – Just give it an address [Video]
INDIRECT Function - Just give it an address [Video]
Abdelrahman Abdou Comments are off
Keep Reading
Hours worked and Overtime hours in Excel [Video]
Hours worked and Overtime hours in Excel [Video]
Abdelrahman Abdou Comments are off
Keep Reading
Calculate Quarters , Fiscal Quarters in Excel [Video]
Calculate Quarters , Fiscal Quarters in Excel [Video]
Abdelrahman Abdou Comments are off
Keep Reading
OFFSET function and Dynamic Ranges [Video]
OFFSET function and Dynamic Ranges [Video]
Abdelrahman Abdou Comments are off
Keep Reading
How to use the INDEX MATCH combo for Lookups – Basics of INDEX and MATCH
How to use the INDEX MATCH combo for Lookups - Basics of INDEX and MATCH
Abdelrahman Abdou Comments are off
Keep Reading
Lookups with Multiple Criteria
Lookups with Multiple Criteria
Abdelrahman Abdou Comments are off
Keep Reading
MINIF and MAXIF in Excel – 3 ways to do it [with Video]
MINIF and MAXIF in Excel - 3 ways to do it [with Video]
Abdelrahman Abdou Comments are off
Keep Reading
Lock and Unlock specific cells in Excel
Lock and Unlock specific cells in Excel
Abdelrahman Abdou Comments are off
Locking and unlocking cells in Excel is an important skill to learn, especially if you’re sharing files with other people, as it is important to
Keep Reading
EDATE Function for adding and subtracting months!
EDATE Function for adding and subtracting months!
Abdelrahman Abdou Comments are off
EDATE Function: The easiest way to add or subtract months to your dates! We deal with a lot of Date variables in Excel and to
Keep Reading
Excel Pivot Tables Error Handling
Excel Pivot Tables Error Handling
Abdelrahman Abdou Comments are off
Like summarization formulas in Excel, the Pivot Tables also throw errors like #DIV/0! and #NULL. It’s very annoying when this happens. You can refer to
Keep Reading
Handling errors in Excel using IFERROR
Handling errors in Excel using IFERROR
Abdelrahman Abdou Comments are off
Various functions in Excel result in an error in certain situations. It’s annoying to look at them when the errors are unavoidable. In this article,
Keep Reading
IF function + Logical Functions (AND and OR) in Excel
IF function + Logical Functions (AND and OR) in Excel
Abdelrahman Abdou 2 comments
Lots of people would have already used IF function in Excel and some would have used the Logical functions (AND, OR and NOT) of Excel.
Keep Reading
Rounding using CEILING and FLOOR Functions in Excel
Rounding using CEILING and FLOOR Functions in Excel
Abdelrahman Abdou Comments are off
Rounding numbers is a frequently occurring need. There are plenty of use cases where you would like to round off the given number to the nearest
Keep Reading
Weighted Average in Excel-How to calculate!
Weighted Average in Excel-How to calculate!
Abdelrahman Abdou Comments are off
Calculating weighted average is a more advanced way of averaging numbers where different weights are given to different numbers unlike equal/uniform weights given in the
Keep Reading
Hide formula results based on Date in Excel
Hide formula results based on Date in Excel
Abdelrahman Abdou Comments are off
Sometimes, you would like to compute certain information or show some results only for the dates till date. In other words, you would like to
Keep Reading
Keyboard Shortcuts for Every Excel user!
Keyboard Shortcuts for Every Excel user!
Abdelrahman Abdou 2 comments
All Excel users, whether beginners or advanced users, often have to modify rows and columns, no matter what they work on. Copying/Pasting, Inserting, Moving, Deleting
Keep Reading
Negative numbers in Red in Excel?
Negative numbers in Red in Excel?
Abdelrahman Abdou Comments are off
Want to learn how to Differentiate Negative Numbers in Excel? You’ve come to the right place! Whenever you deal with a large set of numbers,
Keep Reading
How to use a Wildcard in Microsoft Excel!
How to use a Wildcard in Microsoft Excel!
Abdelrahman Abdou 2 comments
In this article, you will learn how to use a wildcard in Excel! Sometimes you come across various situations where you have a huge set
Keep Reading
Using Goal Seek to find the input for a required output!
Using Goal Seek to find the input for a required output!
Abdelrahman Abdou Comments are off
There might be several instances where you might want to find out what is the value the input should take achieve the desired output. We’ll
Keep Reading
Calculating Nominal and Effective Interest Rates in Excel
Calculating Nominal and Effective Interest Rates in Excel
Abdelrahman Abdou 2 comments
Introduction The interest rate has many types in finance: real, nominal, effective, annual and so on. The difference between Nominal and Effective Rates (Two of the
Keep Reading
How to extract data from a website using Microsoft Excel
How to extract data from a website using Microsoft Excel
Abdelrahman Abdou Comments are off
There might be some cases where we might need to extract data from a website into Excel and update it automatically in the future. Excel
Keep Reading
How to calculate hours worked in a shift using Excel!
How to calculate hours worked in a shift using Excel!
Abdelrahman Abdou Comments are off
One of many features of Excel is that you can easily calculate the number of hours worked during a shift. Even though it is a really
Keep Reading
How to calculate Age in Excel | Excel Formula to Calculate Age
How to calculate Age in Excel | Excel Formula to Calculate Age
Abdelrahman Abdou Comments are off
In Excel, it is possible to calculate age from Birthday/Date of Birth. Just like we would figure out someone’s age by subtracting their birthdate to the
Keep Reading
How to use the ERR object in Excel VBA to differentiate errors
How to use the ERR object in Excel VBA to differentiate errors
Abdelrahman Abdou Comments are off
What is the ERR object in Excel VBA? The ERR object in Excel VBA is an object that contains information about different Run-time errors. 438
Keep Reading
How to calculate your loan Payment in a few easy steps: PMT function
How to calculate your loan Payment in a few easy steps: PMT function
Abdelrahman Abdou Comments are off
Introduction PMT is a financial function that calculates the periodic payment for a loan, mortgage or investment, with constant payments and interests rate and a
Keep Reading
Database functions: The key to manage large sets of data continued
Database functions: The key to manage large sets of data continued
Abdelrahman Abdou Comments are off
Database Functions Part 2: 12 formulas that cover all common calculation needs If you are still unsure about what Dfunctions are and how to use
Keep Reading
Database functions: The key to manage large sets of data
Database functions: The key to manage large sets of data
Abdelrahman Abdou Comments are off
Part 1: DFunctions in Excel, what they are and how to use them. The database functions perform a range of standard calculations to calculate statistics:
Keep Reading
INDEX and MATCH functions in Excel
INDEX and MATCH functions in Excel
Abdelrahman Abdou Comments are off
Most of the times the INDEX and the MATCH functions are used together or referred to together, this makes it difficult to understand their functionality
Keep Reading
VLOOKUP with Sorted List – AKA Approximate Match
VLOOKUP with Sorted List - AKA Approximate Match
Abdelrahman Abdou Comments are off
A lot of people know how to use the VLOOKUP function to do an exact match – That is to search for something specific and
Keep Reading

OUR SERVICES

Reports and Dashboards for decision making

Automations to save you loads of times

Did you know that Excel can help you run your business better?

Excel can help you automate tedious and repetitive processes that consume your time and make them get done just by a push of a button. It can also create Reports and Dashboards that are easily updated to give you insight on how your business is doing and support decision making!

Explore Our Services

Want to get better at Excel?

Join Our Excel Community

Join our Excel Newsletter to get free Excel tips and tricks delivered to your inbox!

SUBSCRIBE NOW

Location

Hey, My Name is Abdelrahman Abdou, and I live in the beautiful and vibrant city of Toronto.

If you are looking for an Excel and Power BI expert in the Toronto area, look no further! I’m located in Downtown Toronto where I do work for remotely for my clients located all over the world.

I can also perform on-site work for your company within the GTA.

Contact Information:

Abdelrahman Abdou
info@excelbonanza.com
437-776-7552

[]
1 Step 1

You can use the below contact form to send us a message, or you can send an email to info@excelbonanza.com

keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.