Skip to main content

Posts

New Article

How to SUM by matching partial text in Excel

How to change the direction of Doughnut Chart in Microsoft Excel 2019

Watch this video to learn how to change direction of Doughnut Chart in Microsoft Excel 2019. Download and use this chart for FREE. |||| Please SUBSCRIBE our YouTube Channel for more videos |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

How to create a Doughnut Chart in Excel for Sales Team Performance

|||| Please SUBSCRIBE our YouTube Channel for more videos |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

How to Create a Doughnut Chart to show 3 Different info in Excel

|||| Please SUBSCRIBE our YouTube Channel |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

How to Resize the Formula Bar in Excel

In Excel, when you are working with a large formula then you need to expand or increase the height of Formula Bar to examine the formula. It is very difficult to examine the 2 or more lines formula in Formula Bar without increasing the height of the Formula Bar. In this tutorial I will show you how can you increase the height of your Formula Bar in Excel in 3 different ways .   Method 1: Mouse Drag - Place your Mouse Pointer in between Formula Bar and Column Header . - This will change your Mouse Pointer to Up-Down Arrow . - Click and Hold your Left Mouse Key and then Drag it down. By this way you can also collapse or decrease the height of your Formula Bar. Method 2: Mouse Click - Place your Mouse Pointer on Formula Bar Down Arrow icon. - Click to increase the height of Formula Bar . By this way you can also collapse or decrease the height of your Formula Bar. Note: If not fully increased, then apply Mouse Drag after Clicking the For...

How to Create A Checklist in MS Excel

This is 2019. You can use Mobile App in your Smart Phone to maintain a To Do List or Check List . But think you are in Office and you need to create a dynamic report in Microsoft Excel where a Check Box option should present. Or suppose you need to create a custom Check List before going to Office. You don't need to waste your time further if you found my article here. Image 1: Checklist in Excel What is a Check List? Check List is a good way to check your step by step process properly to complete the task. It is the best way of every single task to track or monitor that you are going to finish your task successfully. How to show or activate the Developer Tab? First of all you need to show or activate the Developer Tab in your Excel . To activate or show the Developer Tab , you need to follow below steps: Step 1: Click on Customize Quick Access Toolbar drop down icon and Select More Commands.. . Image 2: Customize Quick Access Toolbar drop down list ...

Happy New Year 2019

Happy New Year to all of Microsoft Excel Users. Wish your task in Excel becomes more easy this year. |||| Please SUBSCRIBE our YouTube Channel |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

How to use AutoSum in Excel

What is AutoSUM in Excel? AutoSum is a feature found in Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019. It helps user to calculate the SUM of multiple cells, multiple rows or multiple columns. It stays as AutoSum button (Drop Down List) under Editing group of Home tab. Image 1: AutoSum button in Microsoft Excel This feature made the SUM calculation quick and easy. Most of the beginner users use this AutoSum calculation feature in Excel for quick and easy way to calculate the SUM . The below example is for those users who wish to use AutoSum in Excel 2007, AutoSum in Excel 2010, AutoSum in Excel 2013, AutoSum in Excel 2016, AutoSum in 2016. This is also known as Quick Sum in Excel. You can apply the AutoSum feature for the following calculation: 1. AutoSum for Multiple Rows (with no blank cells) 2. AutoSum for Multiple Rows (with blank cells) 3. AutoSum for Multiple Columns (with no blank cells) 4. AutoSum for Multiple Columns (with blank ce...