Skip to main content

New Article

How to SUM by matching partial text in Excel

Post a Comment

Articles

Add-Ins:
  1. How to use Fuzzy Lookup or Fuzzy Match in Excel

Android Phone:
  1. How to install and run Excel in an Android Phone

Array Formula:
  1. What is Array Formula?
  2. MAX() array formula to find out the Maximum

Beginner:
  1. Combine tables by using Data Consolidate in Excel
  2. How to analyze data through Goal Seek in Excel
  3. How to use the powerful scenario feature in Excel
  4. Analyze data by using One Variable Data Table
  5. Analyze data by using Two Variable Data Table
  6. How to use AutoSum in Excel
  7. How to resize the Formula Bar in Excel

Case Studies:
  1. How to Print the Row and Column Title on each page
  2. Use Index-Match instead of VLookup() function
  3. Time Difference Calculation after midnight
  4. Find the result of a quiz contest
  5. How to handle error with SUMPRODUCT function
  6. Convert a Logical Text into Logical Value

Charts:
  1. How to create a Gantt Chart Step by Step in Excel
  2. How to create a Dougnut Chart?
  3. How to use Horizontal Scrollbar for large chart viewing in Excel
  4. How to create a Battery Chart in Excel
  5. How to create Hanging Frame Chart for Sales Forecasting in Excel 2016
  6. Waffle Chart for Zone wise Sales Achievement - Quick MIS Report
  7. How to create an Interactive Battery Chart in Excel 2016 
  8. Rating Bar Chart for Professional Modern Resume in Excel 2016
  9. How to create a Sales Forecasting Chart in Excel 2016 
  10. How to Create a Speedometer Chart or Gauge Chart in Excel 2019 
  11. How to change the direction of Doughnut Chart in Microsoft Excel 2019
  12. How to create a Doughnut Chart in Excel for Sales Team Performance 
  13. How to Create a Doughnut Chart to show 3 Different info in Excel 

Conditional Formatting:
  1. How to highlight whole row based on Active Cell without VBA?
  2. How to remove conditional formatting from worksheet?
  3. What is Conditional Formatting in Excel?

Dashboard:
  1. What is Dashboard in Excel

Data Analysis Expressions (DAX):
  1. What is DAX and how it works in Microsoft Excel

Developer:
  1. How to Create a Check List in Excel

Excel Online:
  1. How to run Excel Online from your web browser

Excel VBA:
  1. How to Delete Personal.xlsb file that contains personal macro
  2. An introduction of Microsoft Excel Visual Basic for Application (VBA)
  3. What is Macro and What is VBA
  4. How to add the Developer Tab in Excel VBA
  5. How to write your first simple Macro
  6. How to create a Sub Procedure in Excel VBA
  7. How to write Excel VBA Comments
  8. What are the types of Procedures in Excel VBA
  9. How to call a Procedure in Excel VBA
  10. Introduction to all options of Developer Tab in Excel
  11. How to add a button in Excel Spreadsheet in Excel VBA
  12. How to use OFFSET range in Excel VBA
  13. Understanding the Resize property
  14. Variables in Excel VBA
  15. Mathematical Calculations in Excel VBA
  16. Different types of Variable in Excel VBA
  17. If Statement example in Excel VBA
  18. Another example of IF Statement in Excel VBA
  19. Select Case statement in Excel VBA
  20. WITH statement in Excel VBA
  21. Some String functions in Excel VBA
  22. A String function in Excel VBA
  23. Loops in Excel VBA
  24. An introduction to Array in Excel VBA

Functions:
  1. Subtotal
  2. VLookup
  3. Rank
  4. Lookup
  5. HLookup
  6. Choose
  7. Cell
  8. Frequency
  9. PMT, PPMT and IPMT
  10. ISLOGICAL

Games in Microsoft Excel:
  1. Valentine's Day Love Calculator in Excel 2016
Job vs Excel:
  1. Want to survive in a company, then learn these survival techniques in Excel
  2. Some Formulas you must know before starting job
  3. 7 Essential excel tricks for every office workers

Pivot Chart:
  1. How to Create Pivot Chart
  2. How to Delete a Pivot Chart

Pivot Table:
  1. Hide Slicer items if there is no data
  2. How to Delete a Pivot Table
  3. How to add Slicer in Pivot Table
  4. Remove (blank) in row labels in Pivot Table
  5. How to Count the Frequency of unique values in Pivot Table
  6. How to calculate the Cumulative Closing Balance like a Bank Statement in PivotTable

Power BI:
  1. Introduction to Power BI Service

Power BI Desktop:
  1. How to Download, Install and Run the Power BI Desktop
  2. How to create and publish your first report in Power BI Desktop to Power BI Service

Power Pivot:
  1. Introduction to PowerPivot
  2. How to download, install and run PowerPivot
  3. Import data by using the import wizard in PowerPivot
  4. Import data by using the basic Copy-Paste in PowerPivot
  5. Import data through a Linked Table in PowerPivot
  6. Saving a file as PowerPivot supported file format
  7. How to create relations among 3 Tables in PowerPivot
  8. How to create a calculated field in PowerPivot
  9. How to create a hierarchy field to make report faster in PowerPivot
  10. Which version of Office 2016 do support PowerPivot

