Overview
Are you looking to enhance your microsoft excel proficiency to help boost your career prospects? Building a satisfying career can be a lifelong process but if you want to gain a competitive edge in your job search, look no further!
With this Microsoft Excel – Complete Excel course, you will build the solid foundation you need to kickstart a successful career in the Microsoft excel industry.
The course covers the essential things you need to know to boost your career within the Microsoft excel. It provides you with the ability to improve your earning potential.
Covering everything you need to know to boost your career within Microsoft excel, this industry recognised certification includes 35 comprehensive bite-sized modules that you can learn in your own time, pace and environment. Complete your course and earn your qualification in just 6 hours with dedicated online support you can trust and rely on.
Why Learn With Queen Mary Academy?
- 50,000+ students worldwide
- Start a new career or advance your current one & land your dream job
- Most in-demand skills for today’s job market
- Award-winning Customer Support
- Partnered with biggest accreditors in the world
Benefits You Will Gain
- No hidden fees.
- 24/7 access to the Learning Portal.
- Receive the UK and globally recognised certificate on completion of the course.
- Qualified tutor support and exceptional customer service.
- Access the Learning Portal whenever you want
- Learn from industry-leading experts.
Who is this course for?
Whether you are looking to enhance your employment prospects, boost your CV with essential skills or climb the career ladder to a higher position, this Microsoft Excel – Complete Excel Course will work as an initial step towards earning an internationally-recognised qualification that could prove invaluable for your career.
this Microsoft Excel – Complete Excel Course has been designed for learners who are looking to gain the skills and credentials to fast track a fulfilling career in Microsoft excel.
Entry Requirement
The Microsoft Excel – Complete Excel Course is for learners of all levels, with no specific enrolment requirements; all you need is the commitment to learn, knowledge of the English language, and basic numeracy and IT skills. Students must be over the age of 16.
Certification
Once you have successfully completed the Microsoft Excel – Complete Excel Course, you will receive an accredited certificate from Queen Mary Academy as validation of your new skills. Certification is available in PDF format, at the cost of £12, or a hard copy can be sent via post at the cost of £27.
Career path
On successful completion of the Microsoft Excel – Complete Excel Course, learners will have the knowledge, skills and credentials to enter the relevant job market, with the confidence to explore a wide range of industry-related professions. Students will be able to add this qualification to their CV/resume, giving them a head start in their chosen field.
Course Curriculum
Introduction | |||
Introduction | 00:02:00 | ||
Excel Basics | |||
Basics | 00:08:00 | ||
Worksheet Basics | 00:16:00 | ||
Entering values and Formulas | 00:07:00 | ||
Data Formats | 00:08:00 | ||
Data Handling Basics – Cut, Copy and Paste | 00:14:00 | ||
Saving and Printing – Basics | 00:09:00 | ||
Essential Formulas | |||
Basic Formula Operations | 00:13:00 | ||
Mathematical Functions | 00:19:00 | ||
Textual Functions | 00:17:00 | ||
Logical Functions | 00:11:00 | ||
Date-Time Functions | 00:07:00 | ||
Lookup Functions ( V Lookup, Hlookup, Index-Match ) | 00:08:00 | ||
Data Tools | |||
Data Tools | 00:19:00 | ||
Formatting data and tables | |||
Formatting data and tables | 00:18:00 | ||
Pivot Tables | |||
Pivot Tables | 00:08:00 | ||
Excel Charts | |||
Excel Charts – Categories of messages that can be conveyed | 00:04:00 | ||
Elements of charts | 00:05:00 | ||
The Easy way of creating charts | 00:03:00 | ||
Bar and column charts | 00:12:00 | ||
Formating charts | 00:15:00 | ||
Line Charts | 00:09:00 | ||
Area Charts | 00:06:00 | ||
Pie and Doughnut Charts | 00:13:00 | ||
Why we should avoid Pie charts | 00:04:00 | ||
Scatter plot or XY chart | 00:16:00 | ||
Frequency Distribution and Histograms | 00:13:00 | ||
Waterfall Charts | 00:12:00 | ||
Sparklines | 00:05:00 | ||
Pivot Charts | |||
Pivot Charts | 00:07:00 | ||
Named Ranges | |||
Named Ranges | 00:10:00 | ||
Indirect Function | 00:05:00 | ||
Excel Shortcuts | |||
Shortcuts | 00:12:00 | ||
Macros | |||
Macros | 00:10:00 | ||
Advanced Excel | |||
Advanced Excel: Analytics in Excel | 00:15:00 | ||
Obtain Your Certificate of Achievement | |||
Order Your Certificate of Achievement | 00:00:00 |
Course Reviews
No Reviews found for this course.