Get Lifetime Access to This Course & 1900+ Others for Only £149. Subscribe Now
Course Overview
Learn how to make a genuine difference in your life by taking our popular Microsoft Excel Course for Everyone – Complete Excel Course. Our commitment to online learning and our technical experience has been put to excellent use within the content of these educational modules. By enrolling today, you can take your knowledge of Microsoft Excel Course for Everyone – Complete Excel Course to a whole new level and quickly reap the rewards of your study in the field you have chosen.
We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.
Please note that Microsoft Excel Course for Everyone – Complete Excel Course provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practice. Always check details with the appropriate authorities or management.
Learning Outcomes
- Instant access to verified and reliable information
- Participation in inventive and interactive training exercises
- Quick assessment and guidance for all subjects
- CPD accreditation for proof of acquired skills and knowledge
- Freedom to study in any location and at a pace that suits you
- Expert support from dedicated tutors committed to online learning
Your Path to Success
By completing the training in Microsoft Excel Course for Everyone – Complete Excel Course, you will be able to significantly demonstrate your acquired abilities and knowledge of Microsoft Excel Course for Everyone – Complete Excel Course. This can give you an advantage in career progression, job applications, and personal mastery in this area.
Is This Course Right for You?
This course is designed to provide an introduction to Microsoft Excel Course for Everyone – Complete Excel Course and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported, and the study periods are entirely customisable to your needs.
Assessment Process
Once you have completed all the modules in the Microsoft Excel Course for Everyone – Complete 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.
Show off Your New Skills with a Certification of Completion
The learners have to successfully complete the assessment of this Microsoft Excel Course for Everyone – Complete Excel Course to achieve the CPD & IAO accredited certificate. Digital certificates can be ordered for only £10. Learners can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.
Course Curriculum
| Section 01: Getting Started | |||
| Introduction | 00:03:00 | ||
| Course Curriculum | 00:04:00 | ||
| Getting started on Windows, macOS, Android, and IOS | 00:01:00 | ||
| How to ask great questions | 00:02:00 | ||
| FAQ’s | 00:01:00 | ||
| Starting Excel | 00:04:00 | ||
| Section 02: Excel Basics | |||
| Introduction | 00:02:00 | ||
| Worksheet basics | 00:22:00 | ||
| Entering values and formulas | 00:12:00 | ||
| Data formats | 00:10:00 | ||
| Data handling basics – cut copy and paste | 00:07:00 | ||
| Save and print in excel | 00:10:00 | ||
| Excel Ranges | 00:05:00 | ||
| Section 03: Excel essential functions | |||
| Introduction | 00:01:00 | ||
| Basic formula operations | 00:06:00 | ||
| Mathematical functions level 1 | 00:20:00 | ||
| Mathematical functions level 2 | 00:12:00 | ||
| Text functions level 1 | 00:09:00 | ||
| Text functions level 2 | 00:13:00 | ||
| Logical functions | 00:11:00 | ||
| Date time functions | 00:06:00 | ||
| V Lookup formula | 00:12:00 | ||
| HLookup formula | 00:04:00 | ||
| HLookup + Match formula | 00:09:00 | ||
| Match + Index formula | 00:06:00 | ||
| Section 04: XLookup only for Excel 2021 and Office 365 | |||
| Introduction | 00:02:00 | ||
| XLookup | 00:08:00 | ||
| Handling #NA and Approximates match in XLookup | 00:11:00 | ||
| Wildcard matching in XLookup | 00:06:00 | ||
| Section 05: Get Data and tools | |||
| Introduction | 00:02:00 | ||
| Split text into columns | 00:07:00 | ||
| Flash Fill | 00:07:00 | ||
| Remove Duplicates | 00:08:00 | ||
| Data Validation | 00:07:00 | ||
| Get- import Data from Text | 00:07:00 | ||
| Get – import Data from CSV | 00:03:00 | ||
| Section 06: Formatting data and tables | |||
| Introduction | 00:01:00 | ||
| Formatting Font | 00:04:00 | ||
| Formatting Alignment | 00:00:00 | ||
| Formatting Number | 00:04:00 | ||
| Formatting Date | 00:03:00 | ||
| Formatting tables | 00:05:00 | ||
| Section 07: Pivot Tables | |||
| Introduction | 00:01:00 | ||
| Creating Pivot Table | 00:07:00 | ||
| Value field settings | 00:04:00 | ||
| Number format | 00:02:00 | ||
| Pivot Table Design | 00:03:00 | ||
| Excel Exercise | 00:01:00 | ||
| Solution for Excel Exercise | 00:02:00 | ||
| Section 08: Excel Charts | |||
| Introduction | 00:01:00 | ||
| Excel Charts – Categories | 00:03:00 | ||
| Elements of a chart | 00:04:00 | ||
| Easy way to create charts | 00:02:00 | ||
| Column or Bar charts | 00:04:00 | ||
| Formatting charts | 00:04:00 | ||
| Line charts | 00:02:00 | ||
| Area charts | 00:02:00 | ||
| Pie and Doughnut charts | 00:04:00 | ||
| Format AreaPlot or XY chart | 00:08:00 | ||
| Scatter or bubble charts | 00:02:00 | ||
| Section 09: Advanced Excel charts | |||
| Introduction | 00:01:00 | ||
| Frequency Distribution and Histograms | 00:04:00 | ||
| Waterfall charts | 00:02:00 | ||
| Hierarchy charts: sunburst and tree map | 00:03:00 | ||
| Combination charts | 00:02:00 | ||
| Sparklines | 00:05:00 | ||
| Section 10: Pivot Charts | |||
| Pivot charts | 00:02:00 | ||
| Section 11: Maps Chart above 2019 | |||
| Maps chart | 00:04:00 | ||
| 3D Maps chart | 00:03:00 | ||
| Section 12: Business-Geo charts | |||
| Introduction | 00:01:00 | ||
| Stock charts | 00:02:00 | ||
| Radar charts | 00:02:00 | ||
| Surface charts | 00:02:00 | ||
| Heat maps | 00:04:00 | ||
| Section 13: Named Ranges | |||
| Named ranges | 00:05:00 | ||
| Indirect Name range Function | 00:06:00 | ||
| Section 14: Import Data into Excel | |||
| Import Data table from PDF file – Excel 2021 | 00:04:00 | ||
| Import Data from Website – Excel 2019 above | 00:09:00 | ||
| Section 15: Advanced Excel | |||
| Project: Sales forecast tracker | 00:07:00 | ||
| Product Sale Tax invoice: Tax Calculations | 00:05:00 | ||
COURSE REVIEWS
- 1 year
- Intermediate
- Number of Units80
- Number of Quizzes0
- 6 hours, 46 minutes Gift this course
COPYRIGHT © 2023 - ACADEMY FOR HEALTH & FITNESS TRADING AS MAYFAIR COLLEGE LTD (Company number 12389626). ALL RIGHTS RESERVED.