Excel
-
Blog
Microsoft Excel Essential Skills Test
Whether you’ve landed a job interview for a role that requires fundamental Microsoft Excel skills or you’re looking to solve a real-world problem, take the How-To Geek Beginner Excel Test to double-check that you know the nuts and bolts of the popular spreadsheet software. This is the first of a three-part series. The second (intermediate) and third (advanced) will be…
Read More » -
Blog
How to Create a Drop-Down List from a Column of Data in Excel
Quick Links Using a Column in a Formatted Excel Table Using a Column in an Unformatted Dataset Microsoft Excel’s Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted Excel table. Let’s take a look at…
Read More » -
Blog
Excel for Microsoft 365 cheat sheet – Computerworld
One feature I found particularly useful when adding email addresses: As you type, Excel looks through your corporate or personal address book and lists the names and addresses of contacts who match the text you’ve input. Click the address you want to add. This not only saves you a bit of time but helps make sure you don’t incorrectly type…
Read More » -
Blog
Comments vs. Notes in Microsoft Excel: What’s the Difference?
While Microsoft Excel’s comments and notes tools both let you annotate a cell, they serve different purposes, work in diverse ways, and vary in how they look on a printed Excel worksheet. In this guide, I’ll show you how to use them before summarizing their similarities and differences. Comments in Microsoft Excel are individual-cell annotations that can be turned into…
Read More » -
Blog
6 Excel Keyboard Shortcuts I Wish I Knew Earlier
Despite having worked in Microsoft Excel for decades, I’m always learning new ways to speed up my workflow. Specifically, I’ve stumbled upon some keyboard shortcuts over the past couple of years that I now use every day, and I wish I’d known about them sooner! 1 F2: Enter a Cell’s Edit Mode When you enter a formula into Excel and…
Read More » -
Blog
Why veterans can excel in data centers – and could help the IT sector address its skill shortages
When the worst case scenario is a mortar attack, IT industry stressors are significantly less dire. That’s one of the reasons why Bryan Marlatt, chief regional officer at CyXcel, says that former military members can excel at IT roles, including those like his in the data center. Having held various roles in the IT sector since leaving the US Army,…
Read More » -
Blog
How to disable Copilot on Microsoft Word, Excel, OneNote, PowerPoint on Windows 11
On Windows 11, it’s possible to disable the Copilot AI assistant on the Microsoft 365 (Office) apps, including Word, Excel, PowerPoint, and OneNote, and in this guide, I’ll show you how to complete this configuration. Although in the past, you had to get the Copilot Plus subscription to access the AI assistant in the Office apps, Microsoft decided to raise…
Read More » -
Blog
‘The entire forecasting business process changed’: Microsoft CEO Satya Nadella says Excel changed the game for enterprises in 1985 – he’s confident AI tools will do the same
AI is yet to have the same transformative impact on business and knowledge work akin to the launch of Excel, according to Microsoft CEO Satya Nadella, but he appears confident a big breakthrough is looming on the horizon. Speaking on Dwarkesh Patel’s podcast, Nadella harkened back to Microsoft Excel and its impact on financial forecasting in years gone by, which…
Read More » -
Blog
Develop Excel Skills From Basics to AI Integration With This $35 Course Bundle
TL;DR: Streamline your daily workflow with the latest Excel features, thanks to The Complete Microsoft Excel Training Bundle for just $34.99. Many people believe Excel is nothing more than a program for faster number crunching, but that is not the case. When you develop advanced Excel skills, you become far more valuable as a professional. Even if you have no…
Read More » -
Blog
Using the Free Version of Excel? You’re Missing These 5 Features
Summary Microsoft Excel online lacks functionality compared to paid versions that include features including advanced formulas and charts. Powerful data analytics tools like Power Query and Power Pivot are only available with a Microsoft 365 subscription. Desktop Excel offers additional features, better offline use, improved reliability, and more automation capabilities. Full-fat Microsoft Excel is still the big kid in the…
Read More »