Learn Excel from Top to Bottom
Using Excel in the workplace remains a source of frustration for many users. However, Excel mastery can accelerate your career.
If you want to go from fearing Excel to being your office's Excel superstar, look no further:
Excel Foundations: Conquer the Fear of Excel
Gain Instant Access within 1 Hour of Purchasing!
Program Highlights
Module 1: The Spreadsheet Grid
** Introduction to the spreadsheet grid & naming
** Adjusting rows and columns
** Tips, tricks & techniques of cell formatting
Module 2: The Ribbon
** Full navigation of the top menu, the Ribbon, in Excel
** Where to find and use all tools in the Ribbon
** Achieve full knowledge of location of features
Module 3: The Home Ribbon
** Detailed navigation of Home Ribbon with tutorial
** Advanced cell formatting tips & tricks
** Achieve mastery over all tools in Home Ribbon
Module 4: Sort & Filter
** Sorting techniques to customize data
** Filtering tips to organize data how you want it
** Advanced filtering techniques to gain actionable insights from data
Module 5: Insert Ribbon
** Keys to creating Tables, Pivot Tables & more!
** Tips on adding graphs and sparklines
** Achieve knowledge of where to insert items for reports
Module 6: Page Layout
** Keys to customizing how you view Excel
** Techniques for setting your Excel print area
** Data mapping on the Excel spreadsheet
Module 7: Basic Formulas & Calculations
** Discover common formulas in Excel and how to use them
** Keys to testing formulas for accuracy
** Learn about relative and absolute cell referencing
Module 8: Sum Up
** Finding the sum for a dataset
** Different ways to sum up with conditional formatting
** Using relative and absolute referencing in summing up
Module 9: User Preferences
** Discover how to customize Excel to your needs
** Toolbar navigation of all customizable features
** How to save for all Excel vs. individual workbooks
Module 10: The Fill Handle
** Discover the time-saving magic of the fill handles
** Reduce repetitive entries to mere seconds
** Create sequence data with ease
Module 11: Stored Values vs. Display Values
** Discover the difference between what you see and what Excel processes
** Keys to testing display values against what is stored
** Troubleshooting techniques for when you expect display to be different
Module 12: Freeze or Lock Columns and Rows
** Dig deeper into making Excel presentable
** Keys to keep title headings viewable when entering long strings of data
** Get more comfortable customizing your spreadsheet
Module 13: IF Function
** How to create specified conditions in your calculations
** Real-world application: Using IF function to find important info
** Formula shortcuts to make IF functions easy-to-use
Module 14: Intro to Charts
** Basic of creating & customizing charts
** How to ensure your chart displays the data you want how you want
** Making your charts look good: Advanced display techniques
Module 15: Intro to Conditional Formatting
** What is conditional formatting and what it's used for
** Setting the criteria for your conditions and ensure it formats correctly
** Achieve deeper knowledge of how conditional formatting will help you
Module 16: Data Validation
** What to do when you get an error in your formula
** How to make sure your calculations are correct
** Troubleshooting when things go wrong
Module 17: Intro to Tables and Pivot Tables
** Dig deeper on creating and customizing tables
** Discover real-world application of tables & pivot tables
** Produce reports that wow and stun
Module 18: Vlookup
** Discover the secrets behind one of Excel's most challenging features
** What is Vlookup and how to use it: Save yourself time and effort
** Real-world Vlookup usage
Module 19: The Many Uses of Excel
** Discover how you can use Excel to save time and effort
** Overview of all built-in templates and how to use them
** Prepare for using Excel in the workplace
Module 20: Bringing it All Together
** Summary and review of all previous modules
** Create a cohesive understanding of how Excel truly works
** Take the first steps to becoming a great Excel user for life
Excel Foundations: Conquer the Fear of Excel
Gain Instant Access within 1 Hour of Purchasing!
Register today to begin your path to conquering the fear of Excel!
Sincerely,
Learn Excel Now
384 Technology Drive
Malvern, PA 19355