Excel
-
Blog
Microsoft Excel Essential Tools
Microsoft Excel has hundreds of tools that you can use to make your spreadsheets tick. However, if you’re looking to level up your expertise, get to know these six essential features today. This is a whistle-stop tour of some must-know tools in Microsoft Excel. To find out more about each feature, click the “Related” links in each section. 6 Excel…
Read More » -
Blog
4 Excel Power Query Commands You Need to Know
Have you heard of Power Query in Microsoft Excel but always thought that it’s only intended for Excel experts? Let me stop you there because, actually, Power Query is designed to be user-friendly and, most importantly, save you a lot of hassle when organizing your data. This guide is intended for readers who are new to Microsoft Excel or Power…
Read More » -
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 »