Ford and Lord International Pty Ltd

Master Your Microsoft Excel Skills
Free Course + Free Certification

Versatile Teaching

High Standards

Bright Future

Microsoft Excel

For Data Analytics

How to enrol and get free certification:


Both the Excel and Python courses are conducted through an open admission system. This means no formal enrolment is required. You can complete either of these courses at your own pace, in your own time. All you need to do is complete the Excel or Python (or both) video courses via the website. All assignments, tasks, projects, and quizzes will be available on the website by June 30, 2024. Please watch all the videos and ensure you are confident with the concepts taught.


Please prepare assignments, tasks, complete projects, and reflections, but keep them in a folder on your computer. Once you are confident that you have learned all the concepts and completed all the assignments, reflections, and tasks, please contact us via email at admin@fordandlord.com to indicate that you are ready for the exam. We will then send you a link to a Google Classroom page with the code. You will need to join the classroom and submit all the assignments, projects, and course reflections at once.


We will check and mark all the coursework. If you have achieved satisfactory results, we will invite you for an interview via an online meeting. During the interview, we will test your knowledge, and if you are successful, we will issue a certificate of completion.

Course Outline - Microsoft Excel for Data Analytics

Week-1

Excel Fundamentals - Introduction To MS-Excel

Assignment-1

After watching the video introduction about navigation, cell addresses, formula bar, and the Excel interface, reflect on what you have learned and how it can help you in your future work with Excel. Your assignment should address the following:

  1. Understanding the Interface: Describe the main components of the Excel interface covered in the video. How do these components contribute to your ability to work efficiently in Excel?
  2. Cell Addresses and Navigation: Explain what cell addresses are and how they are used in Excel. Reflect on the strategies for navigating through a spreadsheet that were discussed in the video. How can these skills improve your workflow?
  3. Using the Formula Bar: Discuss the importance of the formula bar in Excel. How does it help you when working with data and formulas?
  4. Practical Application: Provide an example of how you can apply the concepts from the video to a real-world scenario or task. Describe the specific Excel functions or features you would use and why.

Your reflection should be approximately 500 words in length. Be sure to provide specific examples from the video and your own experiences to support your points. Aim to be clear and concise in your writing.

Instructions for Preparing and Submitting the Assignments

  1. Prepare Your Assignment: Complete all the assignments as outlined in the course materials. Organize your work in a dedicated folder on your computer.
  2. Review Course Materials: Ensure you have watched all the videos and completed the associated exercises and tasks to gain a comprehensive understanding of the subject matter.
  3. Prepare for Submission: Once you have finished all the assignments and reviewed the course content, you will be ready for the next steps.
  4. Contact Us: Reach out to us via the email address provided below when you are ready to proceed to the online test. We will respond with a link to our Google Classroom page.
  5. Join the Class: Use the provided link to join the Google Classroom. This platform will serve as the central hub for submitting all of your assignments in one go.
  6. Submit Your Assignments: Upload your completed assignments through Google Classroom. We will review your submissions to ensure they meet the established standards.
  7. Online Test Invitation: If your assignments are approved, you will receive an invitation to participate in an online test or interview.
  8. Certification: Upon successfully passing the online test, you will be awarded a certificate of completion.

Week-2

Cells In Excel

Week-2.1

Basic formatting, fonts, borders, fill colours

Week-3

Formulas and Functions (Part 1)

Week-4

Formulas and Functions (Part 2)

Week-5

Intermediate Excel Skills - Data Management

Week-6

Advanced Functions

Week-7

Important Tips and Tricks - 1

Week-8

Important Tips and Tricks - 2, Custom Formatting, Charts and Graphs

Week-9

Working with multiple sheets in EXCEL - PivotTables (Part 1)

Week-10

Numbers that can drive you crazy - Creating a simple payroll - PivotTables (Part 2)

Week-11

Simple payroll - Calculating overtime, =IF() logical function

Week-11.1

Data Analysis with Excel

Week-12

Analyzing, Reverse Engineering. Absolute References - Excel

Week-13

Simple payroll - Calculating Tax in Excel

Week-14

Lesson 14: LARGE(), SMALL(), MATCH() and INDEX() functions in Excel

Week-14.1

Lesson 14.1: LARGE(), SMALL(), MATCH() and INDEX() functions in Excel

Week-15

Lesson 15 : Copy values and ROUND() function in Excel

Week-16

Transpose() and Conditional and Logical Operations

Card image cap
Introduction To Microsoft Excel.

Click On Below Button For Learning New Topic.

Watch Video Assignment 1

Assignment 1


After watching the video introduction about navigation, cell addresses, formula bar, and the Excel interface, reflect on what you have learned and how it can help you in your future work with Excel. Your assignment should address the following:

  1. Understanding the Interface: Describe the main components of the Excel interface covered in the video. How do these components contribute to your ability to work efficiently in Excel?

  2. Cell Addresses and Navigation: Explain what cell addresses are and how they are used in Excel. Reflect on the strategies for navigating through a spreadsheet that were discussed in the video. How can these skills improve your workflow?

  3. Using the Formula Bar: Discuss the importance of the formula bar in Excel. How does it help you when working with data and formulas?

  4. Practical Application: Provide an example of how you can apply the concepts from the video to a real-world scenario or task. Describe the specific Excel functions or features you would use and why.

Your reflection should be approximately 500 words in length. Be sure to provide specific examples from the video and your own experiences to support your points. Aim to be clear and concise in your writing.

Card image cap
Cells In Microsoft Excel.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Basic formatting, fonts, borders, fill colours

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Formulas And Functions Part-1.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Important Formulas And Functions Part-2.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Intermediate Excel Skills - Data Management.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Advanced Functions In MicroSoft Excel.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
1 - Important Tips And Tricks - In MicroSoft Excel.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
2 - Important Tips , Tricks | Custom Formatting + Charts And Graphs.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Working With Multiple Sheets In Excel - PivotTables Part 1.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Creating A Simple Payroll - PivotTables Part 2.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Simple Payroll - Calculating Overtime, =if() Logical Function.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Data Analysis With Microsoft Excel.

Click On Below Button For Learning New Topic.

Coming Soon
Card image cap
Analyzing, Reverse Engineering. Absolute References.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Simple payroll - Calculating Tax In Excel.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
LARGE(), SMALL(), MATCH() and INDEX() Functions In Excel.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Detailed Discussion LARGE(), MATCH() and INDEX() In Excel

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Copy values and round() function in Excel.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Transpose() and Conditional and Logical Operations.

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Power of Match() and Index() in MS Excel

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
count(), counta(), unique(), countif(), sumif()

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Aggregation using list with sumif()

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Sales by customer, Analyzing Data sumif()

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
sumifs() in MS Excel

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
2nd example sumifs() in MS Excel

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Eomonth(), char(row()), and randbetween() in Excel

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
filter(), choose(), and sort() in Excel

Click On Below Button For Learning New Topic.

Watch Video
Card image cap
Generating Quarterly Report in Excel

Click On Below Button For Learning New Topic.

Watch Video