Excel Help
Excel Certification Practice
Web Tutorials
- Training Courses for Excel 2021Directly from Microsoft, this site provides video tutorials for common issues in Excel 2021
- GCF LearnFree Excel 2021 trainingSeries of how-to guides on using Excel 2021.
- CustomGuide Excel trainingCustomGuide offers free cheat sheets for Microsoft Office applications.
- Excel EasyBasic descriptions and demonstrations of EXCEL functions and properties.
- Exceljet keyboard shortcuts222 Excel shortcuts for Windows and Mac
Excel Books
Learn Microsoft Office 2021: Your One-stop Guide to Upskilling with New Features of Word, PowerPoint, Excel, Outlook, and Teams by
Take your Microsoft Office skills to the next level by mastering the exciting new edition features and enhancements of Microsoft Office 2021, including communicating, collaborating, and presenting using Teams. This second edition includes chapters full of new exciting features for desktop and web apps and new content to broaden the acquired skills in the previous edition.
ISBN: 9781803239736Publication Date: 2022
Microsoft 365 Excel: the Only App That Matters by
This is a book about Microsoft 365 Excel, or Excel 365. With a new formula calculations engine and many new built-in functions, creating formula solutions and business models in Excel 365 is dramatically easier than at any time in the history of spreadsheets. In addition, with the new data tools like Power Query, Power Pivot, and Power BI, performing data analysis to make data driven decisions can be easily done on data with different structures, with different sources, and on small and big data alike. With this exciting new Excel 365 version, we will learn three types for formulas: Worksheet, M Code, and DAX, and we will learn three types of Reporting/Dashboarding tools: Standard PivotTables, Data Model PivotTables, and Power BI Visualizations. This means that the New Excel 365 is the only app that matters in our age of analytics and data driven decisions. Who is this book/class for? Everyone. The book starts at the beginning and moves to an advanced level by telling a logical story about how to use Excel to solve calculation-based problems and answer crucial questions.
ISBN: 9781615470709Publication Date: 2022
MrExcel 2021 by
Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
ISBN: 9781615470716Publication Date: 2021
