Microsoft Excel – Beginner to Advance Course - CPD Accredited
Spring Sale Now On | 14-in-1 Bundle| CPD Certified| 150 CPD Points| Gifts: Hardcopy + PDF Certificate + SID - Worth £180
Apex Learning
Summary
- Certificate of completion - Free
- Exam(s) / assessment(s) is included in price
- Tutor is available to students
Add to basket or enquire
Overview
This Microsoft Excel Training Bundle will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level.
Also, our Excel experts are available to answer your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.
Furthermore, to help you showcase your expertise in Excel, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.
This Bundle Consists of the following Premium courses:
- 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
Benefits you’ll get choosing Apex Learning:
- 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
How will I get my Certificate?
After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
- PDF Certificate: Free (For The Title Course)
- Hard Copy Certificate: Free (For The Title Course)
P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99.
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.
Certificates
Certificate of completion
Digital certificate - Included
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.
