Microsoft Excel in easy steps

Microsoft Excel in easy steps

Mike McGrath, 1956-

Book - 2023

"Microsoft Excel in easy steps guides you through the essential functions of Microsoft Excel--whether you are new to Excel and the spreadsheet concept, or just upgrading from an older version. This edition is illustrated using the most up-to-date version of Excel in Microsoft 365 at the time of printing"--

Saved in:
Place a Hold Save to List Email this

2nd Floor Show me where

005.54/EXCEL/McGrath
0 / 1 copies available
Location Call Number   Status
2nd Floor 005.54/EXCEL/McGrath Due Dec 26, 2024
Subjects
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Handbooks and manuals.
Genres
Handbooks and manuals
Published
Leamington Spa, Warwickshire, United Kingdom : In Easy Steps Limited [2023]
Language
English
Main Author
Mike McGrath, 1956- (author)
Other Authors
Michael Price, 1942- (author)
Item Description
Includes index.
Physical Description
192 pages : color illustrations ; 23 cm
ISBN
9781840789966
  • 1. Introduction
  • The Spreadsheet Concept
  • Microsoft Excel
  • Microsoft 365
  • System Requirements
  • Getting Excel
  • Excel and Windows
  • The Excel Ribbon
  • Exploring Excel
  • Excel Online App
  • 2. Begin with Excel
  • The Excel Window
  • Create a Workbook
  • Add Data to the Worksheet
  • Build the Worksheet
  • Fill Cells
  • Complete the Worksheet
  • Format the Text
  • Format the Numbers
  • Print the Worksheet
  • Insert, Copy, and Paste
  • Excel Help
  • Contextual Help
  • Excel File Formats
  • 3. Manage Data
  • Use Existing Data
  • Import Data
  • Navigate the Worksheet
  • Scroll with the Mouse Wheel
  • Keystrokes and Touch
  • Sort Rows
  • Find Entries
  • Filter Information
  • Remove Duplicate Entries
  • Check Spelling
  • Freeze Headers and Labels
  • Hide Columns or Rows
  • Protect a Worksheet
  • 4. Formulas and Functions
  • Number Formats
  • Text Formats
  • Relative References
  • Absolute References
  • Name References
  • Operators
  • Calculation Sequence
  • Functions
  • AutoSum
  • Formula Errors
  • Add Notes
  • 5. Excel Tables
  • Create an Excel Table
  • Edit Tables
  • Table Styles
  • Table Totals
  • Count Unique Entries
  • Structured References
  • Calculated Columns
  • Insert Rows
  • Custom Sort
  • Print a Table
  • Summarize a Table
  • Convert to a Range
  • 6. Advanced Functions
  • Function Library
  • Logical Functions
  • Lookup/Reference Functions
  • Financial Functions
  • Date & Time Functions
  • Text Functions
  • Math & Trig Functions
  • Random Numbers
  • Statistical Functions
  • Engineering Functions
  • Excel Add-ins
  • Evaluate Formula
  • 7. Control Excel
  • Audit Formulas
  • Protect Formulas
  • Check for Errors
  • Backup
  • AutoSave and AutoRecover
  • Startup Switches
  • Create a Shortcut
  • Ribbon Key Tips
  • Using Key Tips
  • Collapse the Ribbon
  • Quick Access Toolbar
  • Mini Toolbar
  • Print Worksheets
  • 8. Charts
  • Create a Chart
  • Recommended Chart Type
  • Change Chart Layout
  • Legend and Data Table
  • Change Chart Type
  • Pie Chart
  • 3-D Pie Chart
  • 3-D Column Chart
  • Share Price Data
  • Line Chart
  • Stock Chart
  • Mixed Types
  • Print Charts
  • 9. Macros in Excel
  • Macros
  • Create Macros
  • Record a Macro
  • Apply the Macro
  • View the Macro
  • Macro to Make a Table
  • Edit the Macro
  • Use the Macro
  • Create Macros with VBA
  • Add Macros to the Toolbar
  • Debug Macros
  • 10. Templates and Scenarios
  • Templates
  • Online Templates
  • More Excel Resources
  • What-If Analysis
  • Summary Reports
  • Goal Seek
  • Optimization
  • Project Worksheet
  • Solver
  • 11. Links and Connections
  • Create External References
  • Styles of Reference
  • Source Workbook Changes
  • Apply Updates
  • Turn Off the Prompt
  • Save Workbook Online
  • Using the Excel Online App
  • Excel in Word
  • Publish as PDF (or XPS)
  • Index

Similar Items