• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel

Microsoft Excel

By Studyhub UK

4.5(3)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 22 hours 49 minutes

  • All levels

Description

The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA.

Learning Outcomes:
  1. Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more.

  1. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands.

  1. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively.

  1. Format worksheets, apply conditional formatting, and utilize templates to present data professionally.

  1. Understand data visualization using charts, sparklines, and mapping techniques in Excel.

  1. Work with PivotTables and PivotCharts for in-depth data analysis and presentation.

  1. Learn advanced Excel features such as data validation, scenarios, and Goal Seek.

  1. Automate workbook functionality using macros and Visual Basic for Applications (VBA).

  1. Collaborate on workbooks, protect data, and apply security measures in Excel.

  1. Create and work with Excel templates to streamline repetitive tasks and optimize workflow.

Why buy this Microsoft Excel?
  1. Unlimited access to the course for forever

  1. PDF Certificate, Transcript, student ID all included in the price

  1. Absolutely no hidden fees

  1. Directly receive CPD accredited qualifications after course completion

  1. Receive one to one assistance on every weekday from professionals

  1. Immediately receive the PDF certificate after passing

  1. Receive the original copies of your certificate and transcript on the next working day

  1. Easily learn the skills and knowledge from the comfort of your home

Certification

After studying the course materials of the Microsoft Excel you will be able to take the MCQ test that will assess your knowledge. 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 does not require you to have any prior qualifications or experience. You can just enrol and start learning.

Prerequisites

This Microsoft Excel 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 is a great way for you to gain multiple skills from the comfort of your home.

Course Curriculum

Microsoft Excel 2019 New Features

Introduction to Microsoft Excel 2019 New Features

00:07:00

CONCAT

00:02:00

IFS

00:01:00

MAXIFS

00:01:00

MINIFS

00:01:00

SWITCH

00:02:00

TEXTJOIN

00:01:00

Map Chart

00:02:00

Funnel Chart

00:01:00

Better Visuals

00:06:00

Pivot Table Enhancements

00:02:00

Power Pivot Updates

00:01:00

Getting Started with Microsoft Office Excel

Navigate the Excel User Interface

00:28:00

Use Excel Commands

00:10:00

Create and Save a Basic Workbook

00:19:00

Enter Cell Data

00:12:00

Use Excel Help

00:05:00

Performing Calculations

Create Worksheet Formulas

00:15:00

Insert Functions

00:17:00

Reuse Formulas and Functions

00:17:00

Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows

00:10:00

Search for and Replace Data

00:09:00

Use Proofing and Research Tools

00:07:00

Formatting a Worksheet

Apply Text Formats

00:16:00

Apply Number Format

00:08:00

Align Cell Contents

00:09:00

Apply Styles and Themes

00:12:00

Apply Basic Conditional Formatting

00:11:00

Create and Use Templates

00:08:00

Printing Workbooks

Preview and Print a Workbook

00:10:00

Set Up the Page Layout

00:09:00

Configure Headers and Footers

00:07:00

Managing Workbooks

Manage Worksheets

00:05:00

Manage Workbook and Worksheet Views

00:07:00

Manage Workbook Properties

00:06:00

Working with Functions

Work with Ranges

00:18:00

Use Specialized Functions

00:11:00

Work with Logical Functions

00:23:00

Work with Date & Time Functions

00:08:00

Work with Text Functions

00:11:00

Working with Lists

Sort Data

00:10:00

Filter Data

00:10:00

Query Data with Database Functions

00:09:00

Outline and Subtotal Data

00:09:00

Analyzing Data

Apply Intermediate Conditional Formatting

00:07:00

Apply Advanced Conditional Formatting

00:05:00

Visualizing Data with Charts

Create Charts

00:13:00

Modify and Format Charts

00:12:00

Use Advanced Chart Features

00:12:00

Using PivotTables and PivotCharts

Create a PivotTable

00:13:00

Analyze PivotTable Data

00:12:00

Present Data with PivotCharts

00:07:00

Filter Data by Using Timelines and Slicers

00:11:00

Working with Multiple Worksheets and Workbooks

Use Links and External References

00:12:00

Use 3-D References

00:06:00

Consolidate Data

00:05:00

Using Lookup Functions and Formula Auditing

Use Lookup Functions

00:12:00

Trace Cells

00:09:00

Watch and Evaluate Formulas

00:08:00

Sharing and Protecting Workbooks

Collaborate on a Workbook

00:19:00

Protect Worksheets and Workbooks

00:08:00

Automating Workbook Functionality

Apply Data Validation

00:13:00

Search for Invalid Data and Formulas with Errors

00:04:00

Work with Macros

00:18:00

Creating Sparklines and Mapping Data

Create Sparklines

00:07:00

MapData

00:07:00

Forecasting Data

Determine Potential Outcomes Using Data Tables

00:08:00

Determine Potential Outcomes Using Scenarios

00:09:00

Use the Goal Seek Feature

00:04:00

Forecasting Data Trends

00:05:00

Excel VBA Data Management

Create a Macro Using the Macro Recorder

01:00:00

Edit a Macro

01:00:00

Debug a Macro

00:30:00

Customize the Quick Access Toolbar and Hotkeys

00:30:00

Set Macro Security

01:00:00

Insert Text

00:30:00

Format Text

00:30:00

Sort Data

00:30:00

Duplicate Data

01:00:00

Generate a Report

01:00:00

Determine the Dialog Box Type

00:15:00

Capture User Input

01:00:00

Insert, Copy, and Delete Worksheets

00:30:00

Rename Worksheets

00:30:00

Modify the Order of Worksheets

00:15:00

Print Worksheets

00:30:00

Create User-Defined Functions

00:30:00

Automate SUM Functions

00:30:00

Activities and Exercise Files - Microsoft Excel 2016 and VBA

00:00:00

Excel Templates

Excel Templates

00:00:00

Mock Exam

Mock Exam - Microsoft Excel

00:20:00

Final Exam

Final Exam - Microsoft Excel

00:20:00

About The Provider

Studyhub UK
Studyhub UK
London, England
4.5(3)

Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated...

Read more about Studyhub UK

Tags

Reviews