Loading…

Get Schooled at New Horizons

Info and insights from New Horizons Computer Learning Centers!
Start exploring

Using Excel’s GETPIVOTDATA Formula to Build a Report Outside of a Pivot Table [Video]

Steve Chase, accomplished and certified Applications Instructor at New Horizons Computer Learning Centers, shares an Excel trick on using the GetPivotData formula to build a report. About Steve Steve Chase is a Microsoft Certified Training Instructor. Some of his courses include Excel, Word, PowerPoint, Publisher, Access, Outlook, OneNote, Photoshop, InDesign and QuickBooks. Based in San Antonio, TX, Steve and his […]

Keep leading zeros in Excel

If you need to enter the Zip code 02364 in your Excel spreadsheet, you’ll probably throw your hands up when Excel automatically changes the value to 2364. Your Zip code must have five digits, but by default Excel doesn’t display leading zeros. Here’s the solution: Create a custom number format with five digits. This custom […]

Save time in Excel with Shortcuts

Excel has lots of useful shortcut keys that perform various actions. The more you know, the more time you can save. Here are eight shortcuts we hope you find useful: To enter the current date into the active cell, press [Ctrl];. To enter the current time, press [Ctrl][Shift];. To enter or edit a cell comment in […]