-
Cart
1
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Excel 2019 Advanced
Excel 2019 Advanced
PRIVATE
PRIVATE COURSE OR
1 Year Access 
Intermediate
5 Students -
4 hours, 2 minutes
get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer
Overview
Become an expert in data analysis with the Excel 2019 Advanced masterclass.
This instructor-led video course will take you through all the advanced functions, features and tools of the 2019 version of Excel. Through step-by-step guidance, you will learn how to perform a range of procedures that will give you a competitive advantage in any office role. From automating tasks with macros, to sorting and filtering data, this course provides straightforward instructions that will help you to gain full proficiency in no time.
What’s more, you will learn how to track changes and share your work with your team, as well as merge workbooks, for easy collaboration and project management. This course is ideal for those who have a basic to intermediate working knowledge of Excel, who wish to reach an advanced level.
Why People Love and Enrol in The Excel 2019 Advanced from One Education
- Instantly accessible CPD-accredited certificate on successful completion of this Excel 2019 Advanced
- 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 Advanced.
The certification that you will receive upon completing this Excel 2019 Advanced 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 Advanced 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 Advanced. Anyone and everyone can take this course.
The Excel 2019 Advanced 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 Advanced 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 Advanced 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 | |||
| Customizing the Ribbon | 00:07:00 | ||
| Customizing the Quick Access Toolbar | 00:05:00 | ||
| Customizing the General and Formula Options | 00:05:00 | ||
| Customizing the AutoCorrect Options | 00:03:00 | ||
| Customizing the Save Defaults | 00:03:00 | ||
| Customizing Advanced Excel Options | 00:03:00 | ||
| Section 02 | |||
| Working with Common Logical Functions | 00:02:00 | ||
| Understanding IF Functions | 00:03:00 | ||
| Evaluating Data with the AND Function | 00:05:00 | ||
| Evaluating Data with the OR Function | 00:03:00 | ||
| Creating a Nested IF Function | 00:06:00 | ||
| Using the IFS Function | 00:03:00 | ||
| Summarizing Data with SUMIF | 00:04:00 | ||
| Summarizing Data with AVERAGEIF | 00:02:00 | ||
| Summarizing Data with COUNTIF | 00:02:00 | ||
| Summarizing Data with MAXIFS and MINIFS | 00:03:00 | ||
| Using the IFERROR Function | 00:05:00 | ||
| Section 03 | |||
| What are Lookup Functions | 00:02:00 | ||
| Using VLOOKUP | 00:07:00 | ||
| Using HLOOKUP | 00:02:00 | ||
| Using VLOOKUP with TRUE | 00:04:00 | ||
| Using HLOOKUP with TRUE | 00:01:00 | ||
| Using the INDEX Function | 00:03:00 | ||
| Using the MATCH Function | 00:02:00 | ||
| Combining INDEX and MATCH | 00:05:00 | ||
| Comparing Two Lists with VLOOKUP | 00:02:00 | ||
| Comparing Two Lists with VLOOKUP and ISNA | 00:05:00 | ||
| Section 04 | |||
| What are Text Functions | 00:02:00 | ||
| Using Concat Concatenate and Textjoin | 00:06:00 | ||
| Using Text to Columns | 00:02:00 | ||
| Using Left Right and Mid | 00:03:00 | ||
| Using UPPER, LOWER, and PROPER Functions | 00:02:00 | ||
| Using the LEN Function | 00:03:00 | ||
| Using the TRIM Function | 00:02:00 | ||
| Using the SUBSTITUTE Function | 00:03:00 | ||
| Section 05 | |||
| What are Date and Time Functions | 00:01:00 | ||
| Using TODAY, NOW, and DAY Functions | 00:02:00 | ||
| Using NETWORKDAYS and YEARFRAC Functions | 00:04:00 | ||
| Section 06 | |||
| Showing Formulas | 00:02:00 | ||
| Tracing Precedents and Dependents | 00:03:00 | ||
| Adding a Watch Window | 00:03:00 | ||
| Error Checking | 00:03:00 | ||
| Section 07 | |||
| Using the Scenario Manager | 00:05:00 | ||
| Using Goal Seek | 00:03:00 | ||
| Analyzing with Data Tables | 00:03:00 | ||
| Section 08 | |||
| Understanding Protection | 00:03:00 | ||
| Encrypting Files with Passwords | 00:06:00 | ||
| Allowing Specific Worksheet Changes | 00:03:00 | ||
| Adding Protection to Selected Cells | 00:03:00 | ||
| Section 09 | |||
| What are Macros | 00:03:00 | ||
| Displaying the Developer Tab | 00:03:00 | ||
| Creating a Basic Formatting Macro | 00:07:00 | ||
| Running a Macro | 00:03:00 | ||
| Assigning a Macro to a Button | 00:03:00 | ||
| Creating Complex Macros and Editing the VBA Code | 00:09:00 | ||
| Adding a Macro to the Quick Access Toolbar | 00:02:00 | ||
| Section 10 | |||
| What are Form Controls | 00:02:00 | ||
| Adding Spin Buttons and Check Boxes | 00:05:00 | ||
| Adding a Combo Box | 00:04:00 | ||
| Section 11 | |||
| What is Data Validation | 00:01:00 | ||
| Restricting Data Entry to Whole Numbers | 00:02:00 | ||
| Restricting Data Entry to a List | 00:02:00 | ||
| Restricting Data Entry to a Date | 00:01:00 | ||
| Restricting Data Entry to a Specific Text Length | 00:01:00 | ||
| Composing Input Messages | 00:02:00 | ||
| Composing Error Alerts | 00:02:00 | ||
| Finding Invalid Data | 00:02:00 | ||
| Editing and Deleting Validation Rules | 00:02:00 | ||
| Section 12 | |||
| Working with Comments | 00:03:00 | ||
| Printing Comments and Errors | 00:02:00 | ||
| Sharing a Workbook | 00:03:00 | ||
| Tracking Changes in a Workbook | 00:04:00 | ||
| Working with Versions | 00:01:00 | ||
| Sharing Files | 00:02:00 | ||
| Section 13 | |||
| Importing a Text File | 00:04:00 | ||
| Exporting Data to a Text File | 00:01:00 | ||
| Recap | |||
| Recap | 00:01:00 | ||
Related Courses
Intermediate
Intermediate
Intermediate
COPYRIGHT © 2022 One Education
1
- Item added to cart
1
Your Cart
Gain Access To All Courses For A Year
Qty: 1
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add