This 1-hour, project-based course introduces learners to basic spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets.
We will cover the following concepts in a hands-on manner: - Review basic functions: sum, min, max, average - Introduction to date-based functions: today, year, month, day, datedif - Trying out conditional functions: if, iferror, countif, sumif - Applying string-manipulation functions: find, replace, proper, concat, textjoin Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.
KZ
I felt prepared until I took the quiz and have to rework formulas
RR
Gradual and smooth teaching. Thoroughly enjoyed the session.
JT
Very well done, class. I liked it! I'm on my way to start the next one.
Showing: 14 of 14
I have been using excel for years but this course was not taught very well. I felt he moved too quickly and did not explain it in a way for everyone to understand. The lesson was made two years ago, so you have to enter current day data while working alongside him and some folks may not be able to see if they did it correctly because our results were different. Also, if you did not start by taking his 1st beginners course you may not know how to perform some pf the copy/paste and shortcuts that he used. For $10 this course should be better planned out and executed.
Courses would not work, couldn't hear it, kept breaking in and out. Then it advanced me to the end when I had only completed one section. Chat with a live person didn't help. Waste of money and I joined for the year after trying courses that worked perfectly until I paid to join. I asked the person to restart the course for me to try again no luck.
I felt prepared until I took the quiz and have to rework formulas
This is NOT a beginners course.
Very well done, class. I liked it! I'm on my way to start the next one.
Gradual and smooth teaching. Thoroughly enjoyed the session.
Teaches you important excel functions
Good explanation
excellent
km
It really takes time analyze t
Good course
awesome
well, when you get acces denied with your account and cant log in and therefore not use it. and support cant help. Then its difficult to use the course and give it more than 1 star