Microsoft Excel
How To Change Default Font
Most of the people who uses the excel hate the font which is preloaded by default i.e Calibri font, To change the default of the Microsoft Excel follow this tutorial.
Customizing MS-Office 2010 Quick Access Toolbars
The Quick Access Toolbar has been a part of MS Office since the 2003 version, but it has come to the forefront since the introduction of MS Office 2007 and more prominently with MS Office 2010. The Quick Access Toolbar is a customizable toolbar that houses the common commands – Save, Undo and Redo. Faithful to its name and function, the Quick Access Toolbar is there at the same spot irrespective of the Ribbon tab you are working on.
You can enhance your productivity with two quick and easy changes to the Quick Access Toolbar...
Excel median function
This tutorial show how, why and when you should use median function instead of arithmetic mean.
How Excel stores Dates and Times
When you look at a Date inside spreasheet you can see a day, a month and a year in one of many different formats. But Excel treats Dates and Times as numbers and fractions. These values are called serial values and decimal fractions and can be used in artihmetic calculations.
Excel 2010 Using What-If Analysis
The real power in Excel comes in its ability to perform multiple mathematical calculations for you. One of the tools in Excel that you can use to perform these calculations is a Data tool called What-If Analysis. What-If analysis allows you to see the effect that different values have in formulas. Have you ever thought, "What interest rate do I need to qualify for to have a car payment of $400 on the car I want?" This question can be answered using What-If Analysis.
In this lesson, you will learn how to use a What-If Analysis tool called Goal Seek.
Excel 2010 Creating PivotTables
PivotTable reports (or, simply PivotTables) make the data in your worksheets much more manageable by summarizing the data and allowing you to manipulate it in different ways. PivotTables can be an indispensable tool when used with large, complex spreadsheets, but they can be used with smaller spreadsheets as well.
In this lesson, you will learn the basics of creating and manipulating PivotTables.
Excel 2010 Using Conditional Formatting
Imagine you have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more cells based on the value of the cell. You can highlight interesting or unusual cell values, and visualize the data using formatting such as colors, icons, and data bars.
In this lesson, you will learn how to apply, modify, and remove conditional formatting rules.
Excel 2010 Working with Sparklines
Sparklines are miniature charts that fit into a single cell. Since they're so compact, you can place a large number of them in your worksheets. For example, you could place one sparkline on each row to show trends within that row. In this lesson, you will learn how to insert sparklines and change their type and appearance.
Excel 2010 Working with Charts
A chart is a tool you can use in Excel to communicate your data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends a lot easier. In this lesson, you will learn how to insert charts and modify them so that they communicate information effectively.
Excel 2010 Using Templates
In this lesson, you will learn how to create a new workbook with a template, as well as basic information about how templates work in Excel 2010.
Excel 2010 Reviewing and Sharing Workbooks
In this lesson, you will learn how to track changes, add comments, and compare two versions of a worksheet. You will also learn how to prepare a final version for sharing, including how to check spelling.
Excel 2010 Formatting Tables
Once you have entered information into a spreadsheet, you may want to format it. Formatting your spreadsheet can not only improve the look and feel, but also make it easier to use. In a previous lesson, we discussed many manual formatting options such as bold and italics. In this lesson, you will learn how to format as a table, to take advantage of the tools and predefined table styles available in Excel 2010.
Excel 2010 Filtering Data
Filters can be used to narrow down the data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different in the way that it allows you to qualify and display only the data that interests you. For example, you could filter a list of survey participants to view only those who are between the ages of 25-34. You could also filter an inventory of paint colors to view anything that contains the word "blue," such as "bluebell" or "robin's egg blue."
In this lesson, you will learn how to filter the data in your worksheet to display only the information you need.
Excel 2010 Outlining Data
If the amount of data in your worksheet becomes overwhelming, creating an outline can help. Not only does this allow you to organize your data into groups, and then show or hide them from view; you can also summarize data for quick analysis using the Subtotal command (for example, subtotaling the cost of office supplies depending on the type of product).
In this lesson, you will learn how to outline your worksheet in order to summarize and control how your data is displayed.
Excel 2010 Sorting Data
With over 17 billion cells in a single worksheet, Excel 2010 gives you the ability to work with an enormous amount of data. Arranging your data alphabetically, from smallest to largest, or other criteria, can help you find the information you're looking for more quickly.
In this lesson, you will learn how to sort data to better view and organize the contents of your spreadsheet.
Excel 2010 Working with Basic Functions
In this lesson, you will learn the basics of inserting common functions into your worksheet by utilizing the AutoSum and Insert Functions commands. You will also become familiar with how to search and find various functions, including exploring Excel's Functions Library.
Excel 2010 Creating Complex Formulas
In this lesson, you will learn how to write complex formulas in Excel following the order of operations. You will also learn about relative and absolute cell references and how to copy and fill formulas containing cell references.
Excel 2010 Printing
In this lesson, you will learn how to print worksheets, workbooks, and selections of cells. You will also learn how to prepare for printing by modifying page orientation, scale, margins, Print Titles, and page breaks.
Excel 2010 Worksheet Basics
In this lesson, you will learn how to name and add color to worksheet tabs, and how to add, delete, copy, and move worksheets. Additionally, you will learn how to group and ungroup worksheets, and freeze columns and rows in worksheets so that they remain visible even when you are scrolling.
Excel 2010 Creating Simple Formulas
Excel can be used to calculate numerical information. In this lesson you will learn how to create simple formulas in Excel to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use cell references to make working with formulas easier and more efficient.