Cart

No products in the basket.
LOGIN

Have You Already Joined IOMH ?

Fueling your journey to inspire, overcome, and motivate towards a brighter future. Join us today

Don’t have an account yet? Sign Up

Already have an account? Sign In

By signing up, I accept IOMH (Terms & Conditions)

Home
Course
Personal Development
IT & Software
Microsoft Excel 2019 - Beginner To Advance - Hide

For You
For Business

Microsoft Excel 2019 - Beginner To Advance - Hide

Learning Outcome Learn about the history and benefits of rational emotive behaviour therapy Gain complete mental mastery and reprogram your …

PRIVATE saleend

Level: Intermediate
Duration: 14 hours, 14 minutes
Modules: 196 Modules
Students: 3

PRIVATE COURSE ALL COURSES FOR £49

£11 /Unit Price

£110

Add to Cart

Buying more than one of the same courses?

45% discount for orders of 10+ courses
55% discount for orders of 50+ courses
65% discount for orders of 100+ courses

Overview

This Microsoft Excel 2019 – Beginner To Advance – Hide course will unlock your full potential and will show you how to excel in a career in Microsoft Excel 2019 – Beginner To Advance – Hide. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel 2019 – Beginner To Advance – Hide is available in this course.

Learning and progressing are the hallmarks of personal development. This Microsoft Excel 2019 – Beginner To Advance – Hide will quickly teach you the must-have skills needed to start in the relevant industry.

In This Mental Health Course, You Will:

Learn strategies to boost your workplace efficiency.
Hone your Mental Health skills to help you advance your career.
Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts.
Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career.

This Microsoft Excel 2019 – Beginner To Advance – Hide course covers everything you must know to stand against the tough competition in the Microsoft Excel 2019 – Beginner To Advance – Hide field.

The future is truly yours to seize with this Microsoft Excel 2019 – Beginner To Advance – Hide. Enrol today and complete the course to achieve a Microsoft Excel 2019 – Beginner To Advance – Hide certificate that can change your professional career forever.

Additional Perks of Buying a Course From Institute of Mental Health

Study online — whenever and wherever you want.
One-to-one support from a dedicated tutor throughout your course.
Certificate immediately upon course completion
100% Money back guarantee
Exclusive discounts on your next course purchase from Institute of Mental Health

Enrolling in the Microsoft Excel 2019 – Beginner To Advance – Hide course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.

Process of Evaluation

After studying the Microsoft Excel 2019 – Beginner To Advance – Hide course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.

Certificate of Achievement

Upon successfully completing the Microsoft Excel 2019 – Beginner To Advance – Hide course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.

Who Is This Course for?

This Microsoft Excel 2019 – Beginner To Advance – Hide is suitable for anyone aspiring to start a career in Microsoft Excel 2019 – Beginner To Advance – Hide; even if you are new to this and have no prior knowledge on Microsoft Excel 2019 – Beginner To Advance – Hide, this course is going to be very easy for you to understand.

And if you are already working in the Microsoft Excel 2019 – Beginner To Advance – Hide field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.

Taking this Microsoft Excel 2019 – Beginner To Advance – Hide course is a win-win for you in all aspects.

This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education.

Requirements

This Microsoft Excel 2019 – Beginner To Advance – Hide course has no prerequisite.

You don’t need any educational qualification or experience to enrol in the Microsoft Excel 2019 – Beginner To Advance – Hide course.

Do note: you must be at least 16 years old to enrol.

Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel 2019 – Beginner To Advance – Hide course.

Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills.

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