Booking options
£11.99
Course Images
Excel 2019 Introduction
By Course Gate
(1)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
5 hours 34 minutes
All levels
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?
Excel 2019 Introduction 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 Excel 2019 Introduction 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 |
About The Provider
Course Gate
London
(1)Welcome to Course Gate, your gateway to a world of knowledge and oppo...
Reviews
There are no reviews for Excel 2019 Introduction yet.Why not be the first one to review this course?