Skip to content

MS Excel Tips

Create a PivotTable in Excel 2016 and Easily Analyze Large Data in your Worksheet

Read: 20,223 One of the many great things about Microsoft Excel is that it allows you to manipulate large amount of data to make better, calculated business decisions. In the previous posts, we saw how we can create how we can use Data Tables, create Outlines, use Formulas, etc. in Excel. In this post, let us look at PivotTables. A… Read More »Create a PivotTable in Excel 2016 and Easily Analyze Large Data in your Worksheet

Easily Calculate the Results of One or Two Changing Variables in Excel Using Data Tables

data table in excel

Read: 28,238 Data tables are used to see how changing one or two variable data in a formula affects the result in a Microsoft Excel Worksheet. It creates a range of cells in a table form that shows the results when the variable data is applied in the calculation. Data table allows you to easily calculate multiple results in a… Read More »Easily Calculate the Results of One or Two Changing Variables in Excel Using Data Tables

Creating Outlines in Microsoft Excel and Grouping Data for Easy Analysis

creating outline in microsoft excel

Read: 8,225 Sometimes you may have to work with very large list of data in Excel Spreadsheets. Browsing through the entire list to look for important data can be tedious. One way to deal with this kind of situation is by grouping and summarizing the entire data. Outline feature in Excel helps you to group data, making it easier to… Read More »Creating Outlines in Microsoft Excel and Grouping Data for Easy Analysis

How to Use Names in Excel Formula and Make it Easier to Understand

using names in ms excel

Read: 13,993 Usually we use cell numbers in formulas whenever we work on an Excel spreadsheet. Remembering each cell number and what it contains can be really hard. However, there is an easy way – you can use names in formulas instead of cell numbers. For example: imagine that cell C10 contains Price and cell D10 contains Quantity and you… Read More »How to Use Names in Excel Formula and Make it Easier to Understand

How to Create Scenarios in MS Excel to Make Predictions and Forecasts

creating scenario in ms excel

Read: 11,529 There may be times when we need to experiment with several different values in an Excel Spreadsheet to make predictions and forecasts. For example, you are selling various products. Assume that you have a profit target to meet and you want to see how much profit you will make if you sell x number of each product. You… Read More »How to Create Scenarios in MS Excel to Make Predictions and Forecasts

How to Switch Data From Columns to Rows or Rows to Column in Excel Quickly by Using Transpose Data

transposing data in ms excel

Read: 7,875 In my previous post, we looked at how to create conditional formatting in order to highlight or make some cells standout from other cells based on it’s values. Today, I am going to show you how to re-arrange data in Excel from columns to rows and rows to columns easily by using transpose data feature. What Does Transposing… Read More »How to Switch Data From Columns to Rows or Rows to Column in Excel Quickly by Using Transpose Data

Conditional Formatting in Excel 2010: Analyze and understand the Data at a Glance

Read: 8,125 Microsoft Excel is one of the very advanced spreadsheet applications that lets you easily create and manage complex spreadsheets. Imagine having a spreadsheet with large amount of data. Making some sense out of this data is a big task by itself. Scanning through rows and columns to read and interpret the data can be really difficult. For example,… Read More »Conditional Formatting in Excel 2010: Analyze and understand the Data at a Glance

Solution For Embedded Excel Workbook in Word Document won’t Open – “Excel is not installed” Error

google chrome add ons

Read: 22,649 This solution is for the following errors when you try to edit an embedded Microsoft Excel file in the Word Document. I’ve experienced this problem on Office 2007 and Office 2010. For e.g. If you have an embedded Excel sheet inside a Word Document like shown below, and want to edit. When you double click on it, you… Read More »Solution For Embedded Excel Workbook in Word Document won’t Open – “Excel is not installed” Error