Microsoft Excel 2019 - Beginner To Advance

Course Overview Learn how to make a genuine difference in your life by taking our popular Microsoft Excel 2019 – …

Microsoft Excel 2019 - Beginner To Advance

PRIVATE

Exclusive Deal! nan% Off, Today Only!

PRIVATE COURSE

1 Year Access
Advanced
7 Students
14 hours, 19 minutes

Buy 1 or more contact sale

PRIVATE
1 year
Advanced, Beginner, Intermediate
Number of Units196
Number of Quizzes0
14 hours, 19 minutes

14-Day Money-Back Guarantee

Course Overview

Learn how to make a genuine difference in your life by taking our popular Microsoft Excel 2019 – Beginner To Advance. Our commitment to online learning and our technical experience has been put to excellent use within the contents of these educational modules. By enrolling today, you can take your knowledge of Microsoft Excel 2019 – Beginner To Advance
to a whole new level and quickly reap the rewards of your study in the field you have chosen.

We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.

Please note that Microsoft Excel 2019 provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practices. Always check details with the appropriate authorities or management.

Learning Outcomes

Instant access to verified and reliable information
Participation in inventive and interactive training exercises
Quick assessment and guidance for all subjects
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

Your Path to Success

By completing the training in Microsoft Excel 2019 – Beginner To Advance you will be able to significantly demonstrate your acquired abilities and knowledge of Microsoft Excel 2019 – Beginner To Advance. This can give you an advantage in career progression, job applications, and personal mastery in this area.

Is This Course Right for You?

This course is designed to provide an introduction to Microsoft Excel 2019 – Beginner To Advance and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported and it can take just 20 to 30 hours to gain accreditation, with study periods being entirely customisable to your needs.

Assessment Process

Once you have completed all the modules in the Microsoft Excel 2019 – Beginner To Advance course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.

Show off Your New Skills with a Certification of Completion

The learners have to successfully complete the assessment of this Microsoft Excel 2019 – Beginner To Advance course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.

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
	Applying Conditional Formatting to a PivotTable	00:04: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 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 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:03: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:03:00
	Adding Spin Buttons and Check Boxes	00:05:00
	Adding a Combo Box	00:04:00
Section 11
	What is Data Validation	00:02: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:02: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:02: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