Excel 2016 - Functions and Formulas Tutorial - How To Create in Microsoft for Beginners - Flash Fill
HTML-код
- Опубликовано: 25 авг 2024
- Excel 2016 - Use Flash Fill and the SUM, AVERAGE, MEDIAN, and MAX Functions. In this tutorial, I show you how to create and adjust your formulas and functions for your Excel 365 and Office 365 Worksheets for Windows 10 and all updated and newer versions of the program. This tutorial is intended for beginners who want to learn how to use the program. My playlists and Tutorials on Excel show demos on how to complete basic tasks and tips and tricks along the way for various topics.
Tutorial/Playlist for Excel Beginners
My goal is to provide you with the best learning environment possible, for all beginners of technology. Please see a list of topics below that my various playlists cover, and don't forget to like and subscribe!
Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing
Also, check out these other playlists to improve your Office 365 and Job Search Skills
Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Functions and Formulas
Outlook 2016
Basic Tutorial
Job Search Skills:
Values, Attitude, and Goals
Video Requests:
Download GMetrix Test Preparation Software
Remember, the goal of my channel is for you to learn. You can request a video at any time in the comment section, and I will make the video for you. I will make tutorials and simulations and demos for whatever you'd like to learn in our class. So, I encourage you to make a request. I also RUclips Live Stream once a week to answer your questions!
Instructor A Morgan
Thank you, Adam. I have a job interview coming up and I will be tested on Excel. Your videos are great review material!
Hey good luck with your interview thetonksfamily, I hope that you get the position you're looking for. Thanks for watching and have a nice day!
@@ProfessorAdamMorgan Gigi i ok jjjjhu no
So happy you are teaching this info. This is well needed.
Thank you
Thank you Blue Rain, I appreciate that! Let me know if you have any questions and I'll try to help.
Ok. Thank you
Awesome video!! You present the material in such a way that's easy to understand. Thank you!!
Glad it was helpful!
thanks bud
No problem Steve's Toni, thanks for watching!
These instructions are very easy to follow. Thank you.
Glad it worked well for you Irene, thank you for watching. Have a nice day!
This is great. Would you also be able to create a video on pivot tables? Thank you!
Hi Adam, I'm trying to find how you leverage questions and testing to write formulas. Do you have a video on that?
Hi Monica,
I am not sure I know exactly what you mean. Are you asking about how to write questions that require formulas as a response? Let me know and I’ll try to help.
Do you have any video talking about " IF " function?.
Hey Mav,
Good suggestion. It's one I've been wanting to do for a while but my students haven't asked for it yet. I'll make one over the next few weeks on this. IF functions are great.
Hi Mav,
I made the video you requested on the IF Function. I hope it helps you out.
ruclips.net/video/eE4DdcSE-3c/видео.html
Thank you so much ☺
No problem Mav
Some of my students at a college are taking the MOS Excel 2016 exam. Do you have videos for structured references in tables, left, right, mid, upper, and lower functions? The list of required skills mentions these will be included in the Core Excel 2016 exam. Thank you, Barbara
+Barbara Schwartz Hi Barbara,
I took the MOS Excel 2016 Exam about a month ago and it did not have structured references in tables. I don't remember using the name box at all during the Exam. I'm happy to make any videos that you or your students request to help them for their exams. Thank you for stopping by my channel, and the comment.
Adam
Thanks so much for your fast reply. How about right, left, upper, mid and lower functions? I will tell my students about you for sure.
I didn't see any of the functions you mentioned on the exam. I did see the Proper function, so make sure that your students know that one. I know Certiport updates the test projects from time to time, so the functions you mentioned are good to learn just in case. Thanks so much for sending your students my way, I'll be happy to make any videos they request.
Adam
Adam, will you do a video on the VLook up plz! Thank you Cari
Hi Cari,
Yes, I will get that video out this weekend. Thanks for the comment.
Hi Cari,
Here is the video you request on the VLOOKUP Function:
ruclips.net/video/17tuYStB4Og/видео.html
Do you have anything on pivot tables?
Hi Kim,
Right now I do not. I will probably make a video on pivot tables at some point this summer.