Show findcourses.com as: Mobile

Microsoft Excel - From User to Power User

Leader Development Institute
Training overview
Corporate / Group Training
Virtual Classroom, On-site
For more information about duration, please contact the institute.

Start dates
Worldwide
Inquire for more information

Online
Inquire for more information

Course description

Microsoft Excel - From User to Power User

In this jam-packed course, you'll discover time-saving techniques through the use of Excel. You will learn from design and formatting; formulas and data analysis; hidden charting and graphing techniques; PivotTable and PivotChart® reports; how to validate and secure your data and much more!

Training content

What Will We Cover?

  • An in-depth knowledge of Excel's ribbon, menus and functions, including how to create new />tabs and hide the ones you never use
  • Quick and easy techniques to import data from virtually any kind of file or database system, such as Microsoft Access, or SQL Server®
  • How to use Excel to quickly create professional-looking forms in minutes (not hours!)
  • Add control items to your worksheets, including check boxes, spinner buttons and many others
  • Formulas versus Functions – The differences you need to know
  • Understand the most common text functions like UPPER, PROPER, and CONCAT
  • Discover how to use IF functions to make logical comparisons
  • Understand the purpose – and drawbacks – of VLOOKUP
  • Write formulas with relative and absolute cell references and know exactly when to use each one
  • Quickly create custom AutoFilters to view your data the way that tells the story you need to know
  • Use the new Search Filter to quickly narrow down the available filter options in your tables, />PivotTable, and PivotChart views. Find exactly what you are looking for from up to a million />items, instantly.
  • How to quickly create a basic chart with a single keystroke
  • Insert Sparklines into cells to instantly reveal trends in your data
  • The quick and easy way to display your data using a PivotChart®
  • How to use the hidden advanced data analysis tools in a PivotTable report
  • The easy, visual way to immediately change and restructure the information reported in your PivotTable
  • How to share your Excel workbook and not worry about someone making changes that'll ruin your work
  • And MORE

Course delivery details

Available on-site programming.

Why choose LDi?

Vast catalog of courses in professional and personal development

We dedicate our time to each client tailoring to their specific needs. Our core values speak for themselves.

Our instructors are subject matter experts with proven experience in their training topics.

About LDi

Leader Development Institute

At Leader Development Institute (LDi) we firmly believe in the need for quality, effective course development and training for both the private and public sectors. LDi is dedicated to developing the leaders of tomorrow - at home, at work, across...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Microsoft Excel - From User to Power User.

  Contact the provider

  Get more information

  Register your interest

Country *
Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote