Microsoft Excel 2013 Online Training

Everything that you need to learn Microsoft Excel 2013 is now available in our members-only area of our website. Learn at your own pace COMPLETELY ONLINE! Purchase the book and click buy now to learn at your own pace.
Microsoft Excel 2013 Comprehensive
Here is a sneak-peak of the online classroom:
Microsoft Excel 2013 is a spreadsheet program that allows you to store, organize, and analyze information. Excel is not only used by certain people to process complicated data, but it can be used to keep track of a small business' information or your bills at home. Anyone can learn how to take advantage of Excel's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different kinds of data.

Microsoft Excel - How Much Do You Really Use It
There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, seemingly magical formula, complex tables and macro tricks. You, obviously, are one of the latter...or are you? Check this list of essential Microsoft Excel skills to prove you are a power user or discreetly pick up any you might have missed.

Using a Lookup Table

The entries in the Over/Under Quota column, for example, give the user a numerical evaluation of where each agent stands in relation to his or her annual quota. Some people, however prefer simple ratings or letter grades, which, when used properly, group student grades in the same way sports teams award their medals or instructors group student grades. Excel contains functions that allow you to assign such rankings based on a secondary or lookup table.

Creating a Chart

Excel includes 10 chart types from which you can choose, including column, line, pie, bar, area, X Y (scatter), stock surface, bubble and radar. The type of chart you choose depends on the type of data that you have, how much data you have, and the message you want to convey. The example shown is a 3D Pie Chart.

IF Formulas

In addition to calculations that are constant accross all categories and observations, you may need to make calculations that will differ depending on whether or not a particular condition or set of conditions are met. In this example, you need to be able to vary compensation according to how much revenue is generated in any particular month. If the requirements are met, a bonus will be paid in any month where revenue is greater than the revenue for bonus.

PivotTables

A PivotTable report is an interactive tool that summarizes worksheet data. When working with data tables or lists of data, each different organization of the data requires a new table or list. In contrast, you can reorganize data and examine summaries in a PivotTable report with a few taps or mouse clicks. PivotTable reports allow you to view different summaries of the data quickly and easily, using just a single table. In this example, it summarizes the data to show the total sales and average sales in 2014 and 2015 for each department by style.

PivotChart

A PivotChart lets you quickly and easily look at complex data sets. PivotCharts have many of the same functions as traditional charts, with data series, categories, and the like, but they add interactive filters so you can browse through data subsets. In this example, a PivotChart report was created from the existing PivotTable report, formatting it as a 3-D clustered column chart that shows the two-year data for total sales side by side.

Auto Fill

When you copy one range to another, Excel displays an 'Auto Fill Options' button. The 'Auto Fill Options' button allows you to choose whether you want to copy the values from the source area to the destination area with formatting, do so without formatting, or copy only the format. To view the available fill options, tap or click the 'Auto Fill Options' button. The 'Auto Fill Options' button disappears when you begin another activity in Excel, such as typing data in another cell or applying formatting to a cell or range of cells.

Quick Analysis

Another tool for analyzing data quickly is the Quick Analysis tool. The Quick Analysis tool first appears as a smart tag option button, called the 'Quick Analysis Lens' button, located below and to the right of selecte data. WHen this button is tapped or clicked, Excel displays the Quick Analysis toolbar. In this example, we used the Quick Analysis toolbar to format the top 10% of column G, the percentage increase or decrease in sales. Formatting using the Quick Analysis tool is much faster than using the ribbon to apply conditional formatting.

Track Changes

Tracking changes when working collaboratively keeps a record of the changes that others make to a workbook. Tracking changes means that Excel, through the Track Changes command, will display the edited cells with a comment indicating who made the change, when the changes was made, and what the original value was of the cell that was changed. If either tracking or sharing is enabled, Excel enables the other by default.

Conditional Formatting

Conditional formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell. For example, you might want negative values to appear highlighted in red. In the example shown, the conditional format was used to show different flag colors based on the value in the column.

Record a Macro

The purpose of a macro is to automate editing tasks that would be repetitive and time-consuming if done for each entry seperately. Macros save you time and also ensure consistency. After the macro is created, it is assigned to a keyboard shortcut or a button on the Quick Access Toolbar. A macro is created by performating a set of steps and recording the steps as they are performed. The steps and their order should be dtermined in rehearsed before creating the macro. When recording the macro, you perform the steps as they are recorded, so that you can confirm that the macro will do what you expect it to do.

Happy Excel-ing!!