Online Class: Microsoft Excel Level 2

"Microsoft Excel Level 2" is an advanced course focused on enhancing data management and analysis skills in Excel. This course is designed for both professionals and students, offering an in-depth understanding of Excel's capabilities in handling complex data, text manipulation, and integrating data across multiple worksheets, with practical applications in each lesson.

$95.00
no certificate
- OR -
$120.00
with CEU Certificate*
Start Right Now!
$120.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
  • 10
    Lessons
  • 11
    Exams &
    Assignments
  • 605
    Students
    have taken this course
  • 7
    Hours
    average time
  • 0.7
    CEUs
 
 
 

Course Description

Microsoft Office's Excel stands as a pinnacle of data management and analysis, offering unparalleled flexibility and efficiency for both individual users and businesses. Our course, "Microsoft Excel Level 2," is designed to guide you through the advanced capabilities of Excel, enabling you to harness its full potential for diverse and complex data handling needs.

Course Overview

The course provides an immersive experience in Excel, starting with the essential components of functions and data lookups. These initial lessons lay a foundational understanding of how Excel can perform advanced calculations and facilitate effective data importation.

In-Depth Lesson Breakdown

  1. Enhancing Spreadsheets with Outlines, Custom Views, and Templates: This lesson introduces Excel's built-in templates, which are equipped with pre-formulated outlines and functions, serving as a quick-start for any spreadsheet task. You'll learn to tailor views for more efficient data management and apply high-quality templates to various scenarios.

  2. Mastering Mathematical Functions in Excel: Here, we dive deep into Excel's mathematical prowess. Covering functions from the basic SUM to more complex ones like RAND, this lesson is designed to streamline your data computations and elevate your analytical capabilities.

  3. Advanced Data Analysis with Excel’s Information Functions: This segment focuses on Excel's data functions that are critical for detailed cell data analysis. Functions like ISBLANK and ISERROR are explored to provide a more nuanced understanding of your data.

  4. Efficient Data Searching: VLOOKUP, HLOOKUP, and Beyond: Excel's search functionalities are powerful tools for data retrieval. This lesson emphasizes on vertical and horizontal search techniques, empowering you to navigate and extract data efficiently.

  5. The Power of the IF Function: Decision Making in Excel: The versatility of the IF Function is unraveled in this lesson. You'll learn to construct complex calculations and employ Excel's logical formulas for dynamic data assessment and display.

  6. Text Manipulation Magic in Excel: Moving beyond numbers, this lesson explores Excel's capabilities in text manipulation. Functions like FIND and SUBSTITUTE are examined, revealing methods to dynamically format text for impactful data presentation.

  7. Dynamic Data Visualization with Conditional Formatting: This lesson teaches you how to bring your data to life using Excel's conditional formatting. You'll understand how to apply color schemes and styles based on formula results, transforming raw data into visually engaging information.

  8. Sparklines - Miniature Graphs for Data Trend Analysis: Delving into Excel's Sparklines, you'll learn how to create concise, informative mini-graphs within a cell, enhancing your data analysis and presentation.

  9. Linking and Consolidating Data Across Multiple Worksheets: Gain expertise in consolidating and retrieving data from various worksheets and workbooks. This lesson introduces techniques for seamless data integration, minimizing manual data entry.

  10. Importing and Refining Data in Excel: Master the skills of importing and refining various forms of data. This final lesson teaches the use of advanced tools like Goal Seek and Scenario Manager for sophisticated data analysis.

Why Choose This Course?

This course is a journey through Excel's advanced features, designed not just to educate but to empower. Whether you're a professional seeking to enhance your skillset or a student aspiring to excel in data management, this course offers a comprehensive, hands-on approach to mastering Excel.

Enroll now and transform your data handling capabilities with this advanced Excel class.

  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 
 

Course Lessons

Average Lesson Rating:
4.49 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(86 votes)

Lesson 1: Enhancing Spreadsheets with Outlines, Custom Views, and Templates

12 Points
Discover the power of Excel's built-in templates, complete with pre-formulated outlines and functions, to jumpstart your spreadsheet designs. Learn to customize views for streamlined data management and apply professional-grade templates for various applications. Additional lesson topics: Excel Templates; How to Use Excel Custom Views Like a Pro; Microsoft Excel Inside Out
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete Assignment: Introduce Yourself
  • Assessment: Lesson 1 Exam

Lesson 2: Mastering Mathematical Functions in Excel

