Excel 2010: How to Use Conditional Formatting

January 31, 2012 by
Excel1

Conditional Formatting allows you to visually change the cells in your spreadsheet based on a set of rules you determine. You can set rules to highlight important cells or ranges of cells, emphasize unusual values, and visualize your data using the data bars, color scales, and/or icon sets. Now in … [Read more...]

Filed Under: Technology Tagged With: , , , , , , , , ,

Excel 2010: Protecting Excel Workbooks

August 19, 2011 by
Excelp1

In Excel, you can protect the entire workbook, specific worksheet, or just specific cells within a worksheet. The workbook is the entire file. The Worksheets are the tabs within the workbooks and the cells are the data is entered. With worksheet protection you can have total control over the … [Read more...]

Filed Under: Technology Tagged With: , , , , , ,

Excel: Learning How to View Data

June 24, 2011 by
Excel1

Excel spreadsheets can frequently feel like an overwhelming “sea of data”. However, simply changing the view can often quickly change your view! Below are several common viewing options that may be beneficial to you when reviewing, comparing, analyzing, or just general working in Excel. … [Read more...]

Filed Under: Technology Tagged With: , , , ,

Excel: Effectively Sorting Numbers

April 8, 2011 by
Excel1

Sorting data is typically simple and works at the click of a button. However, sometimes data gets sorted in an unexpected manner.  Have you ever experienced the frustration of numbers displaying like 1, 10, 2, 20 rather than in consecutive order? The reason is that even though some data looks like … [Read more...]

Filed Under: Technology Tagged With: , ,