Excel Solutions - Basic and Advanced

Share in Facebook

Home
Basic
- Logical
  - IF
  - IFS
  - Operators in Excel
  - AND
  - OR
  - XOR
  - Quotient
  - SUM
  - SUMIF
  - SUMIFS
  - COUNTIF
  - COUNTIFS
  - Subtotal
  - Pivot Table
  - Conditional Formatting - New Rule
  - Conditional Formatting - Icon Sets
  - Iferror
- Lookup
- Text
- Date & Time
  - Now
  - Day Month Year
  - Date
  - Today
- Statistical
  - CountA
  - CountBLANK
  - Average
  - Averageif
  - Large
  - Small
Advanced
Recent
- Hlookup not working
- REPT Function
- Quotient
- OR
- XOR
- AND
- CountBLANK
- Textjoin
- Small
- CountA
- IFS Function
- Find and Replace
- Flash Fill
- Count Spaces in Text
- Iferror
- Errors In Excel
Why
- Logical
How
We
Search

15 April 2024

Variance Charts in Excel Sales vs Targets or Actual vs Budget

Excel Trainer at 19:47

No comments:

Post a Comment

Please share your thoughts and please share this blog to motivate us...
Thank you...

View web version

Popular Posts

Pivot Table From Single or Multiple Pivot Table

Pivot of a Pivot ? Is it possible in Microsoft Excel ? Yes, it's possible in Excel even you can create Pivot Table from multiple ...
6 Reasons why HLOOKUP not working - Solved

HLOOKUP not working !!! Don’t need to get panic. I know you have tried a lot but all in vain. Calm down, there are very few rea...
6 Reasons why VLOOKUP is not working

VLOOKUP is not working !!! Don’t need to get panic. I have seen many persons complaining VLOOKUP not working or VLOOKUP not wo...
Uses of CHAR Function & CHAR(10) NOT Working - Solved

In my last article, I have discussed about the CHAR function . This function returns the character from the ASCII code. We learned abo...
Fill Blank Cells With Value Above or Below the Cell or Zero

Hi Friends, I hope most of us has faced a typical problem in Microsoft Excel regarding filling the blank cells in any report. Although fi...
Conditional Formatting in Excel Formula, Icon Sets, Find Duplicate or Unique value and Edit or Modify or Remove Conditional Formatting

Hi friends, After discussing about basic Conditional formatting I think we should learn few more Conditional formatting features. Form...
Excel ROUND, ROUNDUP and ROUNDDOWN Function - Combination of VLOOKUP with ROUND in Microsoft Excel

Friends, While dealing with data analysis sometimes we need to take only the integer part i.e., without the fraction from data i.e., ro...
Filter Text Number Date and Filter by Color in Microsoft Excel AutoFilter Shortcuts Step by Step

Data collection, data organization and data analysis, the main purpose of these steps is to find the relevant information for an organiza...
How to Count the Number of Spaces or any Character in a text

Friends, In this article, we will learn how to count the spaces or any special character or alphabet in a text in any cell in Microsoft...
Flash Fill - Split Cells in Excel – Step by Step

Hello friends, Today I will discuss about Flash Fill in Excel, a wonderful tool introduced in Excel 2013 and 2016 to separate the d...

Blog Archive

▼ 2024 (3)
- ► May (2)
- ▼ April (1)
  - Variance Charts in Excel Sales vs Targets or Actua...

► 2022 (1)
- ► December (1)

► 2021 (2)
- ► July (1)
- ► June (1)

► 2020 (1)
- ► June (1)

► 2019 (13)
- ► November (1)
- ► July (1)
- ► June (1)
- ► April (2)
- ► March (2)
- ► February (2)
- ► January (4)

► 2018 (42)
- ► December (2)
- ► November (3)
- ► October (3)
- ► September (1)
- ► August (3)
- ► July (2)
- ► June (3)
- ► May (6)
- ► April (12)
- ► March (4)
- ► February (1)
- ► January (2)

► 2017 (41)
- ► December (1)
- ► November (3)
- ► October (1)
- ► September (5)
- ► August (6)
- ► July (11)
- ► June (11)
- ► May (3)

Powered by Blogger.