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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
The Window view in Excel 2010 helps to open, view and arrange workbook. Window is the option in View ribbon. In this tutorial I will show how to use window option in view ribbon to work with multiple sheets. How to create multiple sheets in same work book? Step 1: Open the work book Step 2: Click […]
Statistical Functions in Excel 2010 Excel provides a large selection of Statistical functions. This will help to perform common calculations to complex statistical distribution and probability tests. Finding the right statistical function in Excel 2010 Follow the below steps to identify the Statistical function in excel. Step 1: Click the Formulas tab in excel and […]
Excel Math functions, grouped into categories with simple examples.