Booking options
£5
Course Images
Microsoft Excel
By LearnDrive UK
(1)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
1 hour
All levels
Description
This course at a glance
Accredited by CPDQE
Master Excel from A-Z
Save time and boost your productivity in Excel
Find a value using VLOOKUP, HLOOKUP, INDEX, and MATCH
Become proficient in math, statistics, logic, and text functions
Get started with VBA and macros
Learn to use VLOOKUP/HLOOKUP in formulas
Create basic and advanced formulas
Master Pivot Tables
Create Charts from your data
Learn how to become a professional data analyst
Become an Excel expert and land your first job
For educational purposes or during job interviews, you must have a fundamental understanding of Microsoft Excel. Today’s world requires a solid grasp of these skills. This course teaches you everything you need to know about Microsoft Excel to succeed in the job market.
The Microsoft Excel course covers all the skills needed to become a master of this widely popular spreadsheet application. We will teach you expert data analysis skills using Microsoft Excel if you’re tired of other sophisticated data analysis tools. Using a few simple functions and formulas, you can finish complex calculations within a blink of an eye. You’ll be an expert at pivot tables and macros, which will make your professional tasks ten times easier. To sum it up, this course will help you become proficient in Microsoft Excel so that you can start your career immediately.
An expert instructor designed this “Microsoft Excel” course to provide you with the best learning experience possible. Our goal is for you to learn and apply the lessons from this course to improve yourself.
Grab the course. Enrol Now!
Accredited by
This course is CPDQE accredited, which serves as an impactful mechanism for skill enhancement.
Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.
CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession.
Course Curriculum
Section 1: Introduction
Section 2: Getting Started with Excel
Section 3: Values, Referencing and Formulas
Section 4: Intro to Excel Functions
Section 5: Adjusting Excel Worksheets
Section 6: Visually Pleasing Cell Formatting
Section 7: How to insert Images and Shapes!
Section 8: Visualize Data with Charts
Section 9: Excel's Printing Options
Section 10: Benefits of Using Excel Templates
Section 11: Working with Excel Datasets
Section 12: Excel Database Functions
Section 13: Excel Data Validation
Section 14: Excel PivotTables
Section 15: Excel's PowerPivot Add-In
Section 16: Excel's Conditional Functions
Section 17: Excel's Lookup Functions
Section 18: Text Based Functions in Excel
Section 19: Auditing Formulas & Custom Views in Excel
Section 20: Excel’s “What If?” Tools
Section 21: Welcome to Excel VBA!
Section 22: The VBA Language
Section 23: Writing VBA Code
Section 24: Important VBA Tools and Logic
Section 25: Excel VBA Loops
Section 26: Triggering Macros
Section 27: Excel UserForms
Section 28: Starting a Career in Excel
Frequently Asked Questions
Do you offer free certificate?
Yes, we offer free PDF Certificate upon course completion. Here is an example certificate that you will get after completing your course.
Is this course accredited?
Yes, this course is accredited by CPDQE.
Who is CPD for?
Continuing Professional Development (CPD) is a practice embraced by countless individuals across diverse industries and professions. Typically, professional organisations and institutes mandate CPD requirements, often specifying a specific number of annual CPD training hours.
In recent decades, the dedication to CPD has transcended the confines of traditional sectors and UK-based institutions, gaining global recognition and acceptance.
Why do you need CPD?
Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.
CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession.
Can you tell me about CPD Points, hours and credits?
The majority of institutions and professional organisations establish Continuing Professional Development (CPD) goals, typically on an annual basis. These objectives are determined by accumulating CPD activities, which include participating in training courses, eLearning programs, events, and other structured learning experiences.
Most professional bodies employ CPD hours as their primary metric, and when CPD points or credits are utilised, they are typically in a direct 1:1 correlation with CPD hours. In simpler terms, one CPD point equates to one CPD hour.
About The Provider
LearnDrive UK
Ashford
(1)Welcome to Learndrive! Your Trusted Online Learning Platform!
Reviews
There are no reviews for Microsoft Excel yet.Why not be the first one to review this course?