Main MenuBook & Article Categories
- Main Menu
Book & Article Categories
- Main Menu
Collections
Explore all collections
Excel: Expert Guides and Resources
Oops! Something went wrong while submitting the form.
Articles & Books From Excel
Get into the nitty gritty of Excel, the all-important spreadsheet tool Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app.
Cheat Sheet / Updated 08-18-2025
So, you’re working your way through Microsoft 365 Excel All-in-One For Dummies? That’s a great choice for getting more out of your powerful spreadsheet app. Use this handy Cheat Sheet to keep key Excel information at your fingertips as you build your worksheets and formulas and as you write Visual Basic for Applications (VBA) code in the Visual Basic Editor.
Cheat Sheet / Updated 04-21-2025
Whether you're just starting out with Excel or looking to sharpen your spreadsheet skills, this cheat sheet brings together some of the most practical tips you need for everyday use. It covers everything from quickly closing all your workbooks, doing instant calculations, and even using advanced search with regular expressions.
Make Excel work for you with this brand new guide to spreadsheet essentials Knowing a little about Excel is essential for almost every profession. Knowing a lot about Excel makes you one of the most valuable people in the office. Microsoft 365 Excel For Dummies helps you build your spreadsheet skills as it walks you through the basics of creating a spreadsheet, organizing data, performing calculations, and creating charts and graphs in Microsoft's powerful spreadsheet software.
Article / Updated 04-21-2025
Excel templates are the unsung heroes of efficient spreadsheeting — like meal prepping, but for your data. Why start from scratch every time, when you can have a perfectly formatted, mistake-proof starting point? Plus, using templates saves you from the inevitable “Oops, I just saved over my clean master file” moment.
Turn Excel into an unstoppable data-and number-crunching machine.Microsoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it's been supercharged with Copilot—Microsoft's AI-powered helper—it's even easier to produce accurate and useful results anywhere, anytime.
Your step-by-step guide to doing more with Microsoft Excel Fully updated for the latest version of Office 365, Excel VBA Programming For Dummies will take your Excel knowledge to the next level. With a little background in Visual Basic for Applications (VBA) programming, you can go well beyond basic spreadsheets and functions.
Article / Updated 08-28-2023
In Excel 2013, you can insert and delete individual cells or even ranges that don’t neatly correspond to entire rows or columns. When you do so, the surrounding cells shift. In the case of an insertion, cells move down or to the right of the area where the new cells are being inserted. In the case of a deletion, cells move up or to the left to fill in the voided space.
Article / Updated 06-07-2023
To share Excel 2019 workbooks from your OneDrive, you follow these steps: Open the workbook file you want to share in Excel 2019 and then click the Share button at the far right of the row with the Ribbon. If you’ve not yet saved the workbook on your OneDrive, a Share dialog box appears inviting you to upload the workbook file to OneDrive.
Article / Updated 06-07-2023
Excel can help you make all sorts of calculations. Here's a selection of Excel's statistical worksheet functions. Each one returns a value into a selected cell.Check out these functions for central tendency and variability. Function What it calculates AVERAGE Mean of a set of numbers AVERAGEIF Mean of a set of numbers that meet a condition AVERAGEIFS Mean of a set of numbers that meet one or more conditions HARMEAN Harmonic mean of a set of positive numbers GEOMEAN Geometric mean of a set of positive numbers MODE.
