Excel 2016 - Tables - Creating, Sorting, Filtering - How To Create Sort and Filter a Table in MS 365
This Excel 2016 tutorial shows you how to create sort and filter a Microsoft Office Excel table. It covers filtering sorting and applying formulas and functions to your table using the total row. It also shows you how to change the style of your table and the theme and overall look of the table. How to make a table in Excel.
Here is a full list of tutorial videos available on my channel:
Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Capture an Image of the Entire Screen
Explore the Control Panel and the Settings App
Personalize the Desktop
Modify Screen Brightness and Resolution
Explore the Control Panel and the Settings App
Personalize the Desktop
Adjust the Sound
Plan the Organization of Files and Folders
Run an App
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
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial
Format Paragraphs
Create a Custom Word Template
Preview and Print a Document
Change Document and Paragraph Layout
Use AutoComplete and AutoCorrect
Correct and Reorganize Text
Header and Footer Tutorial
Page Numbers Tutorial
Captions in Word
Review Document Headings in the Navigation Pane
Reorganize Document Text Using the Navigation Pane
Collapse and Expand Body Text in a Document
Use Continuous Section Breaks for Page Layout
Insert Page Numbers Starting from a Specific Page
Format Text
Undo and redo Commands or Actions
Modify a Style
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 Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Histogram Charts
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Format Cells with Merge & Center, Cell Styles, and Themes
Chart Data to Create a Column Chart & Insert Sparklines
Select Cells and Ranges
Use CountIF and IF Functions and Apply Conditional Formatting
Use Date &Time Functions and Freeze Panes
Use Goal Seek to Perform What-if Analysis
Add Fill Colors and a Background Image
Insert Functions from the Formula Library
Use the PMT Function to Calculate a Loan Payment
Describe the Excel Worksheet
Enter Formulas Using Point Mode
Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep - Basic Certification Exam Practice Study Guide
Add Existing Fields to a Form
Create a Query, Form, and Report
How To Use the Property Sheet
Open and Save an Existing Database
Create Table Relationships
Learn Basic Database Concepts and Terms
Create and Use a Form to Add and Delete Records
Learn the Guidelines for Designing Databases and Setting Field Properties
Find, Modify, and Delete Records in a Table
Create a Form Using the Form Wizard
PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Microsoft Office Specialist Exam Certification
Print and View a Presentation
Lighten Background Images in Microsoft Office
Edit an Existing Presentation
Insert Online Pictures
Create a Title Slide and Slides With Lists
Select and Change a Document Theme and Variant
Insert and Format Pictures
Insert Shapes
Insert a Video
Outlook 2016
Basic Tutorial
Office 2016:
Identify the Components of the Microsoft Office Ribbon
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
Explain the Importance of File Management
Troubleshoot Common Computer Problems
Publisher 2016 Playlist
Пікірлер: 33
Thank you for taking the time to help with this. You are short, concise and accurate. I have learned more about sorting than I ever knew was possible
@ProfessorAdamMorgan
4 жыл бұрын
No problem James, I am glad this was helpful for you. Thanks for watching and have a nice day!
You are simply the best !!! the way you explain is so easy to understand !! Thanks !! Minelys
I NEVER LEAVE POSTS BUT THIS WAS UNBELIEVABLY AWESOME WHEN IT COMES TO LEARNING EXCEL. I MEAN EVERYTHING WAS GREAT AND I GOT IT. THIS HAS BEEN THE BEST LEARNING EXPERIENCE BY FAR WHEN IT COMES TO LEARNING THIS ASPECT OF EXCEL. I LOOK FORWARD TO LEARNING MORE WITH EXCEL. PLEASE LET ME KNOW MORE. THANK YOU
@ProfessorAdamMorgan
4 жыл бұрын
Thank you for letting me know, Gertrude. Please feel free to check out my Excel playlist if you're trying to learn more, I'll link it below. Thanks for watching: kzread.info/dash/bejne/pp-HzauAoszQf7w.html
Thanks to our great teacher
@ProfessorAdamMorgan
4 жыл бұрын
Thank you for watching Eng. Kirollos Shawky!
Excellent man. clear and up to the point.
@ProfessorAdamMorgan
5 жыл бұрын
Thank you Moshin, I appreciate that.
Genuis. Thanks for contributing to the world.
@ProfessorAdamMorgan
4 жыл бұрын
Hey I’m glad this is helpful for you, dj fene. Thanks for watching, I appreciate it!
thanks for this video. it helped me alot.
Thank you. It's impressive.
Thank you Adam for the helpful video!
@ProfessorAdamMorgan
5 жыл бұрын
No problem Salman, thanks for watching! I'm glad it helped.
Very important and useful thank you
fantastic. thank you
Thank you, professor
@ProfessorAdamMorgan
6 жыл бұрын
No problem Florence, thank you for watching. Have a nice day!
I love your videos. Concise, very well presented, easy to follow and learn the concepts. Thank you for taking the time to teach us. Do you have any MOS Excel 2019 exam prep videos?
Very useful and simple, good jb. Thanks
@ProfessorAdamMorgan
4 жыл бұрын
Glad you liked it!
Hi Adam, this video was very helpful! I do have a question and here is my example: rows 9, 10, 11 have employee name, sick time, vacation time, with totals at the end of the rows. I want to be able to hide rows 10 and 11 without using the hide function. Is that possible? I have tried using the drop down, but that didn't work for me, so I thought I would see if filtering would work. Suggestions?
@ProfessorAdamMorgan
4 жыл бұрын
Hi Terri, I'm glad this video was helpful. You could highlight the cells within the rows. From there, use the filter button to filter them out by color. Click the filter button, then click filter by color, then choose no color. This should hide any cells with that coloring. I hope this helps.
Is it possible to sort within a table. When you sort a range within a table (that is not formatted as an Excel Table), Excel asks if you would like to expand the range or continue with the selection. The same option is not given in Excel Tables (the range automatically expand to include the whole table.
@ProfessorAdamMorgan
5 жыл бұрын
Hi Richard, Sure, so when you expand the selection, take a look at the check box below the selection. It'll ask if you want to include headers. These headers are the first row of data within your table. If I go to sort a range (rather than a table), I'll usually expand the selection and include headers. Once I do that, I can sort from any columns within the selected range. I hope this helps you out.
@richardgreves6161
5 жыл бұрын
@@ProfessorAdamMorgan I'm sorry, I don't understand. When I choose a range within an Excel table and then open the sort dialog, the range is expanded to include the entire table automatically. Also, the checkbox (My data has headers is grayed out.
@ProfessorAdamMorgan
5 жыл бұрын
Hi Richard, Sorry, this is a little difficult to solve without seeing the actual data. Have you tried adding applying filters to the data and sorting it using the filters? If not, go to the data you'd like to sort and select it. Then go to the Home Tab and click the Sort and Filter button in the Editing group. You can then Sort A to Z or Z to A and even apply filters for custom sorting. I hope this works for you.
You've shown how to create an Excel file with (say) 5 columns and 30 rows, convert it to a table, and sort it. Let's say I then add 150 new rows to the file (from my documentation). How do I add those new rows to the table so I can sort the whole thing? ( Do I need to check back here periodically, or will I be notified if and when someone replies? )
Excellent video Prof Adam. How can I make such a sheet? I want to use it for a business.
@ProfessorAdamMorgan
4 жыл бұрын
Hi Idumijie, You would have to create a table and format the cells as necessary. Here is a link to my Excel playlist, it should have everything you need to get going with Excel tables: kzread.info/dash/bejne/pp-HzauAoszQf7w.html
How do you do the green bars corresponding to the numbers in column A
@ProfessorAdamMorgan
4 жыл бұрын
Hi Joe, You need to select the data first. Then go to the Home Tab, Styles Group. Click Conditional Formatting and go to Data Bars. Then choose the color you want. I made a video explaining conditional formatting, here: kzread.info/dash/bejne/l3lopsacg6iTY8Y.html