Excel 2019 Introduction

4.8( 9 REVIEWS )
1 STUDENTS

Excel 2019 Introduction

4.8( 9 REVIEWS )
1 STUDENTS

GET LIFETIME ACCESS TO ALL OUR COURSES FOR ONLY £199 £99 GET NOW

Excel 2019 Introduction Take This Course

Description

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You’ll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience.

Who is this course for?

[course_title] is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don’t have to worry about the quality.

Requirements

Our [course_title] is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.

CPD Certificate from Course Gate

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.

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:05: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
Certificate and Transcript
Order Your Certificates or Transcripts 00:00:00
Excel 2019 Introduction

Course Reviews

4.8

4.8
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.


Excel 2019 Introduction Take This Course

Share Link on svg

Instructors

£11 /Unit Price
£110
Quantity:

Buying more than one of the same courses?

  • 45% discount for orders of 10+ courses
  • 55% discount for orders of 50+ courses
  • 65% discount for orders of 100+ courses

Looking for a more personalised package?

contact us now

© Course Gate Edukite Ltd, Reg no: 11378092

0
Your Cart

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49.00per year

ADD OFFER TO CART

No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.