Keyboard Shortcut – Used in Many Programs

CTRL + N is one of most versatile keyboard shortcuts in Microsoft Office and beyond. Here are some of the ways that you can use this keyboard combo: In Word, it creates a new document In Excel, it creates a new workbook In PowerPoint, it creates a new presentation In...

Excel Tip – Maximums

Have you ever wondered how many rows or columns there are in the newer versions of Excel? Or how many characters can I fit in one cell? Wonder no more, here are some of Excel’s max capabilities: Rows: 1,048,576 Columns: 16,384 Cells in a worksheet: 17,179,869,184...

Excel Tip – 3 Different Count Functions

Have you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number. The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it    =COUNT(A2:A24) The...

Excel Tip – 3 Different Count Functions

Have you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number. The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it =COUNT(A2:A24) The second...

Word Tip – Show Multiple Pages on the Screen at Once

Open a multi-page document.   On the View tab, in the zoom group, click on Multiple Pages. Use the Zoom bar (bottom right) to zoom in or out to see as many or as few pages as you like. To return to seeing only one page click on One Page, which is in the same group on...