Using Excel 2019: The Step-by-step Guide to Using Microsoft Excel 2019
by Kevin Wilson
- Length: 150 pages
- Edition: 1
- Language: English
- Publisher: Elluminet Press
- Publication Date: 2020-01-31
- ISBN-10: 1913151034
- ISBN-13: 9781913151034
- Sales Rank: #3071655 (See Top 100 Books)
We’ve all been there before, staring at a computer screen with no idea what to do — don’t worry Using Excel 2019 is here to help. Written by best-selling technology author, lecturer, and computer trainer Kevin Wilson, Using Excel 2019 is packed with easy to follow instructions, photos, illustrations, helpful tips and video demos.
Updated to cover Microsoft Excel 2019, this guide will show you how to:
- Start Excel and find your way around the ribbon menu
- Build spreadsheets, enter data, import data and format text
- Add borders, text orientation, colours and highlights
- Use conditional formatting
- Build formulas to manipulate data
- Use built in functions to add up, average and count data
- Use Lookup and IF functions
- Create charts from spreadsheet data and customise the layout
- Work with workbooks, open, save, and print workbooks
- Basic File Management
- Understand data analysis using goal seek, scenarios, forecasts,
- Build pivot tables and pivot charts
- Use data validation techniques to help keep data entry accurate
- and more…
You’ll want to keep this edition handy as you make your way around Microsoft Excel. Have Fun!
Using Excel 2019 About the Author Table of Contents Spreadsheets What is a Spreadsheet? Getting Started with Excel Starting Excel Main Screen The Ribbon The Home Ribbon Tab The Insert Ribbon Tab The Page Layout Ribbon Tab The Formulas Ribbon Tab The Data Ribbon Tab The Review Ribbon Tab The View Ribbon Tab File Backstage Tell Me Feature Building Spreadsheets Creating a New Workbook Entering Data Simple Text Formatting Text Orientation Resizing Rows and Columns Inserting Rows & Columns Cut, Copy & Paste Sorting Data Formatting your Spreadsheet Cell Alignment Text Format Cell Borders Opening a New Sheet Copy Data Between Sheets Freeze Panes Split Screen Importing Data Conditional Formatting Managing Workbooks Using Multiple Workbooks Printing your Spreadsheet Page Setup Page Options Margins Customising Margins Headers & Footers Page Print Order Print Options Print Row and Column Headers Print Gridlines Print Selection Print Titles Show & Print Formulas Opening a Saved Workbook Saving Workbooks Save as a Different Format Formulas & Functions Using Formulas BIDMAS Rule Using Functions Count CountIf Auto Sum Average Max & Min IF Function VLookup Types of Data Cell Referencing Relative Absolute Adding Charts Types of Chart Creating a Chart Formatting Charts Chart Titles Chart Elements Axis Titles Customising Charts Change Background to Solid Colour Change Background to Gradient Colour Change Chart Type Move and Resize Charts Data Analysis Goal Seek Data Analysis with Scenario Manager Creating Scenarios Summary Reports Creating Pivot Tables Using Slicers Sorting Pivot Table Data Pivot Charts Data Validation Validation Rules By Data Type Text Length Displaying Messages Input Message Error Messages Create a Drop Down List Locking Cells
Donate to keep this site alive
To access the Link, solve the captcha.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.