Microsoft Excel – Part 1

Understand the concept of Excel and learn basic Excel skills. Discover what Excel is most useful for. In this fundamentals course, you will learn to create error-free spreadsheets and master initial calculations.

Reed courses certificate of completion

Digital certificate - Included

• Getting Started with Excel 52:15

  • 1: Before the Training starts 01:00
  • 2: A Round of Introductions 01:00
  • 3: Navigate the Excel User Interface – Introduction Preview 00:40
  • 4: Handout: Table of Content (PDF) Preview 13:00
  • 5: Handout: Keyboard Shortcuts (PDF) 01:00
  • 6: Navigate the Excel User Interface 06:18
  • 7: Use Excel Commands – Introduction 00:42
  • 8: Use Excel Commands 04:15
  • 9: Create and Save a Basic Workbook – Introduction 00:29
  • 10: Create and Save a Basic Workbook 05:02
  • 11: Enter Cell Data – Introduction 00:29
  • 12: Enter Cell Data 05:16
  • 13: Flash Fill and Auto Fill 04:43
  • 14: Use Excel Help – Introduction 00:48
  • 15: Use Excel Help 03:13
  • 16: New Search Function 01:20
  • 17: Quiz 01 – Getting Started with Excel 03:00

• Performing Calculations 20:26

  • 18: Create Worksheet Formulas - Introduction 00:36
  • 19: Create Worksheet Formulas 05:55
  • 20: Insert Functions – Introduction 01:10
  • 21: Insert Functions 05:44
  • 22: Reuse Formulas and Functions – Introduction 00:58
  • 23: Reuse Formulas and Functions 05:03
  • 24: Quiz 02 – Performing calculations 01:00

• Modifying a Worksheet 31:40

  • 25: Insert, Delete and Adjust Cells, Columns and Rows – Introduction 00:18
  • 26: Insert, Delete and Adjust Cells, Columns and Rows 04:49
  • 27: Search for and Replace Data – Introduction 00:19
  • 28: Search for and Replace Data 06:18
  • 29: Use Proofing and Research Tools 00:18
  • 30: Check the Spelling in a Worksheet 03:08
  • 31: Insights Task Pane 03:04
  • 32: Ensure Accessibility in Excel 11:26
  • 33: Quiz 03 – Modifying a Worksheet 02:00

• Formatting a Worksheet 33:41

  • 34: Apply Text Formats – Introduction 00:37
  • 35: Apply Text Formats 06:07
  • 36: Apply Number Formats – Introduction 00:58
  • 37: Apply Number Formats 03:15
  • 38: Align Cell Contents – Introduction 00:27
  • 39: Align Cell Contents 03:32
  • 40: Apply Cell Styles and Themes – Introduction 00:24
  • 41: Apply Cell Styles and Themes 05:59
  • 42: Apply Basic Conditional Formatting – Introduction 00:50
  • 43: Apply Basic Conditional Formatting 03:38
  • 44: Create and Use Templates – Introduction 00:32
  • 45: Create and Use Templates 04:22
  • 46: Quiz 04 – Formatting a Worksheet 03:00

• Printing Workbooks 11:33

  • 47: Preview and Print a Workbook 00:30
  • 48: Configure and Preview a Print Job 03:02
  • 49: Set Up the Page Layout – Introduction 00:21
  • 50: Set Up the Page Layout 03:59
  • 51: Configure Headers and Footers – Introduction 00:28
  • 52: Configure Headers and Footers 02:13
  • 53: Quiz 05 – Printing Workbooks 01:00

• Managing Workbooks 17:05

  • 54: Manage Worksheets – Introduction 00:18
  • 55: Manage Worksheets 05:14
  • 56: Manage Workbook and Worksheet Views – Introduction 00:46
  • 57: Manage Workbook and Worksheet Views 04:35
  • 58: Manage Workbook Properties – Introduction 00:27
  • 59: Manage Workbook Properties 03:15
  • 60: Quiz 06 – Managing Workbooks 01:00
  • 61: Course Follow-Up 01:30

Excel is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel. Excel allows you to organize, analyze, update, and present your data to make better decisions based on those analyses. This course will provide you with basic knowledge and skills that you can build upon with further training to eventually become an Excel expert.

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

You will:

• Perform calculations
• Modify worksheets
• Format worksheets
• Print workbooks
• Manage workbooks

This course is suitable for you, if

• you are an Excel beginner
• you wish to gain foundational understanding of Excel
• you need to create and work with electronic spreadsheets

• To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser.
• The knowledge taught in the course Microsoft 365 – Learn, Understand and Use Basic Functions and Concepts or comparable practical experience is helpful to follow the content shown in this training more easily.

Currently there are no Q&As for this course. Be the first to ask a question.