Topic: A few exciting and handy excel functions

Specific Purpose: After my demonstration, you will learn the skills necessary to make you stand out among other job candidates.

Introduction

A. Attention Getter: In my opinion, the ability to effectively use Microsoft Excel or Google Sheets is by far the single most vital skill set to have once a student leaves school and sets foot into society and the workforce.
B. Topic Revelation Statement: For this demonstration, I will be using Google Sheets to show you the magic of spreadsheets.
C. Significance Statement: The skill sets you will learn in this demonstration will help prepare you for future job interviews.
D. Preview / Roadmap: We will first cover the fundamental basics of spreadsheets. Second, we will explore some useful formulas and functions that we can use to boost our productivity. Third, we will discuss some of the common mistakes to avoid for beginner users of excel. Finally, in the end, I will show you a real-world scenario of how you can apply some of the functions that we’ve just learned.

Body

i. Main Point 1: The fundamentals of spreadsheets.
a. Intro to 1st point: Let’s get to know some of the most commonly used spreadsheet software and data types.
b. Main Idea 1: The two most used spreadsheet software nowadays is Microsoft Excel and Google Sheet. Although Microsoft has a dominant productivity software market share, its product was initially designed with power users in mind. Therefore, its user interface is highly complex and challenging to grapple with. On the other hand, Google Sheet is a lot more beginners friendly with its intuitive and easy-to-use user interface.
c. Main Idea 2: To understand spreadsheets, we will first have to understand the different types of information that we can input on a cell. In this case, numbers and text. [Visual Aid #1]
d. Big Point: It is essential that we understand the different types of data that we can input into each cell because, otherwise, some of the formulas and functions may not work correctly. We will touch up and elaborate on the formulas and functions in our third topic.

ii. Main Point 2: Some of the most common types of formatting errors.
a. Intro to 2nd point / Transition away from 1st point: Now, let’s talk about some interesting computational formulas and how it works.
b. Main Idea 1: The most commonly used formulas are addition, subtraction, multiplication. [Visual Aid #2]
c. Main Idea 2: We represent addition using a plus sign, subtraction with a dash, multiplication with a star, and division with a forward slash. [Visual Aid #3]
d. Big Point: It is imperative to keep in mind that orders of operations matter.

iii. Main Point 3: A few of the most used formulas and functions.
a. Intro to 3rd point / Transition away from 2nd point: Now it’s finally time to start with the fun part, messing around and applying functions to your spreadsheet.
b. Main Idea 1: The most commonly used functions are SUM, VLOOKUP, COUNT, COUNTA, and COUNTUNIQUE [Visual Aid #4]
c. Main Idea 2: It is crucial to understand how to effectively use arrays of cells and cell referencing.
d. Big Point: Now, let’s take a look and see how this applies to a real-world scenario. [Visual Aid #5]

Conclusion

A. Review: Now that we’ve gone over all the fundamentals, formulas, and functions within a spreadsheet. You are now ready to try these tricks hands-on.
B. Significance/ C. Reinstate Topic: It is important to re-emphasize that this demonstration is not just about showing you the fundamentals of spreadsheets but also helps better prepare you for your future career.
D. Lasting Thoughts: I hope you like this demonstration. If you’d like to get a sneak peek into how pivot tables work, feel free to look back at my practice demonstration speech in week seven! I hope to show you more exciting functions about excel in future videos. Thank you for tuning in, and I’ll see you in the next video!