20 Points
Dive into the world of Excel's mathematical functions. From basic sums to advanced calculations, this lesson covers how to leverage Excel's built-in functions, including AVERAGE, SUM, and RAND, to streamline your data computations. Additional lesson topics: SUM function; How to Use the RAND and RANDBETWEEN Functions in Excel; AVERAGE function; Countif function; Excel functions alphabetical
  • Lesson 2 Video
  • Assessment: Lesson 2 Exam

Lesson 3: Advanced Data Analysis with Excel's Information Functions

20 Points
Explore Excel's data functions for insightful cell data analysis. Learn to use functions like ISBLANK and ISERROR to glean error, numerical, and type information, enhancing your data interpretation skills. Additional lesson topics: ERROR.TYPE function; Excel ISBLANK Function; Excel ISERROR Function; Excel TYPE Function; Excel ISREF Function; Excel ISNUMBER Function
  • Lesson 3 Video
  • Assessment: Lesson 3 Exam

Lesson 4: Efficient Data Searching: VLOOKUP, HLOOKUP, and Beyond

20 Points
Excel's search capabilities are powerful tools in data analysis. This lesson focuses on vertical, horizontal, and multi-dimensional search methods, teaching you to adeptly navigate and extract data with functions like VLOOKUP and HLOOKUP. Additional lesson topics: Excel VLOOKUP Function; HLOOKUP function
  • Lesson 4 Video
  • Assessment: Lesson 4 Exam

Lesson 5: The Power of the IF Function: Decision Making in Excel

20 Points
Uncover the versatility of the IF Function for conditional data display and complex calculations. Learn to craft intricate, embedded calculations and utilize Excel's logical formulas for dynamic data evaluation and presentation. Additional lesson topics: Excel IF Function; Conditional Formulas in Excel and Tricks Using the IF Function in Excel; Excel Nested IF statement; Excel Logical Formulas
  • Lesson 5 Video
  • Assessment: Lesson 5 Exam

Lesson 6: Text Manipulation Magic in Excel

19 Points
Excel isn't just for numbers. Learn to master text manipulation with functions like FIND and SUBSTITUTE, and discover how to dynamically style text for impactful data presentation. Additional lesson topics: Change the case of text; Excel FIND Function; Functions LEFT, MID; Excel SUBSTITUTE Function
  • Lesson 6 Video
  • Assessment: Lesson 6 Exam

Lesson 7: Dynamic Data Visualization with Conditional Formatting

20 Points
Bring your data to life with Excel's conditional formatting. Understand how to apply color schemes and styles based on formula results, turning raw data into visually compelling information. Additional lesson topics: Analyze and format in Excel; Conditional Formatting
  • Lesson 7 Video
  • Assessment: Lesson 7 Exam

Lesson 8: Sparklines - Miniature Graphs for Data Trend Analysis

20 Points
Delve into Excel's unique Sparklines feature for in-cell data visualization. Learn how to create succinct, informative mini-graphs to enhance your data analysis and presentation. Additional lesson topics: Excel Sparklines; Use formulas with conditional formatting; Use sparklines to show data trends
  • Lesson 8 Video
  • Assessment: Lesson 8 Exam

Lesson 9: Linking and Consolidating Data Across Multiple Worksheets

20 Points
Gain expertise in consolidating and retrieving data from various worksheets and workbooks in Excel. Learn techniques for seamless data integration, reducing the need for manual data entry. Additional lesson topics: Consolidate Data in Excel
  • Lesson 9 Video
  • Assessment: Lesson 9 Exam

Lesson 10: Importing and Refining Data in Excel

20 Points
Master the skills of importing and cleaning various data forms in Excel. Learn to efficiently manage and refine imported data, utilizing tools like Goal Seek and Scenario Manager for sophisticated data analysis. Additional lesson topics: Goal Seek and What-If Analysis; How to Use Scenario Manager
  • Lesson 10 Video
  • Assessment: Lesson 10 Exam
191
Total Course Points
 

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
 
Course Title: Microsoft Excel Level 2
Course Number: 57700145
Lessons Rating: 4.49 / 5 Stars (86 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: This course is available online in all U.S. states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. It’s also offered in English-speaking countries, including the UK, Canada, Australia, and New Zealand.
Last Updated: April 2024
Course Type: Self-Paced, Online Class
CEU Value: 0.7 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Instructor: Joseph Gohl
Syllabus: View Syllabus
Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$95
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$120
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
 
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+
 

Related Courses