Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Articles & Books From Excel
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.
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.
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.
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.
Step by Step / Updated 09-16-2022
You can add text comments to particular cells in an Excel 2013 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself to verify a particular figure before printing the worksheet or to remind yourself that a particular value is only an estimate.
Article / Updated 08-01-2022
Excel’s AutoFilter feature makes filtering out unwanted data in a data list as easy as clicking the AutoFilter button on the column on which you want to filter the data and then choosing the appropriate filtering criteria from that column’s drop-down menu. If you open a worksheet with a data list and you don’t find Excel’s AutoFilter buttons attached to each of the field names at the top of the list, you can display them simply by positioning the cell pointer in one of the cells with the field names and then clicking the Filter command button on the Ribbon’s Data tab or pressing Ctrl+Shift+L or Alt+AT.