Suitable for
You will need
- A device with an internet connection
Course content
Section 1: Introduction
- Introduction to the Ultimate Excel Course
Section 2: Working with Large Worksheets
- Keeping your Headings Visible as you Scroll
- Splitting a Worksheet to Reference Two Different Areas
- Hiding and Unhiding Columns
- Sorting a Large List – Including a Super Shortcut
- Filtering a List – One of the Most Useful Excel Skills
Section 3: 5 Essential Tricks for Printing Spreadsheets
- Scaling a Print to Fit onto Fewer Pages
- Repeating your Headers Across Multiple P
- Printing a Selected Range and Setting a
- Aligning a Print on a Page
- Using Page Breaks to Logically Break Up
- Care for a Feedback
Section 4: Getting Started with Excel Formulas
- Introduction to Formulas – Writing your First Exc
- The Order Of Calculation-BODMAS
- Calculating Percentages
- Unleash the Power of Excel Functions
- Referencing Other Sheets and Workbooks
- Calculating Date Difference including Working Day
- understand Absolute Cell Addresses
- The COUNTIF Function-An Incredibly Useful Function
Section 5: Logical Functions: The Decision Making Formulas of Excel
- IF Function 1
- IF Function 2
- IF Function 3
- Nested IFS
- AND and OR Functions
- TNo More Nested IFS
- The Switch Function
Section 6: Conditional Formatting – Make your Data Come to Life
- Create your First Conditional Fo
- Managing Multiple Rules
- Highlight Expired And Due Dates
- cc
- Create a Heat Map
- Using Icon Sets
- Entire Row
- Testing Multiple Conditions
Section 7: Dynamic Array Functions – Formulas Have Changed
- Introduction to dynamic Arrays
- The UNIQUE Function
- The SORT Function
- The SORTBY Function
- The FILTER Function
- The SEQUENCE Function
Section 8: Lookup Functions – The Powerful VLOOKUP Function and beyond
- The VLOOKUP Function Expl
- Using VLOOKUP for a Range
- Advanced VLOOKUP
- Handling Error Messages
- The INDEX and MATCH Comb
- INDEX and MATCH
- Return Non Adjacent Column
- XLOOKUP Function
- Multi-Column Lookup
- Two-Way Lookup
Section 9: Validating and Protecting Excel Data
- Number Of Characters
- Create Date Validation Rules
- Drop Down Lists
- Dependent Lists
- Data Validation Messages
- Encrypt a File
- Protect Workbook
- Protect Worksheet
Section 10: Advanced Formulas for Analysing Data
- Using SUMIF, COUNTIF and AVERAGEIF
- Summing the Values between Two Dates
- Advanced Sum Formula with SUMPRODUCT
- SUMPRODUCT Example 2
- Secret AGGREGATE Function
- Advanced AGGREGATE
Section 11: Charts – Simple and Effective Data Presentation
- First-Charts
- Chart-Elements
- Formatting Charts
- Modidy the Charts Axis
- Chart Templates
- Combo Charts
- Chart-Filters
- Interactive Charts
- Using Cell Values for Chart Labels
- Conditional-Formatting with Charts
- Sparklines
Section 12: Manipulating Text in Excel
- Splitting Text across Multiple Columns
- Concat and Concatenate Functions
- The TEXTJOIN Function
- Extracting Text from a Cell
- MID and FIND Functions
- Value Function
- Substitute Function
- Flash Fill Tool
Section 13: Formatting your Data Ranges as Tables for Easier Management
- Formatting as a Table
- Benefits of Using Table
- Creating Table Style
- Formulas Using a Tables
- Back to a Normal Range
Section 14: Master PivotTables for Powerful Analysis and Reporting
- Creating a PivotTable
- Values Function
- Formatting Values
- PivotTable Style
- Sorting PivotTable
- Grouping Data
- Showing Values
- Conditional Formatting
- Filtering PivotTable Data
- Refreshing a PivotTable
- Creating a Pivotchart
- Slicers
- Timeline
Section 15: Getting and Transforming Data with Power Query
- What is Power Query
- Merge-Queries-2
- Messy Data
- Unpivot
- Merge Queries-1
- Combine and Append
Section 16: Working with the Data Model and PowerPivot
- Introduction PowerPivot
- Creating Relationships
- Creating PivotTable
- PowerPivot Adding
- Setting Locales
- PowerPivot Window
- Calculated columns
- Measures
- Multiple Files From Folder
- Importing Data From web
Bonus Materials
- installing-power-query-add-in [Download]
- ultimate-excel-course-exercises [Download]
Final Quiz: Ultimate Microsoft Excel Course: Beginner to Excel Expert
- Final Quiz: Ultimate Microsoft Excel Course: Beginner to Excel Expert
Order Your Transcript
- Order Your Transcript
How the course works
-
Get access
After payment, the course appears in your LearnDrive dashboard.
-
Learn at your pace
Work through 121 short video lessons in one sitting or several.
-
Complete the assessment
Attend the assessment and secure 70% to pass the assessment test.
-
Get your documents
Download the PDF document(s) included in your package.
Certificate and accreditation
What you receive
A digital Certificate of Completion (PDF) for this CPDQE-accredited course.
What the accreditation means
CPDQE accredits this course for continuing professional development (CPD). CPD accreditation is not a regulated qualification and does not by itself confirm job competence.
Checking a certificate
Anyone can check a certificate code on the LearnDrive certificate verification page.
What each package includes
| Document | Package 1 · £9.99 | Package 2 · £29.00 |
|---|---|---|
| Course access | Lifetime access | Lifetime access |
| Certificate of Completion (PDF) | Included | Included |
| Transcript (PDF) | Not included | Included |
| Enrolment Letter (PDF) | Not included | Included |
Course provider
LearnDrive Courses
LearnDrive is a UK-based online learning provider run by Edtech Learning Ltd. Courses are built by an in-house instructional design team using short video and audio modules.
About LearnDriveReviews
Reviews for this course
Reviews appear here when learners who completed this course leave one.
Frequently asked questions
How do I purchase a course?
To purchase a course, simply select the course you want, choose your plan from the top right side, and click on the ‘Take this course’ button to initiate the checkout process. You will receive access as soon as the payment is processed.
What payment methods do you accept?
We accept various payment methods, including credit/debit cards, PayPal, and bank transfer. If you don’t have a card or paypal, contact us for alternative payment methods.
What is your cancellation policy?
If you’re not satisfied with our course, you can request a refund within 14 days of purchase. We follow a no-questions-asked refund policy, and you will receive a full refund.
Will I receive a certificate after completing the course?
Yes, upon successful completion of the course and exam (if applicable), you will receive a free digital certificate that can be downloaded and printed.
Are your courses accredited?
Yes, our courses are CPDQE accredited. CPDQE is an independent body that accredits courses and events for continuous professional development, ensuring they meet high-quality standards.
How can I verify my certificate or certification code?
You can verify your certificate by visiting the Learndrive certificate verification page and entering your certification code. This will confirm the authenticity of your certificate.
How can I redeem a voucher or discount code?
To redeem your voucher, first visit the voucher redemption page. Enter your personal details and paste the voucher code into the designated field (do not type the code manually). After that, click the “Send” button. You will receive your login details via the email address you provided. Once you have received them, log in to our website and access your course from your dashboard.
