Setting Dates in Excel: Repeating, Consecutive & Custom
Ever been frustrated by repeatedly typing in dates in Excel? You know there is a way to make dates appear in order or repeat but…
Formatting
Hyperlinking In Excel: To the Web or to Another Worksheet
You might already know how to hyperlink a cell to external sources, namely to the web. In case you don’t, here is a quick tutorial…
Changing the Alignment of Data in an Excel Cell
Making an excel spreadsheet look “pretty” is not as daunting as people make it seem. Many people in the workforce will shy away from tinkering…
Wrapping Text in Excel: Formatting Foundations
Have you ever had so much data in one cell that that it spills over to the next cell or just disappears? And you don’t…
Excel Dashboards: Your Guide to Getting Started
Excel Dashboards empower you to display your data in interactive and dynamic ways. They give you a comprehensive snapshot of your data and save you…
Converting Numbers into Accounting in Excel
If you’ve ever wondered why there is an accounting format in Excel when there is already a currency format than you are not alone. Creating…
Converting Numbers to Percentage in Excel
Cell formatting in Excel allows you to represent your numbers in a variety of ways: as a date, as a percentage, as currency, and with…
Getting Starting with Excel Formatting
When it come to Excel formatting, there are so many options and tools that it can be a little overwhelming trying to determine what to…
Excel Database Tips: Keys to Organizing Your Data
An Excel database is a great way to organize your data. It includes a series of records in rows with fields of data entered in…
Auto Expand Multiple Columns in Excel
One of the most common fears of Excel is getting unruly data files and not knowing how to quickly and easily format it to look…