Free excel tutorials on video
- Learn how to perform over 30 excel shortcuts
- Free downloadable examples with every video session (you’ll get the exact example used in the video)
- We’ll also show you alternate ways or routes to perform the same action
- All of the excel tutorials are 100% Free
- Learn time saving tips
- Impress your coworkers and your boss
- All skill levels can learn something beginner - advanced
Freeze panes- Freeze the rows or columns
Arranging multiple windows and panes- Arrange your excel sheets for better viewing
Inserting a picture in excel- Insert a picture in a matter of seconds
Creating a custom toolbar- Personalize your own toolbar, it’s easy
Paste special- Learn the basics of paste special
Validation - Create a validation restriction with an error or warning message popup
Cut and paste - Learn how to cut and paste data
Autofilter - Filter data in a matter of seconds with autofilter
Inserting comments- learn how to insert a comment in to a cell
Borders and shading- Learn the basics of formatting the borders and cell shading
Create a macro- Learn how to create your own custom macro within 60 seconds
Custom footer- Create a custom footer
Custom header- Create a custom header
Conditional formatting
Autoformatting - This a very helpful time saving feature that is easy to use
Autofil- This is a basic feature that you will use often
Coming soon
Coming soon
Coming soon
Download example
toolbar.xls
Description
Create your own toolbar customized to your needs. It is much easier than you think, and you’ll soon realize how nice it is to have your favorite items in a quick and easy location.
Alternate route
Tools > Customize…
Making changed to your new excel toolbar
To make a change to your toolbar, you simply follow all the steps in creating one as in the video, and then when you’re at the “rearrange commands” box you can make your modifications. You can move each item up or down on the toolbar, delete an item, add another item, or modify an item.
