Excel

Useful Macro Codes

Do you know with the help of these useful macros, you can break all the limitations of excel which you think excel has? You can use these macro codes even if you haven’t used VBA before that. All you have to do just paste these useful macros codes in your VBA editor. These codes will exactly do the same thing which headings are telling you. For your convenience, please follow these steps to add these codes to your workbook. First

Read more
Excel MS Office

Super Lite Excel Gantt Chart Template For Project Managers

Are you an emerging project manager? If Yes, then here I have a simple but powerful Excel Gantt Chart Template for you. This excel Gantt Chart template is Super Lite. You have to input minimum details about your project for tracking. Please follow this post to learn about the working of this excel Gantt chart template. Or. Download this Quick PDF Guide to learn about this Gantt chart template.   Features Track any project upto 30 days (Expandable). Track up

Read more
Excel MS Office

Conditional Formatting in Pivot Table

You know that Pivot Table is one the most important tools to analyze data. And, Conditional Formatting is useful to deliver a strong message to the user along with data. In this post, you will learn about how you can combine these two awesome tools. You will learn to apply conditional formatting in pivot table. Below, I have used conditional formatting in pivot table to present a dynamic formatting. It will highlight city which has highest amount & a city which has lowest amount every time I

Read more
Excel MS Office

Excel Pivot Chart

Do you remember when last time you created an Excel Pivot Chart? And, do you know Excel Pivot Chart is the easiest way to create dynamic charts in excel? The bad news is, most of the Excel users avoid using Excel pivot chart in their work. But the good news is, creating an Excel Pivot Chart is simple, just like a creating a pivot table. In this tutorial, you will learn how to use an Excel Pivot Chart and how you can make

Read more
Excel MS Office Tips and Tricks

5 Effective Ways to Quickly Repair a Corrupt Excel File

Excel is extensively used by both business organizations and individuals for maintaining records or tasks. The most petrifying situation is when the file is corrupt, and the data becomes inaccessible. In this blog, we will be discussing the causes of corruption and five ways to repair a corrupt Excel File. Even a minor error can completely corrupt the file. Some of the common causes of Excel file corruption are: Improper shutdown of the system – One of the primary causes

Read more
Education Excel MS Office

Learn Excel Basics – An Introduction To Microsoft Excel For Beginners

Now in these days, every company & business firm is trying to work smarter. Microsoft Excel is one of the most useful tools to work smarter. These days every company & employees as well are dependent on Microsoft Excel. From Accountant to Receptionist, Human Resource to Administration department all are using Microsoft Excel for their daily work. They are managing their lists, timetables, Ledger Accounts, Tax Calculation in excel. Excel is not limited to only large companies, even small entrepreneurs,

Read more
Excel MS Office

Excel 3D Reference

Using Excel 3D Reference can save your lot of time & help you to avoid lengthy formulas. Excel 3D Reference is like three-dimensional chart or image which has more than one phase. If we talk about the normal range it is all about the group of cells from a single worksheet. For Example =Sum(Sheet1!C5:D6).  Here, “C5:D6” is a group of cells to which is referred from Sheet1. But the 3D reference is a range of cells in which you can reference to the

Read more
Excel

20 Tricks That Can Make Anyone An Excel Expert

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Excel 2010. 1. One Click to

Read more