excelteacher
Loading...
159
subscribers
156,212
video views
Uploaded videos
1-10 of 32-
Add Y Error Bars to Charts and Graphs in Excel
excelteacher
23,724 views
http://www.TeachExcel.com How to add y error bars to charts or graphs in excel. Also, how to add custom values for the y error bars and how to edit them.
Follow along w...
-
How to make text cells all lower case or upper case in Excel
excelteacher
1,175 views
http://www.TeachExcel.com
How to make text cells in excel upper case, lower case, and in the proper case. UPPER() LOWER() PROPER() Functions. How to use formulas to capit...
-
Password Protect Excel Documents & Remove Personal Information - Security
excelteacher
2,351 views
http://www.TeachExcel.com
How to make your excel document safe and secure. Includes password protecting them as well as removing personal information from them. For more ...
-
How to Potect a Worksheet and Workbook in Excel
excelteacher
1,173 views
http://www.TeachExcel.com
How to protect a worksheet and workbook in excel. This will prevent unauthorized people from editing, deleting, or changing data in excel.
F...
-
How to Lock and Unlock cells in Excel
excelteacher
50,562 views
http://www.TeachExcel.com
How to prevent data from being deleted from your spreadsheets. How to lock and unlock cells in excel. Also allows for bulletproof forms to be cr...
-
Print multiple Worksheets and Workbooks in Excel
excelteacher
1,293 views
http://www.TeachExcel.com
How to print multiple worksheets and workbooks in excel.
Follow along with the spreadsheet used here and get more stuff including template...
-
Formatting Spreadsheets for Printing - Page Setup, Repeat Columns/Rows, Print Area
excelteacher
2,291 views
How to format your data so that it will print in a desirable fashion. Includes fitting everything on one page, inserting page breaks, and selecting the print area. Page Set...
-
Format & Compile Data in Excel - left right mid functions
excelteacher
1,149 views
http://www.TeachExcel.com
How to break one column of data up into multiple columns of data using LEFT() RIGHT() MID(). How to seperate data. Also, how to quickly format d...
-
How to link two (multiple) workbooks and cells in Excel
excelteacher
8,710 views
http://www.TeachExcel.com
How to link two or more workbooks and cells in Excel. Basically just cell linking between workbooks explained.
Follow along with the spreads...
-
Linking Cells in Separate Worksheets in Excel
excelteacher
1,763 views
http://www.TeachExcel.com
How to link cells between separate worksheets in the same file (workbook) within excel. This method also allows you to add formulas and function...
Advertisement
About excelteacher
My goal is to teach you excel in a way that is easy to understand and down to earth. I plan to have many tutorials regularly updated that serve to teach all levels of excel users from the beginner to the advanced user.
I also have a website with all the spreadsheets used in these tutorials as well as a wide range of helpful tutorials, shortcuts, tips & tricks, and a forum.
Check it out: http://www.TeachExcel.com
less
My goal is to teach you excel in a way that is easy to understand and down to earth. I plan to have many tutorials regularly updated that serve to teach all levels of excel users from the beginner to the advanced user.
I also have a website with...
more
more
less
Play all(32)