Excel 2013

Viewing Two Worksheets from the Same Workbook Side-by-Side

Yesterday’s tip was about how to split the screen in Microsoft Windows, and view two documents side-by-side. Today’s tip is a more detailed look at a similar ability that is particular to Microsoft Excel. The setup is this: there are times in more complex Microsoft Excel documents when you want to view two worksheets from… Keep Reading

Removing Formulas but Keeping the Results in Excel

How to Copy and Paste Values My partner called me from work this week, with an Excel problem that was making his life hard. Luckily, there was a very simple solution. Someone had created an Excel spreadsheet with formulas in it. The formulas in this case were very simple – they took the number in… Keep Reading

Excel: Getting Started with Functions

Excel 2013 Functions Arabic() and Roman()

Although there isn’t a huge demand to convert numbers from Arabic to Roman notation, two new functions in Excel give you a great way to learn functions, and start to understand the basics that apply to all functions. First a quick definition, an Arabic number is one like we westerners use in normal day-to-day life,… Keep Reading