Print:
  1. How to Print background color or image of a print area in Microsoft Excel?

Quick Access Toolbar:
  1. Speak Cells
  2. Camera
  3. Value Paste and Formula Paste
  4. How to Export or Import your customized QAT or Ribbon in Excel 2013
  5. How to reset Quick Access Toolbar

Shortcut Keys:
  1. Shortcut Keys of Excel 2003
  2. Shortcut Keys with CTRL
  3. Most used Keyboard ShortCut Key in Microsoft Excel

Slicer:
  1. What is Slicer
  2. How to add Slicer in Table
  3. How to add Slicer in Pivot Table or Pivot Chart
  4. How to remove the Slicer
  5. How to format or design a Slicer
  6. Slicer settings in details

Templates:
  1. Age Calculator

Tricks:
  1. Get the unique values from a column by using advance filter in Excel
  2. Remove Table format from worksheet
  3. Index and Match formula with multi criteria to return a single value
  4. Find all external links in a workbook or worksheet
  5. How to display an image in worksheet based on a list or based on IF condition
  6. How to get the unique product names based on a criteria
  7. How to use SUMIFS function with greater than and less than conditiona
  8. How to use Excel in Microsoft Word or others MS Office application
  9. Cell text separated into Columns by using formula
  10. VLookup with auto increase Column number
  11. Show image as a result of Index-Match
  12. Convert Text to Number and Number to Text
  13. 3 ways: to find the last date of a month based on a given date
  14. Get Numerical result by matching 3 conditions through SUMIFS, LOOKUP, SUMPRODUCT and SUM
  15. Split a TEXT into Column after a specific character each time in Excel
  16. Text to Column: While + (Plus) symbol is the starting text of next column

Trouble Shooting:
  1. Unable to load msmdlocal.dll for PowerPivot add-ins
  2. Be-careful! Parts of your document may include personal information
  3. Insert and Delete options are not visible while right clicking in Excel
  4. How to know which version of Excel are you using
  5. After applying Freeze or Unfreeze Excel stopped working dialog box appeared!!!
  6. How to enable "Show page break" option in MS Excel
  7. ALT key not working for Keyboard Shortcut in Excel
  8. While I double click a excel file, it opens just Excel Program not the file I expected 

Popular posts from this blog

How to display an image in worksheet based on a List or based on IF condition?

Excel can show image on worksheet based on a specific IF condition. So, how to do it? Simple follow the below steps: Step by Step: Step 1: Insert images in your Excel Worksheet. Here I've inserted 5 different types of balls, Football, Cricket, Pool, Basketball, Tennis ball. Note that, All balls are placed into different cell. These are placed in Picture sheet. Image 1: 5 balls placed in 5 different cells and covered photo's wide and height Step 2: In the report sheet, design the report as you wish. I've designed in my way like below: Image 2: Kids asking to Donald Duck, which ball need to throw now Step 3: Make a drop down list "Games" in E6 cell in Report sheet from Data Validation. which is as below: Football Cricket Pool Basketball Tennis You can do an IF function here in E6 in Report sheet, which will meet a certain condition and returned Football, Cricket, Pool, Basketball or Tennis. Step 4: Now the tricky part is
Read more

Fiverr Microsoft Excel 2016 Skill Test and Answers 2021

This video will help you about preparing Fiverr Excel Skill Test. I've just taken this Fiverr Excel Skill Test and successfully passed with a scored 6 out of 10. I'm sharing my Fiverr Excel Skill Test and Answers 2021 video so that you can prepare yourself if you would like to give a test on Fiverr.    I have taken the Fiverr Excel Skill Test on Fiverr and obtained 6 out of 10 scores. If you take a test and pass, it will greatly help the buyer to trust you and your skills. Please note that your exam will not be exactly the same as mine because there are many more questions in the pool than 40 which appeared in my test. But I am hopeful that you will succeed in it. If you have any queries, please write them in the comment section. I will try my best to guide you.Follow this video and try to get a general idea. By following the instructions, you can successfully pass the test.    After passing the Fiverr Excel Skill Test, Fiverr shared a Excel Expert Badge on my Profile, so that
2 comments
Read more

Cumulative Closing Balance like a Bank Statement in PivotTable

A Bank Employee in many case needs to calculate the Closing Balance after each transaction in PivotTable like a Bank Statement . But with the help of Calculated Field of a PivotTable , you can only calculate Field with Field . It's not possible to use a formula in Calculated Field where you can mention a single cell with Relative Reference Cell . Because a PivotTable acts like a Table format where you can work with Field or Column Name . A Helping Column (A regular column, that helps to get a partial result where formula applied) can be a good idea. But there is an option in PivotTable by which you can Calculate Cumulative . In this article I will show you, how you can do it. Calculating with Formula: Assume that, you have an Excel file with Debit and Credit transaction of an Account . Image 1: Sample Bank Statement In a Bank Statement , Month wise Cumulative Balance is important. In the Excel sheet, as above, it is very easy to use a formula and calc
Read more