Tag

Excel Formula

Working with Excel Sumif Formula

Excel Sumif Formula When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif. You know what MY answer is – Excel SUMIFS()! And I will tell you...
Read More

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? Here’s a list of top 9 mistakes that one makes while entering an Excel formula + tips on how to avoid them: 1. Excel Error –...
Read More

Advanced Excel Formula Auditing

Microsoft Excel has a lot of features. It has a variety of powerful tools that allow checking what is happening in your spreadsheet. Today we will discuss on Advanced Excel formula. It helps you to get the relations between formula and your cells. Which cells are using the information in the cell and from which...
Read More
Things you need to know about Excel VBA Macros
January 5, 2018
How to make Data Table in Excel: One-variable data table and Two-variable data table
January 3, 2018
How to Create a Line Chart in Excel?
December 26, 2017
Tricks to Enable / Disable Scroll Lock in Excel
December 26, 2017
How to use sparklines in Excel: Creating a Miniature Chart in a Cell
December 18, 2017
How to create a Pivot Table in Excel
December 18, 2017
Tricks to create Hyperlink in Excel
December 6, 2017
How to Calculate Profit margin in Excel
December 6, 2017
How to Calculate a Percentage Increase in Excel
November 30, 2017
How to add Error Bars in Excel: Standard Deviation
November 30, 2017
How to convert invalid date formats into valid data formats?
November 29, 2017
Converting trailing minus sign into negative numbers. (Text to Column)
November 29, 2017
Text to Columns in Excel | Transfer Single Columnar Data into Multiple Columns.
November 29, 2017
4Excelshorcuts-workingwithformulas
Working with Excel Formula Shortcuts | Excel tips & tricks
September 27, 2017
Top 10 keyboard shortcuts that will help you master Microsoft Excel
September 26, 2017
freeze-panes-excel
Freeze row and column in Excel “How to”
August 26, 2017
How to Copy Text from Image
Copy Text from Image Using Microsoft OneNote
August 17, 2017
Excel VBA Tutorial | What is VBA Macros in Microsoft Excel ?
July 26, 2017
online-courses
Improve Office Productivity with Online Courses
July 26, 2017
Add APA Page number in MS Word with 3 Easy Steps
July 26, 2017