Microsoft Excel 2019 - Beginner To Advance | Online Course & Certification

Home
Course
Hidden Course
Microsoft Excel 2019 - Beginner To Advance

Microsoft Excel 2019 - Beginner To Advance

Level: Advanced
Modules: 196 Modules
Duration: 14 hours, 13 minutes
Students: 2

Overview

Uplift Your Career & Skill Up to Your Dream Job – Learning Simplified From Home!

Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Microsoft Excel 2019 – Beginner To Advance Course. You’ll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today’s workplaces.

The Microsoft Excel 2019 – Beginner To Advance Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Excel 2019 – Beginner To Advance Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field.

This Microsoft Excel 2019 – Beginner To Advance Course, like every one of Study Hub’s courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly.

At StudyHub, we don’t just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support.

Why buy this Microsoft Excel 2019 – Beginner To Advance?

Unlimited access to the course for forever
Digital Certificate, Transcript, student ID all included in the price
Absolutely no hidden fees
Directly receive CPD accredited qualifications after course completion
Receive one to one assistance on every weekday from professionals
Immediately receive the PDF certificate after passing
Receive the original copies of your certificate and transcript on the next working day
Easily learn the skills and knowledge from the comfort of your home

Certification

After studying the course materials of the Microsoft Excel 2019 – Beginner To Advance there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.

Who is this course for?

This Microsoft Excel 2019 – Beginner To Advance course is ideal for

Students
Recent graduates
Job Seekers
Anyone interested in this topic
People already working in the relevant fields and want to polish their knowledge and skill.

Prerequisites

This Microsoft Excel 2019 – Beginner To Advance does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel 2019 – Beginner To Advance was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Career path

As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Excel 2019 – Beginner To Advance is a great way for you to gain multiple skills from the comfort of your home.

Course Curriculum

Downloadable Resources
	Resources – Microsoft Excel 2019 – Beginner to Advance	00:00:00
*Excel 2019 Introduction*
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
*Excel 2019 Intermediate*
Intro
	Introduction	00:01:00
Section 01
	Linking Worksheets and Workbooks	00:07:00
	Linking Worksheets with 3D References	00:05:00
	Understanding the Consolidate Feature	00:06:00
Section 02
	What are Range Names	00:06:00
	Creating Range Names Using the Name Box and Define Name	00:06:00
	Creating Range Names Using Create from Selection	00:03:00
Section 03
	Understanding the Differences Between Sorting and Filtering	00:03:00
	Sorting Lists	00:07:00
	Filtering Lists	00:06:00
	Creating Subtotals	00:05:00
Section 04
	Creating Tables and Understanding the Benefits	00:06:00
	Understanding the Elements of a Table	00:05:00
	Formatting a Table	00:05:00
	Sorting and Filtering Tables	00:04:00
	Filtering with Slicers	00:07:00
	Calculating with Tables	00:06:00
	Removing Erroneous Table Data	00:05:00
	Exporting, Refreshing, and Converting Tables	00:05:00
Section 05
	What is Conditional Formatting	00:03:00
	Conditional Formatting-HIghlight Cells and Top Bottom Rules	00:06:00
	Conditional Formatting-Data Bars, Icon Sets, and Color Scales	00:06:00
	Using Custom Fonts and Colors	00:03:00
	Using Custom Conditional Formatting	00:05:00
	Modyfing or Removing Conditional Formatting	00:04:00
Section 06
	What are Charts	00:06:00
	Forecasting with Trendlines	00:05:00
	Creating a Chart Template	00:04:00
	Displaying Trends with Sparklines	00:08:00
	Creating Charts	00:05:00
	Understanding Chart Elements	00:05:00
	Modifying Chart Elements	00:05:00
	Changing and Moving Charts	00:03:00
	Filtering a Chart	00:04:00
	Formatting Charts	00:13:00
	Adjusting Numbering	00:06:00
	Creating Dual Axis Charts	00:05:00
Section 07
	What is a PivotTable	00:05:00
	Creating a PivotTable	00:07:00
	Working with the PivotTable Fields Pane	00:10:00
	Basic Data Organization and Analysis with PivotTables	00:08:00
	Formatting PivotTables	00:05:00
	Creating a PivotChart	00:04:00
	Modifying and Formatting a PivotChart	00:04:00
	Using Slicers and Timeline Slicers	00:08:00
Section 08
	Using the PivotTable and PivotChart Wizard	00:03:00
	Adding a Calculated Field	00:04:00
	Adding a Calculated Item	00:04:00
	Applying Conditional Formatting to a PivotTable	00:04:00
	Creating Filter Pages for a PivotTable	00:04:00
	Enabling the PowerPivot Add-in	00:11:00
Recap
	Recap	00:02:00
*Excel 2019 Advanced*
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 Function1	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