Microsoft Excel
How to Use Excel Options using Microsoft Excel 2013
Excel Options are an important aspect of Microsoft Excel by allowing you to set up your preferred options. If you need to make Excel 2013 suitable for your work, you can do that by setting this up. So first off, let’s look at how we access the Excel Options. Excel Options is on the left…
How To Use Fill Function in Microsoft Excel 2013
Knowing the Fill function in Excel 2013 is helpful when it comes to knowing how to categorize different types of data. Generally, using the Fill function is based on Excel’s ability to fill in similar values in other cells. To make this clear, let’s take a look at some practical examples. 1. You need to…
How To Use The Quick Access Toolbar in Excel 2013
The Quick Access Toolbar in Excel 2013 is a toolbar containing a number of commands which are very helpful in your work in Excel 2013. You can see the Quick Access Toolbar when you look at the top left corner of the Excel 2013 window. A number of really useful hot keys can be customized…
How To Use The Ribbon in Excel 2013
If you are unfamiliar with the Ribbon in Excel 2013, let’s fill this gap. The Ribbon Interface is highly customizable and helps with repetitive work or if you need to focus on just a few commands in Excel. Here is an overview. How To Use The Ribbon in Excel 2013 The Ribbon is made up…
What’s New in Microsoft Excel 2013?
If you haven’t used Excel 2013 before, let’s take a quick look at the new features and improvements. Some of them are small and may rarely be used. Others, though, are very advanced and require expert knowledge. Knowing the main features will help you understand better how to work in this new software. FacebookLinkedinTwitte What’s…
The Basics of Formulas and Functions in Excel 2010
Formulas are primarily mathematical equations that can perform calculations. In Excel, a formula always begins with an equal sign (=). Excel calculates each formula from left to right, according to a specific order for each operator in the formula. For multiple operators, Excel evaluates several operators in a defined order when you combine them in a single formula….
Formatting Date and Time in Excel 2010
Dates can be entered in almost any format in Excel 2010. You can type them in the various formats, e.g. 7/20, 20-July, July 20, 7/20/10, 20-July 2010, but by default they will be displayed as 20-July, 7/20/2010 or 20-Jul-10 once you hit the Enter key. In the case wherein the year is not specified, e.g. 7/20,…
Finding Formula Errors in Excel 2010
Synopsis: In this article we look at how to locate formula errors in an Excel 2010 workbook. We also show you how to setup Excel to warn you about errors in formulas. Fac LinkedinTwitter Excel 2010 may detect an error in one of the formulas you are using in a workbook. When it does, it…
Exporting to Microsoft Excel in Project 2010
Synopsis: Sometimes you need to process project information in a way that Project 2010 itself does not support. In this article, we look at the facilities in exporting project data to Microsoft Excel. Project 2010 includes flexible facilities for both the import and export of data. Wizard features are provided to assist with both of…
Creating PDF and XPS documents in Excel 2010
Synopsis: In this article we look at how to convert a workbook to PDF or XPS format. These formats are readable by people who do not have Excel 2010 installed. Excel 2010 is a very popular spreadsheet program, but not everybody has it installed. To share a workbook with people who do not have Excel…
Creating and Formatting Sparklines in Excel 2010
Synopsis: Sparklines were introduced in Excel 2010. In this article, we look at how to create and format these tiny charts. Until now Excel charts have been graphic objects that are generally positioned and sized independently of worksheet cells. In Excel 2010 Microsoft introduced the Sparkline, a new type of chart that actually lives in…
Creating a Chart with Excel 2010
Synopsis: In this article we look at how to create charts in Excel 2010. The ability to create informative and good looking charts is one of the great strengths of Excel 2010. Recent versions of MS Excel have not only made this process easier, but have added powerful additional design and formatting features. A chart…
