|
Published:
January 19, 2022

Excel Workbook For Dummies

Overview

Get practical walkthroughs for the most useful Excel features

Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for.

This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program.

Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also:

  • Brush up on and practice time-saving keyboard shortcuts for popular commands and actions
  • Get a handle on multi-functional and practical pivot tables with intuitive practice exercises
  • Learn to secure your data with spreadsheet password protections

Perfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.

Read More

About The Author

Paul McFedries has published over 100 books, with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. He is the author of the recently released Excel Data Analysis For Dummies and Google’s G Suite For Dummies.

Greg Harvey, PhD was author of over 30 For Dummies titles covering Excel.

Sample Chapters

excel workbook for dummies

CHEAT SHEET

As an integral part of the ribbon interface used by all the major apps in Microsoft Office, Excel gives you access to hot key sequences that, for all of you keyboard enthusiasts, can greatly speed up the process of selecting program commands. To save time when accessing commands, look up its hot key sequence in these Cheat Sheet tables.

HAVE THIS BOOK?

Articles from
the book

The Formatting toolbar in Excel 2003 and earlier versions holds a variety of buttons for commonly used formatting operations on your average spreadsheet, like changing text size or style, formatting numbers, and placing borders around cells. On the Formatting toolbar, the tools are arranged into six groups of buttons (from left to right).
The Standard toolbar in Excel contains a variety of buttons for doing things like opening a new workbook, zooming in and out on your current worksheet, and sorting selected items. Get to know the buttons for performing common tasks on the Standard toolbar of Excel versions 2003 and earlier by using the helpful figure below.
When you're working in Excel and entering data in a cell, it's essential to complete the entry either by clicking another cell with the mouse pointer or by using one of the handy shortcut keys shown here to move the cell cursor: Press To Arrow keys (↑, ↓, ←, →) Complete cell entry and move cell cursor one cel
A large part of the work you do in Excel is editing the cell contents in worksheets. To save time editing, learn the following Excel shortcuts, including the key combinations and their functions: Press To F2 Edit current cell entry and position insertion point at the end of cell contents Shift+F2 Edit comment
As an integral part of the ribbon interface used by all the major apps in Microsoft Office, Excel gives you access to hot key sequences that, for all of you keyboard enthusiasts, can greatly speed up the process of selecting program commands. To save time when accessing commands, look up its hot key sequence in these Cheat Sheet tables.
When you first launch the Microsoft Office application program Excel (versions 2003 and earlier), the following program window appears, containing three blank worksheets. You can build your new spreadsheet using any of the pages, which follow the general Excel Worksheet template.
https://cdn.prod.website-files.com/6630d85d73068bc09c7c436c/69195ee32d5c606051d9f433_4.%20All%20For%20You.mp3

Frequently Asked Questions

No items found.