Best Excel Tips & Tricks To Get More Done!

How To Summarize Data in Excel: Top 10 Ways

You’ve got some data in Excel, and you want to quickly summarize it. There’s not much time, and your client or boss needs information right away. Apply any of these Top 10 Techniques to Summarize Data Quickly with in-built Excel Functions and Features. You’ll get instant results to satisfy most

Read More »

Top 5 Careers Requiring Data Analysis Skills (2021)

Looking for a Lucrative Career that requires Data Analysis skills? Look no more. Here are the Top 5 Career Choices that can help you stand apart and move ahead, all with the help of Data Analysis Skills. What Is Data Analysis? Data Analysis comprises of the tools, techniques, tips &

Read More »

How To Learn Advanced Excel Fast

Advanced Excel skills are required in most managerial & analyst roles. Yet most people have no clue of how to learn Advanced Excel fast. They don’t know the key features of Microsoft Excel that can help them save time and money. It’s about time you pick the Most Important &

Read More »

Protect Cells from Any Unauthorized Changes in Excel

Protecting your Excel Files from any unauthorized changes is crucial. When you email or share your Excel files with others, there are always chances that they may change some key information, that shouldn’t have been changed. This can happen because, by default, all cells in Excel are available for modifications

Read More »

Power BI Creates Left Joins By Default

Microsoft Power BI is a great tool to visualize data quickly and create management dashboards. We can load data from almost any data source, and create relationships between different tables, just like in a traditional RDBMS (Relational Database). Join appear as Equal Joins in Power BI. This means that when

Read More »

Viewing the Formula in Another Cell in Excel

Applicable For: This tip works in Microsoft Excel 2013 & Excel 2016, and Office Excel 365 (for both Windows & Mac Editions) Prior to the Excel 2013 edition, to view all the formulas in a given worksheet in Excel, we had to use the View Formulas button, or use the

Read More »

6 New Chart Types in Excel 2016

Before the year 2016 begins, Microsoft has already unveiled Microsoft Office 2016 suite – with a number of enhancements, features, and completely new things that extend the existing Excel and takes it to new levels. In the latest and greatest Microsoft Excel 2016, we see 6 new types of charts,

Read More »

7 Habits of Highly Effective Data Analysts

We all are sitting on mountains of data, and new data arrives each day in the form of Reports, CSV files, Charts from Marketing, Logistics, Sales, Websites, Google Analytics… Before you can make any sense of it, even more data will arrive. Today we have much greater processing power in

Read More »

How To Make a Dropdown List in Microsoft Excel

You have seen online application forms where the Country Names are selected from a drop-down box. Or to select the Name of an Employee, or Cost Center Codes, or Departments etc.? This kind of list serves 2 purposes: 1. It makes it easy for the user to select a value,

Read More »

Showing The Hidden First Column in Excel

It is quite easy to show or hide columns in Excel. Simply select a column, and press Control + 0 . The column is hidden from the view. You can make it out because of a dark line separating the columns. If you hide the B column, you will only

Read More »
Show Buttons
Hide Buttons