How to Use Highest & Lowest Functions in Excel 2013

How to Use Highest & Lowest Functions in Excel 2013 Although it is quite easy to locate highest or lowest numbers in small spreadsheets, it becomes useful to learn how to use highest & lowest functions in Excel 2013 if you are dealing with spreadsheets containing a large amount of data. Luckily, Excel 2013 is […]

Read More

How to Insert a Screenshot in Excel 2013

How to Insert a Screenshot in Excel 2013 If you are an avid user of Excel 2013, you have probably run into situations where you need to insert screenshots into your workbook. Unfortunately, most people don’t know that Excel 2013 comes with a purpose-built feature that makes it much easier to add screenshots to your […]

Read More

How to Add Trendlines to a Chart in Excel 2013

How to Add Trendlines to a Chart in Excel 2013 Trendlines are a great way to analyze data contained in a chart. If you learn how to add trendlines to a chart in Excel 2013, you will not have to worry about having to read complicated charts or extensive raw data. You can get a […]

Read More

How to Sort Data in Excel 2013

How to sort data in Excel 2013. Organizing data in a spreadsheet must have been a nightmare before Excel came up with the feature that enables users to sort out their data according to their needs. Knowing how to sort data in Excel 2013 is invaluable if you want to arrange your data in the […]

Read More

How to create Sparklines in Excel 2013

How to create Sparklines in Excel 2013. Sparklines are perhaps the most efficient and convenient way to analyze data in a spreadsheet. Yet, many people are unfamiliar with how to create Sparklines in Excel 2013. Sparklines are tiny charts that summarize data pictorially in a single cell. Rather than have bulky charts fill up your […]

Read More

How to Create a Chart in Excel 2013

How to Create a Chart in Excel 2013. Charts are a great way to sort out data that you have stored in an Excel 2013 workbook. They help you visualize your data and make it easier for you to analyze any trends that may exist. Excel 2013 allows you to modify and format your chart […]

Read More

Creating Simple Formulas in Excel 2013

Creating Simple Formulas in Excel 2013. One of the main reasons why businesses use Excel for their bookkeeping is the fact that it has the ability to make numerical calculations based on custom-made formulas. You can use the cell references to create mathematical formulas so that Excel 2013 will make updated calculations every time you […]

Read More

Logical Functions in Excel 2010

Logical Functions in Excel 2010 Logical functions are used for decision making in spread sheet. There are seven logical functions in Excel 2010 which return whether the logical true or logical false. Finding the right LOGICAL function in excel 2010. Follow the below steps to identify the Logical function in excel 2010. Step 1: Open […]

Read More

How to Edit and Delete Macros in Excel 2010

How to Edit and Delete Macros in Excel 2010? Macro in Excel 2010 is written in Visual Basic for Applications programming language. We can edit macros in VBA editor. Follow below steps one by one to edit Macro. Step 1: Click on MACROS option under DEVELOPER ribbon which opens MACROS dialogue box Step 2: Click […]

Read More

How to record a Macro in Excel 2010

How to record a Macro in Excel 2010? Macro in Excel 2010 allows you perform multiple operations. It helps to work in a smart and efficient way. By this tool we can reduce manual work and get the things done very fast. In Excel 2010 we can both record and write our own macros. All […]

Read More