cert

Complete Microsoft Excel Diploma: Beginner to Advanced Training

Microsoft Excel is the world’s leading spreadsheet, used for carrying out a vast range of office administrative duties. This program …

Complete Microsoft Excel Diploma: Beginner to Advanced Training

Complete Microsoft Excel Diploma: Beginner to Advanced Training

$35.30

TAKE THIS COURSE

are
are
are
clender

1 Year Access

teacher

144 Students

durantion

10 hours, 52 minutes

Gift this course

Microsoft Excel is the world’s leading spreadsheet, used for carrying out a vast range of office administrative duties. This program allows you to automate tasks, manage and present data, make calculations, and much more. To stand out to prospective employers, aspiring professionals must have excellent proficiency in Excel. It is easy to get a solid understanding from Beginner to Advanced level key functions from this Microsoft Excel Diploma Course. 

The Complete Microsoft Excel Diploma: Beginner to Advanced Training course, is the ultimate training program for anyone looking to develop their administrative skills in Excel. Designed for learners of all levels, it covers key topics such as how to create worksheet formulas, modify tables, and use macros – with step-by-step guidance. You will learn how to navigate the Excel user interface and use Excel commands with confidence, sort and filter data and automate everyday work tasks.

In addition, this course will walk you through each feature of Excel 2019, developing your proficiency and skill to take you from complete beginner to expert in no time. For instance, gain valuable transferable skills required for roles. After that, get a certificate in just 20/30 hours.

The course is suitable for both part-time and full-time students. Learn with the freedom to study at your own pace, from any device with an internet connection.

Learning Outcomes of Complete Microsoft Excel Diploma Training:

  • Fully familiarise with the new features and functions of Microsoft Excel 2019
  • Know how to navigate the Excel user interface and use Excel commands
  • Get step-by-step guidance on how to create worksheet formulas and manage workbook properties 
  • Understand how to insert, delete, and adjust cells, column and rows
  • Learn how to apply conditional formatting and work with ranges and charts
  • Discover how to sort, filter and query data with database functions
  • Understand how to create and modify tables, use lookup functions and apply data validation
  • Learn how to automate everyday work tasks using the macro recorder

Assessment and Certification

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. However, if you fail the exam, you can retake it for £1.99.

Career Path

Lastly, when you have successfully completed this course, you will receive a recognised certificate of achievement. This certificate will add valuable credentials to your CV and boost your earning potential in any administrative role. So, you get the in-demand transferable skills required for a range of professions, such as the following:

  • Administrative Assistant
  • Data Administrator
  • Accountant/Bookkeeper
  • Information Analyst
  • Data Entry Clerk

In conclusion, a recommendation for you to learn Microsoft Excel: Enrol this Microsoft Excel Diploma Course. What are you waiting for?

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
Beginner Level
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
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
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
Apply Text Formats 00:17:00
Apply Number Formats 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:07:00
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:08:00
Configure Headers and Footers 00:07:00
Manage Worksheets 00:05:00
Manage Workbook and Worksheet Views 00:07:00
Manage Workbook Properties 00:05:00
Intermediate Level
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
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
Create and Modify Tables 00:15:00
Apply Intermediate Conditional Formatting 00:07:00
Apply Advanced Conditional Formatting 00:05:00
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
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
Advanced Level
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Collaborate on a Workbook 00:19:00
Protect Worksheets and Workbooks 00:08:00
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
Create Sparklines 00:07:00
MapData 00:07:00
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
Order your Certificate
Order your Certificate 00:00:00
Give us your Feedback
Feedback Form 00:00:00

Course Ratings

4.7

4.7
15 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Ratings found for this course.

How Do Our Courses Work?

Purchase and payment

Add your chosen course to your basket. Once you’ve added all the courses you need.

Course access

Add your chosen course to your basket. Once you’ve added all the courses you need.

Certificate

Add your chosen course to your basket. Once you’ve added all the courses you need.

Continued support

Add your chosen course to your basket. Once you’ve added all the courses you need.

Dive into an enriching online learning journey with Alpha Academy. We pride ourselves on offering a diverse range of courses tailored to your needs. Elevate your expertise or discover a new passion. With Alpha Academy, your pursuit of knowledge has no bounds.

Contact

For Business

Certificate validator

Payment methods possible

© ALPHA ACADEMY IS A PART OF ADAMS ACADEMY INC. LTD.

top
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    WINTER SALE :: ALL COURSES for $64.09 / year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon