TOIT Training

Learning Excel 2019 – Beginner (TOSA)

Learning Excel 2019 – Beginner (TOSA)
  • Overview
  • Curriculum
  • Reviews

Objectives:


• Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
• Perform calculations using formulas and functions
• Apply formatting to text, numbers, and cells including Conditional Formatting and Cell Styles
• Control how your worksheets print using Page Layout options
• Sort and filter column data
• Identify different Chart Types
• Use Ideas in Office 365

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were
When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more.

This course is your first step towards becoming an expert at using Excel 2019. The material is aligned with the Level 1 Beginner TOSA Certification.

Topics covered include:
• Navigating the interface
• Creating and saving workbooks
• Selecting and entering data
• Performing calculations
• Formatting data

  • 0 Sections
  • 0 Lessons
  • 0 Quizzes
  • 2h 17m Duration
Expand All

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Getting Started
    Navigating the Interface 8:42
    Selecting Data 9:15
    Using Commands 7:14
    Creating a New Workbook 8:04
    Entering Cell Data 5:59
    Using Excel Help 2:05
    Formulas and Functions
    Creating Formulas 7:57
    Inserting Functions 8:14
    Using Absolute References 9:51
    Formatting
    Applying Text Formats 8:35
    Applying Number Formats 7:24
    Customizing Number Formats 7:46
    Applying Cell Styles 5:20
    Applying Conditional Formatting to Numbers 6:45
    Applying Conditional Formatting to Text and Dates 7:56
    Printing
    Printing Workbooks 4:12
    Setting the Page Layout 6:34
    Sorting and Filtering
    Sorting Data 5:18
    Filtering Data 5:20
    Other
    Using Chart Types 2:27
    Ideas in Office 365 2:06

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

Learning Excel 2019 – Beginner (TOSA)
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)