The PivotTables feature within Microsoft Excel 2013 can be a powerful ally in analyzing large amounts of data. However, to reduce the chance of errors, be sure to prepare Excel data for PivotTables analysis by following these 8 data clean up tasks first. Fail-Proof Tips to Get Excel 2013 Data in Shape for PivotTables Analysis You already know Excel is popular program for analyzing data, and PivotTables is one of the many[…]
READ MORE about Excel 2013 Tip: How to Prepare Excel Data for PivotTablesMicrosoft Excel
Excel 2013 Tip: Creating a Macro
Create an Excel Macro to Speed Up Your Repetitive Tasks! Macros—you’ve probably heard the word before, and you may have even heard people talk about how great they are. But what’s the hype all about? When it comes to working with spreadsheets in Excel 2013, some processes can be repetitive (and dare I say, boring). One example is formatting a report. While editing text styles and adjusting cells may feel like[…]
READ MORE about Excel 2013 Tip: Creating a MacroCreate a Custom List to Use with Excel’s AutoFill Tool
Day of the Week? Month of the Year? A Custom Series? Use Excel’s AutoFill Tool to Populate Cells Quickly AutoFill Magic You can use Excel’s AutoFill Tool for any number of known series. For days of the week, for instance, simply start with a day, then click and drag the dark square (the fill handle) at the bottom right of the bordered cells. In our example, we’ll put “Sunday” in[…]
READ MORE about Create a Custom List to Use with Excel’s AutoFill ToolExcel 2013 Tip: Inserting Comments
A picture says a thousand words, but numbers sometimes need more explanation. Have you ever looked at a spreadsheet of data and had some questions about the numbers you see? On the other hand, have you ever wanted to clarify something about the data you’re providing to someone else? Give your data context by adding notes to individual cells. This tip shows you how simple it is to insert comments[…]
READ MORE about Excel 2013 Tip: Inserting CommentsExcel Tip: Selecting the Entire Worksheet
Many users learn early on the “click + hold + drag” method for selecting a range of data using Microsoft Excel. If you have hundreds of rows of data, this method can be very tedious when needing to select all of the data within a worksheet. Selecting the Entire Excel Worksheet: Different Approaches Specify Different Results 3 Different Keyboard Shortcuts to Select “All” Data within a Worksheet A much easier method to select[…]
READ MORE about Excel Tip: Selecting the Entire WorksheetHow to Add and Remove Tabs from the Office 2013 Ribbon
How to Customize the Office 2013 Ribbon When Microsoft introduced the ribbon in 2007, there were mixed reviews. Some users found it convenient and easier to navigate while others found it cumbersome and confusing. In either case, ribbon customization allows users to make the ribbon work for their particular needs and workflow. It’s relatively simple to customize the Office 2013 Ribbon, adding, removing, and even creating unique tabs for the ribbon. The example[…]
READ MORE about How to Add and Remove Tabs from the Office 2013 RibbonCreate a Customized Tab on the Office 2010 Ribbon
When Microsoft introduced the ribbon in 2007, there were mixed reviews. Some users found it convenient and easier to navigate while others found it cumbersome and confusing. In either case, everyone can benefit from a great feature that allows you to create a customized tab. Rather than looking through each tab to find the desired command, you can create a custom tab and include your most commonly used tools. The[…]
READ MORE about Create a Customized Tab on the Office 2010 RibbonExcel 2010 Tip: Removing Duplicate Data
It’s not unusual to have duplicate occurrences of data in a spreadsheet, and there are numerous reasons why they might need to be removed. More importantly, you want them removed quickly so you can start analyzing the data. Luckily, there are various methods of locating and removing duplicate data in Microsoft Excel 2010. Note: Because you are permanently deleting data, it’s a good idea to copy the original range of[…]
READ MORE about Excel 2010 Tip: Removing Duplicate DataExcel Tip: Formatting a Table
Microsoft Office Excel 2010 provides numerous predefined table styles (or quick styles) that you can use to quickly format a table. If the predefined table styles don’t meet your needs, you can create and apply a custom table style. Although you can delete only a custom table style, you can remove any table style so that it is no longer applied to the data. Choose a table style when you[…]
READ MORE about Excel Tip: Formatting a TableRestoring Unsaved Documents in Word 2010
There is no feeling like the one you experience when a document closes and you realize you forgot to save your most recent version. Whether your system shut down or you simply forgot, Word 2010’s unsaved document recovery feature can save the day! In just a few clicks, you can recover the most recent version of your document for up to four days after closing it. While in Word 2010,[…]
READ MORE about Restoring Unsaved Documents in Word 2010