Booking options
£12
£12
On-Demand course
11 hours
All levels
Are you looking to improve your current abilities or make a career move? Our unique Complete Microsoft Excel Course might help you get there! Expand your expertise with high-quality training - study the Complete Microsoft Excel and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course.
This Complete Microsoft Excel online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course.
The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Complete Microsoft Excel course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course.
With this comprehensive course, you can achieve your dreams and train for your ideal career. The Complete Microsoft Excel course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development.
You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards.
Enroling on the Complete Microsoft Excel course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program.
Why Prefer this Complete Microsoft Excel Course?
Opportunity to earn a certificate accredited by CPD after completing this course
Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery)
Standard-aligned lesson planning
Innovative and engaging content and activities
Assessments that measure higher-level thinking and skills
Complete the program in your own time, at your own pace
Each of our students gets full 24/7 tutor support
Experts created the Complete Microsoft Excel course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you.
Start your learning journey straight away with this course and take a step toward a brighter future!
*** Course Curriculum ***
Here are the topics you will cover on the Course:
>> Complete Microsoft Excel <<
Module 01: Microsoft Excel 2019 New Features
Introduction to Microsoft Excel 2019 New Features
CONCAT
IFS
MAXIFS
MINIFS
SWITCH
TEXTJOIN
Map Chart
Funnel Chart
Better Visuals
Pivot Table Enhancements
Power Pivot Updates
Module 02: Getting Started with Microsoft Office Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Module 03: Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
Module 04: Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
Module 05: Formatting a Worksheet
Apply Text Formats
Apply Number Format
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
Module 06: Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
Module 07: Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties
Module 08: Working with Functions
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions
Module 09: Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data
Module 10: Analyzing Data
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
Module 11: Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features
Module 12: Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers
Module 13: Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data
Module 14: Using Lookup Functions and Formula Auditing
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Module 15: Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks
Module 16: Automating Workbook Functionality
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Module 17: Creating Sparklines and Mapping Data
Create Sparklines
MapData
Module 18: Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends
Module 19: Excel Templates
Excel Templates
Assessment Process
Once you have completed all the modules in the Complete Microsoft Excel course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.
15 CPD hours / points Accredited by CPD Quality Standards
Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody.
You will not need any prior background or expertise to enrol in this course.
After completing this course, you are to start your career or begin the next phase of your career.
CPD Accredited Certificate
Digital certificate - £10
CPD Accredited Certificate
Hard copy certificate - £29
If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.