How to Add Tables and Filters to Raw Data in Excel
You will learn how to add tables and filters to your data in Excel. Adding a table to your table in Excel makes for a very nice looking way to display your data. Adding filters to your data is a must if you want to be able to sort by the alphabet, number, dates, etc.
Enjoy.
1
view
How to Create a Histogram in Excel Fast
This video shows you how to quickly create a Histogram in Excel
1
view
How to Create a Histogram and Make Custom Adjustments for Beginners
Hey Everyone, today I am going to show you how to create a histogram and make custom adjustments. You will see how to change the chart color, add data labels, change the bin size, add a header, change the chart style, etc...
2
views
Remove Duplicates vs Unique () Function to remove duplicates in data...Easy
Hey Everyone, in this video you see how to use the Remove Duplicate option under the data tab and how to use the Unique function to remove duplicate values in your data. The differences they have may surprise you and will hopefully help you to use the best tool to remove those pesky duplicates. Thanks for watching!
3
views
What these Excel Controllers do.....For Beginners
Hey everyone, this video will show you how to use cell controllers to be more efficient in Excel. You will learn how to select cells, move data around in the worksheet, how to fill a series to decrease typing, filter, sort and more.
Thanks for watching. Let me know if there are any other things that you would like me to share.
1
view
How to use the CountA Function in Excel for Beginners...Things to look out for
Hey Everyone. This video will show you how to use the CountA Function in Excel. The countA() function counts all cells with data in them. It counts cells with letters, numbers, dates, errors and even SPACES. I will also show you how to use the isblank() function to see whether or not a cell that appears blank is indeed blank.
Please let me know what you want to see next.
2
views
How to Add Tables and Filters to Raw Data in Excel...Things to look for
You will learn how to add tables and filters to your data in Excel. Adding a table to your table in Excel makes for a very nice looking way to display your data. Adding filters to your data is a must if you want to be able to sort by the alphabet, number, dates, etc. I will show you how to add additional columns and rows after you have made you table.
I hope you enjoy!
2
views
How to Rename and Change Tab Color in Excel Easy
Hey Everyone, in this video I show you how to rename tabs and change the color of tabs in Microsoft Excel. Ding this helps you to keep your work organized and provides colorful visual cues when working on your worksheet.
3
views
How to Use the SUM Function to Add in Excel Easy...Things to look out for
This video will demonstrate how to easily use the SUM() Function to automatically add numbers in rows or columns to get a total. I also show you that dates are added into the sum function. It does not work with groups of cells that have an error but will add if there are cells with a string in them. I hope this short video will be helpful. Please come again and share the video with anyone you think it would help.
1
view
How to use the Count() Function in Excel Easy...Things to look out for
Hey Everyone. This video will show you how to use the Count() Function in Excel. The count function only counts cells with numbers in them. The count function does not count cells with spaces, letters or empty cells. It does however count cells with dates and numbers strings that are converted in to numbers.
8
views