When working in multiple files or lots of data, it is often helpful to view Excel spreadsheets side by side. Excel has a few tools for doing this. Side by side Excel viewing with two workbooks If your data is
Excel Side by Side Read Post »
Date formulas can always be challenging when working with Excel. Here are 3 that can be very useful when trying to calculate days or months between 2 dates, or to display the date as the day of the week in
Excel – Useful Date Calculations Read Post »
The width of columns and height of rows can be adjusted to better fit your data in a few different ways. Drag the border Hover your arrow over the border between the column or row labels. Then click and drag
Resizing Rows and Columns in Excel Read Post »
Reading a chart of numbers can be made more difficult if you have long column headers that expand the width of the cells. Long column headers can even cause the dreaded horizontal scroll that everyone hates so much.Abbreviating headers can
Diagonal Headers in Excel Read Post »
Microsoft Word starts page numbering by default on the first page, and changing this can be one of the more challenging puzzles in the software. If you need to use Roman numerals, or one of the other custom formats, then
Start page numbering on page 2 in Microsoft Word with Roman Numerals Read Post »
Looking for this tip in the latest versions of Word – more recent than 2010? Click Here for Latest Tip How do I start page numbers on the second page of my Word document? Word 2010, by default, starts page
Start page numbers on page 2 – Microsoft Word Read Post »
Deciphering a spreadsheet is easier with Excel conditional icons, which visually communicate changes and differences in numbers with directional arrows, stop light colors, flags, and bars. In the example above, a simple sales report has been dressed up with Excel
Excel Conditional Icons Read Post »
In Word 2003 you could press your insert key on your keyboard to either type over text or insert text. The default was to insert text, but you could quickly change that by using that key. Now in Office 2007
Word Overtype Mode Read Post »
A common problem in processing data in Excel is handling duplicates or double entries. Excel has a few convenient tools for quickly making these changes. Simply eliminating duplicate entries in Excel After highlighting your chart of data, click on the
Finding Duplicates in Excel Read Post »
Excel automatically converts numbers with 15 or more digits into scientific notation. In fact, when it simplifies the number it loses the rounded digits. They aren’t recoverable.As long as you don’t use numbers larger than a quadrillion, this isn’t a
Scientific notation in Excel Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
