Category 'Excel'

4
Feb

Date formats

Excel, Google Sheets, Microsoft Office | Comments Off on Date formats

Custom date formats are often useful in your reports. Excel has two quick formats for a date, one is “Short Date” the other is “Long date.” Google Sheets has a simple “Date” format which looks just like Microsoft Excel’s Short Date. Hopefully, by the time you finish this post, you’ll be able to create a […]

16
Jan

Using VLOOKUP

Excel, Google Drive, Google Sheets, Microsoft Office, VLOOKUP | Comments Off on Using VLOOKUP

XLOOKUP is a newer function that surpasses the awesomeness of VLOOKUP, but it’s only available in the Office 365 (Excel 2019) versions (and newer as they’re developed). There is still great value in VLOOKUP (and HLOOKUP as well), it just takes nesting more functions. Read the XLOOKUP post to learn more about it. Manually eyeball […]

3
Jan

NEW! XLOOKUP

Excel, Microsoft Office | Comments Off on NEW! XLOOKUP

This is so cool. Mind Blown. XLOOKUP is conceptually similar to the other LOOKUP Functions, eXcept it doesn’t have the limitations of VLOOKUP and is easier to use! Use it in place of VLOOKUP or HLOOKUP. Default match is exact not approximate Match options are greater File_not_found options Searches a range for a match and […]

16
Jul

What’s in a Name?

Excel, Microsoft Office, Tips N Tricks | Comments Off on What’s in a Name?

Using Excel Names When using formulas or referring to a specific cell in your worksheet, you’ll typically reference ‘range’ or specific cell. For example, B6:B10 is a range reference, where B6 is a cell reference. A problem with this sort of reference is that it’s not very meaningful and easy to forget. If you want […]

10
May

Windows 10 Housekeeping

Microsoft Office, Tips N Tricks, Windows | Comments Off on Windows 10 Housekeeping

The Windows 10 Start menu includes so many apps that it can be overwhelming. With so many choices it can be hard to find the app you’re looking for. You may resort to saving shortcuts on your desktop because that’s what you’ve always done. But then your desktop is cluttered also! The Solution The solution […]

10
May

Windows 10 Steps Recorder

Microsoft Office, Tips N Tricks, Windows | Comments Off on Windows 10 Steps Recorder

Did you know that Windows 10 has a built-in app that will not only record the steps of what you’re doing, but it also snags screenshots as you go! I’ve recorded the steps for how to rearrange the tile groups on your Windows 10 start menu. Ready? This is how the results look (except not […]

8
May

Excel List Management

Excel, Microsoft Office | Comments Off on Excel List Management

What is a List? A list is a collection of related data. Examples might include your contact list, an inventory, or your price list. Lists are organized in Rows and Columns, with the first row containing labels. The labels identify the value, or data, directly below the columns. Features of a well designed List include […]

30
Apr

Quick Parts

Microsoft Office, Word | Comments Off on Quick Parts

What are Quick Parts? Quick Parts, simply stated, are re-usable Word elements. The elements include formatted text, enabling the user to quickly create professional documents. Since Office 2007, Word includes dozens of built-in Quick Parts. Including headers, footers, cover pages, tables, bulleted and numbered lists, Tables of Contents, and AutoText. Create Your Own Creating your […]

26
Apr

Formulas vs Functions

Excel, Microsoft Office | Comments Off on Formulas vs Functions

How They Differ The words Formula and Function are often used interchangeably, but they don’t mean the same thing. At the very core level, they are similar. However, it may help you understand them better if we break them down and view them as different from one another. Formulas Think of Formulas as mathematical calculations […]

26
Mar

Excel: Data Tab

Excel, Microsoft Office | Comments Off on Excel: Data Tab

The Excel Data Tab has tools to help you work with the data in your worksheets. There are tools to import data from external sources. Also, tools to sort and filter. As well as tools to separate data into more columns. Sorting and Filtering Sorting and Filtering are relatively simple tools at their face. However, […]