Excel 2019 Introduction
Excel 2019 Introduction
PRIVATE
Save nan % - NEW YEAR SALE
OR
Or
Take All courses for £49
1 Year Access 
Intermediate
1 Students -
5 hours, 29 minutes
Get access to 5000+ courses including this for
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
- Instantly accessible CPD-accredited certificate on successful completion of this Excel 2019 Introduction
- 24/7 access to the course for 12 months
- Study at your own pace
- No hidden fees or exam charges
- Full Tutor support on weekdays (Monday – Friday)
- Efficient assessment and instant results
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
- Instant access to information about scientific investigation techniques
- Full participation in crime detection exercises
- Quick assessment and guidance for all assignments
- CPD accreditation for proof of acquired skills and knowledge
- Freedom to study in any location and at a pace that suits you
- Expert support from dedicated tutors committed to online learning
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
- Students
- Recent graduates
- Job Seekers
- Anyone interested in this topic
- People already working in this field and aspiring to polish their knowledge and skill.
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 | ||
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
