Covers Excel 2010 and previous versions. Demoed in Excel 2010
Microsoft Excel is one of the most powerful and versatile spreadsheet programs today. It offers endless capabilities and functionalities for streamlining data manipulation and simplifying analysis. There are also options for presenting data with ease in numerous formats for just the professional look you need. And in these days of doing more with less in less time, every opportunity for maximizing efficiencies in your daily grind is a bonus.
With all of the capabilities Excel has to offer, are you really making the most of this powerful program?
With so much data and information on your hands, it can be painstaking and time-consuming to sift through manuals, take tutorials or decipher complex self-help guides. Why spend the time and effort when you can sign up for this one-hour webinar and get the tools and techniques you need to start working smarter today!
In just one hour of focused advanced Excel training online, go beyond Excel basics and learn the tips and tricks the pros use to unlock the power of the Excel advanced features! From macros and PivotTables to automated calculations and advanced charting, there is much more to Excel than meets the eye. You'll learn how to quickly and easily access an array of little-known features that will expand your knowledge and make you a more confident, capable user in no time!
Your trainer is an accomplished Excel expert who will walk you through time-saving shortcuts, smart strategies and more — in a way that will keep you engaged and entertained. You won't waste time rehashing how to create spreadsheets, input data, perform basic calculations or edit cells. Instead, you'll quickly gain the skills you need to take your Excel expertise to the next level. If you're comfortable with the basics of Excel and looking to kick it up a notch, this power-packed program is for you!
What You'll Learn
- Insert hyperlinks into your spreadsheets the correct way
- Take macros beyond capturing clicks for simplifying the way you work
- Discover how to run a regression in Excel
- Use scatter graphs for diverse analysis purposes
- Get more from your data using advanced charting and graphing techniques
- Understand how sharing workbooks can allow multiple users to manage data simultaneously
- Explore and utilize the options available for protecting your work
- Expand your ability to use an array of advanced formulas and functions
- Determine how to most effectively link workbooks and automate calculations
- Take advantage of SmartArt to perk up dull spreadsheets
- Utilize PivotTable calculated fields and items with ease