Excel 2019 in easy steps
Book - 2019
"Excel 2019 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include: Creating, editing and manipulating worksheets Formulas, Functions and Pivot Tables Handy templates to give you a head start Macros for everyday tasks to save time Charts to get an overview of your data Linking workbooks for automatic updates Using the Excel Online app to share and collaborate on spreadsheets and workbooks Adding images and illustrations to your spreadsheet to impress your colleagues!"--Publisher's description.
Saved in:
- Subjects
- Published
-
Warwickshire :
In Easy Steps Limited
[2019]
- Language
- English
- Main Author
- Item Description
- Includes index.
"Also covers MS Excel in Office 365."--Cover.
"Plain English. Easy to follow. Fully illustrated. In full color."--Cover. - Physical Description
- 192 pages : color illustrations ; 23 cm
- ISBN
- 9781840788211
- 1. Introduction
- The Spreadsheet Concept
- Microsoft Excel
- Microsoft Office 2019
- System Requirements
- Getting Office 2019
- Excel 2019 and Windows 10
- The Office 201 9 Ribbon
- Exploring Excel 2019
- 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 Wheel Mouse
- 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 Comments
- 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
- Tempiates
- Online Templates
- More Excel Resources
- What-If Analysis
- Summary Reports
- Goal Seek
- Optimization
- Project Worksheet
- Solver
- 11. Links and Connections
- Link to Workbooks
- Create External References
- Styles of Reference
- Source Workbook Changes
- Apply the Updates
- Turn Off the Prompt
- Save Workbook Online
- Using the Excel Online App
- Excel in Word
- Publish as PDF (or XPS)
- Index