Excel 2019 Introduction

Excel 2019 Introduction

Overview

Upgrade your data analysis skills with the complete Excel 2019 Introduction course.

This practical video training course will take you to a more advanced level, exploring key functions, features and tools of Microsoft Excel 2019. Through step-by-step guidance, you will learn how to perform a range of project management and data analysis tasks that will give you a competitive advantage in the job market. From advanced formatting, to working with charts, this course provides tutorial-based training that will take your spreadsheet knowledge to the next level in no time.

You will also learn how to track changes, share your work with your team, and merge workbooks, for easy collaboration and project management. This course is ideal for those who have completed the beginners training, or have a basic working knowledge of Excel and want to learn how to use Excel’s more complex administrative tools.

Why People Love and Enrol in The Excel 2019 Introduction from One Education

Description

Here at One Education, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses.

Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Excel 2019 Introduction.

The certification that you will receive upon completing this Excel 2019 Introduction will help to boost your resume and will help you stand out among your peers in the competitive job market.

Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from One Education. Enrol now!

Course Benefits

Method of Assessment

To assess your learning, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate.

Certification

After completing the MCQ assessment, you will qualify for the CPD Certificate from One Education, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15.

Who is this course for?

This Excel 2019 Introduction is ideal for

Requirements

There are no specific prerequisites to enrol in this Excel 2019 Introduction. Anyone and everyone can take this course.

The Excel 2019 Introduction is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home!

All you need is a passion for learning, literacy, and to be over the age of 16.

Career path

This Excel 2019 Introduction will help you procure a job in the relevant field and will allow you to advance your career. Many job roles will be available for you to explore after completing this course. This Excel 2019 Introduction also increases your competency to be eligible for promotions at work.

Enrol now to this comprehensive course from One Education and take your career to the next step.

Course Curriculum

Introduction
Introduction 00:01:00
Section 01
What is Excel 00:04:00
Opening Excel 00:07:00
Navigating the Excel User Interface 00:10:00
Using the Excel Ribbon 00:07:00
Understanding Excel Worksheet Components 00:07:00
Using the Backstage View 00:09:00
Section 02
Creating a New Workbook 00:06:00
Creating Workbooks Using Templates 00:03:00
Saving an Excel Workbook 00:05:00
Using the Accessibility Checker 00:04:00
Section 03
Navigating a Worksheet by Mouse or Keyboard 00:05:00
Understanding Excel Data Types 00:06:00
Using the Inking Tools 00:06:00
Working with Cell and Range Addressing 00:03:00
Using various Data Selection Techniques 00:03:00
Working with Common Excel Commands 00:05:00
Using the Autofill Handle 00:04:00
Using Flash Fill 00:02:00
Section 04
What are Formulas and Functions 00:04:00
Understanding the Components of a Formula 00:06:00
Understanding Calculation Hierarchy and the Order of Operations 00:03:00
Creating Basic Formulas 00:03:00
Working with Basic Functions and AutoSum 00:06:00
Using Cell References 00:05:00
Using the Quick Analysis Tools 00:03:00
Section 05
Modifying Columns and Rows 00:06:00
Hiding and Unhiding Columns and Rows 00:04:00
Section 06
Formatting and Aligning Data 00:11:00
Merging Data 00:08:00
Wrapping Text and Adjusting Orientation 00:07:00
Formatting Numbers 00:08:00
Using Borders and Shading 00:07:00
Using the Format Painter 00:04:00
Removing Formatting Quickly 00:05:00
Section 07
Using Cell Styles 00:06:00
Applying Themes 00:04:00
Section 08
Inserting and Formatting Images 00:06:00
Inserting and Formatting Shapes 00:06:00
Inserting and Formatting SmartArt 00:09:00
Working with Icons 00:06:00
Working with 3-D Models 00:00:00
Inserting Screenshots 00:05:00
Inserting Hyperlinks 00:05:00
Inserting Symbols and Equations 00:05:00
Inserting WordArt and Text Boxes 00:08:00
Inserting Other Excel Objects 00:06:00
Arranging Objects 00:05:00
Section 09
Using Find and Replace 00:03:00
Using Go To and Go To Special 00:03:00
Using the Spell Checker 00:05:00
Using the Thesaurus and Translation Features 00:05:00
Section 10
Printing and Previewing Excel Files 00:05:00
Creating Custom Margins and Scaling 00:05:00
Adding Headers and Footers 00:05:00
Exporting to PDF and XPS 00:04:00
Section 11
Renaming and Coloring Worksheet Tabs 00:04:00
Adding, Deleting, and Navigating Worksheets 00:05:00
Section 12
Viewing Workbooks 00:05:00
Using Zoom Tools 00:02:00
Configuring Sheet Options 00:04:00
Using the Freeze Panes and Split Commands 00:06:00
Working with Window Commands 00:03:00
Adjusting Workbook Properties 00:06:00
Recap
Recap 00:01:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon