Explore Excel Deeply
Today’s post will be concerned with comments. We will be seeing how and when to use them. So let’s get started. Firstly, you normally insert a comment to a certain cell when you wish...
In this tutorial, we will be discussing how you can view worksheets of an Excel workbook in multiple ways. For example, look at this workbook. It has three worksheets. The first worksheet is Accounts...
Hi folks, we hope you are learning a great deal from our series on workbook and worksheet management. If you missed out on any information visit our archives as we have already discussed viewing...
With this post, we shall be starting our Excel Table series. Today’s post, in particular, will give you an overview of the topic at hand and walk you through the basics. Do let us...
When we create a table, Excel applies the default table style. Say I want to make the following range into a table. I just select any cell within the range. Press CTRL and T...
Advanced Excel / Formulas / Functions
by Taryn N · Published May 11, 2017 · Last modified June 8, 2017
There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF Function, the COUNTIFS Function and the COUNTBLANK Function. The COUNT...
Introduction You can give your worksheets form-like functionality without ever having to use VBA. In order to achieve this, you will have to use form controls. Form controls are accessed from the Developer Tab...
Advanced Excel / Formulas / Functions
by Taryn N · Published April 30, 2017 · Last modified May 17, 2017
An asset is defined as a resource with an inherent economic value that is owned by an individual, corporation or country which will yield future economic benefit. Accountants list assets on balance sheets, in...
Advanced Excel / Power Query / Power View / PowerPivot
by Kawser · Published April 29, 2017 · Last modified July 13, 2017
Have you ever heard or seen the terms big data, business intelligence and Power BI being mentioned in analyst’s reports and financial newspapers? These days these terms are popping up frequently in diverse sectors...
Advanced Excel / Data Analysis / Financial Modeling / Macros & Excel VBA
by Kawser · Published April 26, 2017 · Last modified July 19, 2017
Where do financial modelers work? The world of finance can be a very complex place that at times is quite tricky to navigate. One has, for example, millions of financial transactions being processed a day....
Advanced Excel / Macros & Excel VBA
by Kawser · Published April 25, 2017 · Last modified July 13, 2017
Do you often find yourself, doing repetitive tasks over and over again in Excel and wishing that somehow, someway these tasks could be automated? Well, the good news is that these tasks can be...
Advanced Excel / Dashboard / Data Analysis / Data Visualization / Formulas
by Kawser · Published April 25, 2017 · Last modified July 13, 2017
So, you know your SUM formula, you also know how to use the COUNTIF function. In addition, you are the go-to person at your office, when basic or intermediate level Excel help is needed....
Advanced Excel / Data Analysis / Data Visualization / Excel with Business
by Kawser · Published April 23, 2017 · Last modified July 24, 2017
[Note: My this blog post contains the best 40 Excel books for data analysis and business modeling. I’ve also listed here the best books for financial & scientific data analysis, data visualization, SQL and...
Advanced Excel / Basic / Macros & Excel VBA
by Kawser · Published April 22, 2017 · Last modified July 23, 2017
So, you’re a beginner or intermediate user of Excel and searching for the best Excel books that will take you to somewhere from nowhere. You’re at the right place. Truly speaking, I was at...
There are different types of interest rates and it is prudent for every investor or potential investor to know the differences between interest rates. The nominal interest rate is the simplest of the interest...
![Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!](https://www.exceldemy.com/wp-content/uploads/2017/06/Creating-and-Editing-Excel-Comments-to-Cells-–-An-Ultimate-Guide-520x245.png)
