Microsoft Excel - Level 2 - Essentials

Enhance your Excel skills with essential tools, including V/H lookup, database functions, and data visualization techniques to improve your spreadsheet efficiency.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course takes your Excel skills up a notch! It expands on the basics, teaching you awesome tools like lookups, database functions, and how to create cool charts and graphs. Perfect for anyone who wants to conquer Excel and be a spreadsheet wizard.

Key Points

  • Learn V and H lookup functions
  • Discover CountIf and SumIf tools
  • Work with charts, graphs, filters, and lists
  • Import various file formats like XML
  • Track changes in your spreadsheets

Learning Outcomes

  • Become confident using advanced Excel functions
  • Master charts and visual data representation
  • Efficiently manage data with filters and lists
  • Import and manipulate different file formats
  • Enhance your productivity in Excel

About This Course

This course builds on the foundations to teach you how to use the essential tools in Excel.

This course builds on the Excel Level 1 foundations course to teach you how to use the essential tools in Excel. You’ll learn V and H lookup, CountIf and SumIf and database functions. You’ll work with charts, graphs, filters and lists, import different file formats (like XML data) and track changes in a spreadsheet.

  • This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You'll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.

Instructor

Profile photo of eLearnExcel
eLearnExcel

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms. Some of the world’s most prominent businesses choose us to teach their employees Excel – including...

Review
4.9 course rating
4K ratings
ui-avatar of Chris Russell
Chris R.
5.0
2 years ago

Great job very easy to understand.

  • Helpful
  • Not helpful
ui-avatar of Sunny Ovbiagele James
Sunny O. J.
4.5
5 years ago

It was helpful knowing different tools in Microsoft Excel.

  • Helpful
  • Not helpful
ui-avatar of Piotr Witkowski
Piotr W.
3.0
7 years ago

This is an old version of Excel. I have to keep on looking for new locations of the explained options in the new version

  • Helpful
  • Not helpful
ui-avatar of Janet Landis
Janet L.
5.0
8 years ago

Great information. Teaching was excellent!

  • Helpful
  • Not helpful
ui-avatar of Rose Canez
Rose C.
5.0
9 years ago

easy to follow and fun to learn! -Rose 6/24/16

  • Helpful
  • Not helpful
ui-avatar of Shiv Vembadi
Shiv V.
5.0
9 years ago

You can see that the instructor has years of experience from the quality of explanation of material. Whatever is covered (of course only the essentials are covered in this level). Material and explanation is clear as well.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses