• LOGIN
  • No products in the basket.

Register on the Microsoft Excel 2019 – Beginner to Advance today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career.

The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials.

Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a free e-certificate as proof of your course completion.

The Microsoft Excel 2019 – Beginner to Advance is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones.

The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly!

What You Get With The Microsoft Excel 2019 – Beginner to Advance
  • Receive a free e-certificate upon successful completion of the course
  • Get taught by experienced, professional instructors
  • Study at a time and pace that suits your learning style
  • Get instant feedback on assessments 
  • 24/7 help and advice via email or live chat
  • Get full tutor support on weekdays (Monday to Friday)

Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Certification

Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Who Is This Course For:

The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.

Requirements:

The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel 2019 – Beginner to Advance, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. 

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:06: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 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

Course Reviews

4.9

4.9
13 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Microsoft Excel 2019 - Beginner to Advance

£320
£20
TAKE THIS COURSE
OR all courses for £49

tick2000+ Premium Courses

tickGlobally Recognised

 

 

0
Your Cart
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]