Syndetics cover image
Image from Syndetics

Microsoft Excel workbook / by Paul McFedries, Greg Harvey.

By: Contributor(s): Material type: TextTextSeries: --For dummiesPublisher: Hoboken, NJ : John Wiley & Sons, Inc., [2022]Edition: 2nd editionDescription: ix, 371 pages : illustrations ; 26 cmContent type:
  • text
Media type:
  • unmediated
Carrier type:
  • volume
ISBN:
  • 9781119832157
  • 1119832152
Other title:
  • Microsoft Excel workbook for dummies [Cover title]
  • Excel workbook
  • Excel workbook for dummies
Subject(s): Genre/Form:
Contents:
Building worksheets. Getting familiar with the Excel interface ; Entering the worksheet data ; Formatting the worksheet ; Printing worksheet reports ; Modifying the worksheet -- Using formulas and functions. Building formulas ; Copying and correcting formulas ; Creating date and time formulas ; Financial formulas and functions ; Using math functions ; Using common statistical functions ; Using lookup functions ; Using logical functions ; Text formulas and functions -- Working with graphics. Charting worksheet data ; Adding graphics to worksheets -- Managing and securing data. Building and maintaining tables ; Protecting workbooks and worksheet data -- Doing data analysis. Performing what-if analysis ; Generating PivotTables -- Macros and visual basic for applications. Using macros ; Using the visual basic editor -- The part of tens. Top ten features in Excel ; Top ten tips for using Excel like a pro --Index.
Summary: 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.
Holdings
Item type Home library Collection Call number Materials specified Status Date due Barcode Item holds
Adult Book Adult Book Dr. James Carlson Library NonFiction 005.54 M143 Checked out 05/28/2024 33111010654123
Adult Book Adult Book Main Library NonFiction 005.54 M143 Available 33111010828602
Adult Book Adult Book Northport Library NonFiction 005.54 M143 Available 33111009434321
Total holds: 0

Enhanced descriptions from Syndetics:

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.

Includes index.

Building worksheets. Getting familiar with the Excel interface ; Entering the worksheet data ; Formatting the worksheet ; Printing worksheet reports ; Modifying the worksheet -- Using formulas and functions. Building formulas ; Copying and correcting formulas ; Creating date and time formulas ; Financial formulas and functions ; Using math functions ; Using common statistical functions ; Using lookup functions ; Using logical functions ; Text formulas and functions -- Working with graphics. Charting worksheet data ; Adding graphics to worksheets -- Managing and securing data. Building and maintaining tables ; Protecting workbooks and worksheet data -- Doing data analysis. Performing what-if analysis ; Generating PivotTables -- Macros and visual basic for applications. Using macros ; Using the visual basic editor -- The part of tens. Top ten features in Excel ; Top ten tips for using Excel like a pro --Index.

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.

Powered by Koha