Microsoft Excel - Beginner to Advance Course - CPD Accredited

Course 01: Microsoft Excel Level 3

Course 02: New Functions in Microsoft Excel 2021

Course 03: Microsoft Excel Sheet Comparison with VBA

Course 04: Top 50 Microsoft Excel Formulas in 50 Minutes!

Course 05: Microsoft Excel Master Power Query in 120 Minutes!

Course 06: Microsoft Excel Automated Dashboard Using Advanced Formula, VBA, Power Query

Course 07: Financial Modeling Using Excel

Course 08: Business Analysis Level 3

Course 09: Touch Typing Essentials

Course 10: Information Management

Course 11: Data Protection and Data Security Level 2

Course 12: Microsoft Teams

Course 13: Office Skills and Administration Management Diploma

Course 14: Creativity and Problem-Solving Skills

One payment, but lifetime access to 14 CPD courses

Certificates, student ID for the title course included in a one-time fee

Full tutor support available from Monday to Friday

Free up your time - don't waste time and money travelling for classes

Accessible, informative modules taught by expert instructors

Learn at your ease - anytime, from anywhere

Study the course from your computer, tablet or mobile device

CPD accredited course - improve the chance of gaining professional skills

PDF Certificate: Free (For The Title Course)

Hard Copy Certificate: Free (For The Title Course)

Microsoft 019 New Features

Getting Started

Performing Calculations

Modifying a Worksheet

Formatting a Worksheet

Printing Workbooks

Managing Workbooks

Working with Functions

Working with Lists

Analyzing Data

Visualizing Data with Charts

Using PivotTables and Pivot Charts

Working with Multiple Worksheets and Workbooks

Using Lookup Functions and Formula Auditing

Sharing and Protecting Workbooks

Automating Workbook Functionality

Creating Sparkline's and Mapping Data

Forecasting Data

Templates

Introduction and Agenda

RANDARRAY

UNIQUE

SEQUENCE

SORT and SORTBY

SORT A Practical Example

FILTER

FILTER A Practical Example

Other Useful New Functions

Using the New Functions in Reports

Introduction to Compare Data Workbook

Comprehensive Introduction to Compare Data Excel VBA Workbook

Modify VBA Codes to Suit Your Needs

Data Cleaning, Format and Structure Your Datasets with Power Query

Practical and Real world application of Compare Data Workbook

Conclusion

promo

Getting the most of the course

How to Get the most of the course

Text formulas

Text Formulas Exercise

Text Formulas Exercise (answers)

Power Query Intro and version

Introduction

Query Editor Ribbon

Trim in Excel Power Query

Format Dates and Values

Introduction

Prepaid Expenses Models: Resources Download

Accounting for Prepaid Expenses

Formulas Detailed: Introduction to three Models

Welcome to the Course! Get the Overview of What You'll Learn

Planning your Financial Model

Building a Model Template

Projecting the Income Statement

Introduction to Business Analysis

Business Processes

Business Analysis Planning and Monitoring

Strategic Analysis and Product Scope

Solution Evaluation

Introduction

How to Set up Your Computer

How to type the letters F and J

How to type the letters D and K

How to type the letters S and L

How to type the letter A and ; (semicolon)

How to type the letters E and I

Introduction to Information Management

Information Management Strategy

Databases and Information Management

Management Information Systems (MIS)

Auditing Information Systems

Ethical and Social Issues and Data Protection

GDPR Basics

GDPR Explained

Lawful Basis for Preparation

Rights and Breaches

Responsibilities and Obligations

MS Teams - Introduction

Mastering MS Teams

Top MS Teams Tips

Personal Assistant

Admin Support

Administrative Management

Organisational Skills

Telephone Etiquette