Microsoft Excel

What Will I Learn?

This Microsoft Excel bundle course you will be able to teach yourself excel from beginner level functions right to the complex formula programming related tasks by excel..

From the Microsoft Excel 2016 Introduction Course you will learn:

• To create simple worksheets
• Understand calculation hierarchy and the Order of Operations
• Format and align worksheet data
• Proof and print a workbook
• Use Functions in formulas
• Add columns and rows
• Use cell styles and themes
• Manage Worksheets

From the Microsoft Excel 2016 Intermediate course you will learn:

• Custom Excel
• Work with Range Names
• Analyze Data with Common Lookup Functions
• Analyze and Organize with Tables
• Outline with Subtotals and Grouping
• Work with Date and Time Functions
• Link Workbooks and Worksheets
• Analyze Data with Common Logical Functions
• Sort and Filter Range Data
• Use Conditional Formatting
• Display Data Graphically
• Work with Flash Fill
• Work with Common Text Functions

From the Microsoft Excel 2016 Advanced course you will learn:

• Use Advanced IF Statements
• Use Advanced Lookup Functions
• Use Complex Logical and Text Functions
• Auditing Formulas
• Working with What-If Analysis Tools
• Protecting Worksheet and Workbook
• Use Advanced PivotTables and PowerPivot Tools
• Automate with Macros
• Work with Form Controls
• Ensure Data Integrity
• Import and Export Data to a Text File

Microsoft Excel Complete Training (Beginner, Intermediate, Advanced) Bundle is a best-selling course bundle developed by industry experts and it has already helped tons of students like you. It is suitable for anyone who wants to improve or gain fantastic skills in Microsoft Excel.

Microsoft Excel is the world’s most popular spreadsheet and data visualisation tool. Almost every company uses it on a day to day basis, so learning how to use it and being an expert in it will significantly improve your employability and it has become a must-have skill nowadays.

Enrol now in this all in one bundle and start mastering Microsoft Excel today.

The courses in this bundle are accredited by CPD, so you will get a career boost upon completing this course. Our Microsoft Excel Complete Training (Beginner, Intermediate, Advanced) Bundle is packed with several information-rich modules that break down each topic for easy understanding.

After completing the course you will be awarded a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.

We know that you are busy and your time is very important, so to make our learners feel at ease we have designed this course for any type of student and you can complete it at your own pace. The course materials are accessible from anyplace, from any device and at any time.

And lastly, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Course Curriculum

Microsoft Excel 2016 Introduction

Introduction

• Introduction

Getting Started with Excel

• What is Excel
• Opening Excel

Creating Workbooks and Using Templates

• Creating a New Workbook
• Creating Workbooks Using Templates

Entering Data

• Navigating a Worksheet by Mouse or Keyboard
• Excel Data Types

Excel Formula Basics Data

• What are Formulas and Functions
• Using the Quick Analysis Tool

Adjusting a Worksheet

• Modifying Columns and Rows
• Hiding and Unhiding Columns and Rows

Formatting and Aligning Worksheet Data

• Formatting and Aligning Data
• Removing Formatting Quickly

Using Cell Styles and Themes

• Understanding Cell Styles
• Applying Cell Styles

Inserting Objects and Graphics

• Inserting and Formatting Images
• Inserting and Formatting Shapes

Proofing a Workbook

• Using Find and Replace
• Finding and Replacing Formatting

Printing an Excel File

• Printing and Previewing Excel Files
• Creating Custom Margins and Scaling

Managing Worksheets

• Renaming and Coloring Worksheet Tabs
• Adding, Deleting, and Navigating Worksheets

Navigating and Viewing Excel Files

• Viewing Workbooks
• Using Zoom Tools

Conclusion

• Course Recap

***Microsoft Excel 2016 Intermediate***

Introduction

• Introduction

Customizing Excel

• Customizing the Ribbon
• Customizing the Quick Access ToolBar

Linking Workbooks and Worksheets

• Linking Workbooks and Worksheets
• Linking Worksheets with 3D References

Working with Range Names and Advanced Formulas

• What are Range Names
• Creating Range Names Using Create from Selection

Analyzing Data with Common Logical Functions

• Working with the Most Common Logical Functions
• Evaluate Data with the AND Function

Analyzing Data with Common Lookup Functions

• What are Lookup Functions
• Using VLookup

Sorting and Filtering Range Data

• Differences Between Sorting & Filtering
• Sorting Lists

Analyzing and Organizing with Tables

• Creation and Benefits of a Table
• Elements of a Table

Using Conditional Formatting

• What is Conditional Formatting
• Conditional Formatting and Highlight Cells and Top Bottom Rules

Outlining with Subtotals and Grouping

• What are Subtotals and Grouping
• Creating Subtotals

Displaying Data Graphically

• What are Charts
• Creating Charts

Understanding PivotTables and PivotCharts and Filtering with Slicers

• What is a Pivot Table
• Creating a Pivot Table

Working with Flash Fill

• What is Flash Fill
• Using Flash Fill and Autofill

Working with Date and Time Functions

• What are Date and Time Functions-
• Using TODAY, NOW, and DAY Functions

Working with Common Text Functions

• What are Text Functions
• Using UPPER, LOWER, & PROPER Functions

Conclusion

• Course Recap

***Microsoft Excel 2016 Advanced***

Introduction

• Introduction

Using Advanced IF Statements

• Summarize Data with SUMIF
• Summarize Data with AVERAGIF

Using Advanced Lookup Functions

• Using VLOOKUP with TRUE to find an Approximate Match
• Using HLOOKUP TRUE to find an Approximate Match

Using Complex Logical and Text Functions

• Creating a Nested IF Function
• Using the IFERROR Function

Formula Auditing

• Showing Formulas
• Tracing Cell Precedents and Dependents

What-If Analysis Tools

• Using the Scenario Manager
• Using Goal Seek

Worksheet and Workbook Protection

• Protection Overview
• Excel File Password Encryption

Advanced Use of PivotTables and PowerPivot

• Using the Pivot Tables Charts Wizard

Automating with Macros

• What are Macros

Working with Form Controls

• What are Form Controls

Ensuring Data Integrity

• What is Data Validation

Collaborating in Excel

• Working with Comments

Importing and Exporting Data to a Text File

• Importing a Text File

Conclusion

• Course Recap

Certification

Complete your course by sitting for an MCQ assessment. To pass the test, you need to achieve 60% or higher in the final assessment. After passing, you will be able to get the UK and internationally recognised certificate to share your achievement with potential employers or to include it in your CV. The PDF certificate is totally free, or you can get a a physical version of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

This course bundle is great for:

• Students
• Recent graduates
• Job seekers
• Those looking to learn an in-demand skill and improve their earning potential

• Basic knowledge of operating a computer
• Microsoft Excel software