Microsoft Excel – Beginner to Advance Course - CPD Accredited
Apex Learning
Year-End Sale | 14-in-1 Bundle| CPD Certified| 150 CPD Points| Gifts: Hardcopy + PDF Certificate + SID - Worth £180
Summary
- Certificate of completion - Free
- Assessment (included in price)
- Tutor is available to students
Add to basket or enquire
Overview
Certificates
Certificate of completion
Digital certificate - Included
Assessment details
Assessment
Included in course price
CPD
Course media
Description
Curriculum of Bundle
Course 01: Microsoft Excel Level 3
- 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
Course 02: New Functions in Microsoft 021
- 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
Course 03: Microsoft Excel Sheet Comparison with VBA
- 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
Course 04: Top 50 Microsoft Excel Formulas in 50 Minutes!
- promo
- Getting the most of the course
- How to Get the most of the course
- Text formulas
- Text Formulas Exercise
- Text Formulas Exercise (answers)
and many more...
Course 05: Microsoft Master Power Query in 120 Minutes!
- Power Query Intro and version
- Introduction
- Query Editor Ribbon
- Trim in Excel Power Query
- Format Dates and Values
and many more...
Course 06: Automated Dashboard Using Advanced Formula, VBA, Power Query
- Introduction
- Prepaid Expenses Models: Resources Download
- Accounting for Prepaid Expenses
- Formulas Detailed: Introduction to three Models
and many more...
Course 07: Financial Modeling Using Excel
- Welcome to the Course! Get the Overview of What You’ll Learn
- Planning your Financial Model
- Building a Model Template
- Projecting the Income Statement
and many more...
Course 08: Business Analysis Level 3
- Introduction to Business Analysis
- Business Processes
- Business Analysis Planning and Monitoring
- Strategic Analysis and Product Scope
- Solution Evaluation
and many more...
Course 09: Touch Typing Essentials
- 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
And Many More...
Course 10: Information Management
- 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
Course 11: Data Protection and Data Security Level 2
- GDPR Basics
- GDPR Explained
- Lawful Basis for Preparation
- Rights and Breaches
- Responsibilities and Obligations
Course 12: Microsoft Teams
- MS Teams - Introduction
- Mastering MS Teams
- Top MS Teams Tips
Course 13: Office Skills and Administration Management Diploma
- Personal Assistant
- Admin Support
- Administrative Management
- Organisational Skills
- Telephone Etiquette
and many more...
Course 14: Creativity and Problem Solving Skills
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Add to basket or enquire
Course provided by
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
