Excel Basics
- Excel Tips, Tricks and Shortcuts
- Excel Basic Formulas
- Printing in Excel
- Excel Formatting Techniques
- Excel Charts & Graphs
Excel Tips, Tricks and Shortcuts
Learn to tap into the power of Excel. In this webinar you will learn to double your productivity and cut your work time in half by learning the hidden shortcuts, tips and tricks of Excel.
-
Learn quick Navigation and Selection Shortcuts
-
Understanding the many uses of the Auto Fill Handle
-
Learn to create your own toolbar for quick access
-
Discover many of the secret hidden shortcuts to save you tons of time
-
And more…
Excel Basic Formulas
Unleash the true power of Excel by understanding how to create basic Formulas to do all the calculations for you. Excel specializes in “number crunching.” If you have been intimidated by Excel (or numbers/math) or simply want to better understanding of exactly how to more effectively use the calculating features of Excel this class will provide clarity and give you certainly and confidence in building powerful spreadsheet with actuate, automatically updating totals and links.
-
Learn how to quickly and easily create a basic formulas
-
Learn why the Order of Operation is extremely important when building Formulas
-
Understand the difference between Formulas & Functions and when to use a Formula and when to use a Function.
-
Learn the essential difference between Absolute and Relative Reference.
-
Learn how to link data on different worksheets
-
And more…
Printing in Excel
Have you ever ended up printing 20 pages when you only wanted one? Have you spent hours trying to fit all your information on one page only to end up a row or column to long? Have you struggled to get the headers to appear at the top of every page? You are not alone. Printing in Excel is not always as easy as it might appear. Learn to easily set-up your page to print EXACTLY what you want to print.
-
Learn to set your print area
-
Learn how to effectively use the Page Break Preview
-
Learn to add valuable Headers and Footers
-
Learn to get the header row at the top of every page
-
Learn how to remove ugly gridlines
-
Learn how to avoid printing multiple pages
-
Learn how to easily fit all your data on the page
-
And more…
Excel Formatting Techniques
Format your spreadsheet for success. Now that you have all your data in a spreadsheet how do you make it look nice, profession and easy to read? Learn the art of formatting your spreadsheets to give them that added pizzazz and help solve some data entry issues.
-
Learn to create titles that stand out
-
Learn to format dates and times correctly
-
Understand how to get a leading zero
-
Learn how to add boarders, colors and fonts
-
Discover how to easily and quickly copy formatting on your spreadsheet.
-
Learn how to get rid of formatting you no long want
-
And More…
Excel Charts & Graphs
They say a picture is worth 1000 words. Display your data graphically by creating chart and graphs. It’s actually a lot easier than you think!
-
Learn short cuts that can turn your data in to a chart in 2 steps
-
Use the Chart Wizard to walk you through each step in creating a chart.
-
Understand the chart toolbar to easily modify you chart
-
Learn the tricks to customizing your chart
-
Learn formatting techniques to give your chart that extra flair.
-
And More…