Learning Excel 2019

Learning Excel 2019

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 07m | 157 MB

Microsoft Excel puts a wealth of functionality at your fingertips. This course was designed to focus on the most essential of these functions, covering the features and capabilities that brand-new users need to get going with the 2019 version of Excel. Instructor David Rivers covers creating and opening workbooks, entering text and numbers, working with formulas, basic formatting, inserting charts, and sharing and printing workbooks. Upon wrapping up this course, you’ll have the skills you need to start building easy-to-use, accurate spreadsheets with this hugely popular program.

Topics include:

  • What is Excel?
  • Creating new workbooks
  • Adding formulas and functions
  • Using AutoFill
  • Formatting, text, numbers, dates, and times
  • Managing rows and columns
  • Inserting charts
  • Sharing and printing workbooks
Table of Contents

Introduction
1 Build your foundation in Excel
2 What you need to know

Get Started
3 What is Excel
4 Create a new workbook
5 Add text and numbers
6 Add formulas and functions
7 Understanding cell references when copying and pasting
8 Using AutoFill

Modify Worksheets
9 Format text
10 Format numbers
11 Format dates and times
12 Manage rows and columns
13 Freeze panes
14 Insert recommended charts

Share and Print Workbooks
15 Share workbooks using online options
16 Send workbooks as email attachments
17 Print workbooks

Conclusion
18 Next steps