Online Class: Microsoft Excel Level 1

Excel Level 1 is a comprehensive online course that starts with the basics then covers advanced features like formulas, data visualization, PivotTables, and automation with macros. This course offers a dynamic, interactive learning experience with practical applications and ends with a certification, making it ideal for both professionals and beginners looking to master Excel's latest version.

$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.
 
  • 14
    Lessons
  • 16
    Exams &
    Assignments
  • 11,452
    Students
    have taken this course
  • 12
    Hours
    average time
  • 1.2
    CEUs
 
 
 

Course Description

Welcome to our comprehensive online Microsoft Excel course, designed to guide you through mastering one of the most essential tools in data management and analysis. Microsoft Excel, also known as Excel for Microsoft 365 in the subscription-based model, is a powerful spreadsheet software widely used across various industries for storing, organizing, sorting, calculating, and visually representing data. Whether you're a seasoned professional looking to enhance your skills or a beginner eager to learn, this course offers a tailored learning experience that covers the latest version of Excel, ensuring you're up-to-date with the newest features and functionalities.

Course Overview:

Our course begins with the fundamentals, introducing you to Excel's interface and core features. You'll learn how to navigate through the world of spreadsheets, understand the layout, and customize your workspace. We'll then delve into the anatomy of Excel, exploring workbooks and efficient data management techniques. This includes understanding how to input, modify, and organize data in a logical and accessible manner.

As you progress, the course emphasizes the importance of styling and maintaining data integrity. This section covers various formatting rules and techniques that not only enhance the readability of your data but also ensure accuracy and consistency. You'll discover how to apply conditional formatting to highlight critical data points and use built-in styles to create professional-looking spreadsheets.

Advanced Excel Features:

Moving into more advanced territory, we focus on the power of formulas and functions – the backbone of Excel. You'll learn how to write basic and complex formulas to perform calculations, automate tasks, and analyze large datasets. Real-world examples will help you grasp concepts like VLOOKUP, INDEX-MATCH, and nested IF statements.

Visual representation of data is key in today's information-driven world. Our course includes detailed tutorials on adding images, graphics, and crafting compelling charts and diagrams. These lessons are designed to transform your raw data into visually engaging presentations that tell a story and make an impact.

For those interested in data analysis, we cover essential tools like PivotTables, PivotCharts, and What-If Analysis. These powerful features allow you to sift through and interpret large volumes of data, uncover trends, and make informed decisions. You'll learn how to summarize data in meaningful ways and create dynamic reports that adapt to new data.

Excel for Automation and Integration:

As you become more proficient, the course introduces automation with macros. This section teaches you how to record and write macros to automate repetitive tasks, increasing efficiency and accuracy. We also explore how Excel integrates with external data sources, expanding its capabilities beyond the spreadsheet.

Finally, we delve deep into mastering data organization. This includes advanced techniques in filtering, sorting, and applying conditional formatting to make data analysis more intuitive and insightful. You'll also get a comprehensive look at Excel's text manipulation functions and conditional logic, equipping you with skills to manage and analyze text data effectively.

Why Choose Our Excel Course?

  1. Current and Comprehensive Content: Our course content is regularly updated to include the latest Excel features, ensuring you're learning the most current and relevant skills.

  2. Practical and Real-World Applications: Each lesson is packed with practical examples and real-world scenarios, helping you apply what you learn immediately.

  3. Interactive Learning Experience: With a mix of beautifully illustrated lessons, HD video tutorials, and lesson assessments our course offers a dynamic learning experience that caters to different learning styles.

  4. Flexible Learning: Our online format allows you to learn at your own pace, making it perfect for busy professionals and students.

  5. Certification: Upon completion, receive a certificate that validates your proficiency in Microsoft Excel, enhancing your professional credibility.

Conclusion:

This course is more than just a learning journey; it's an opportunity to empower yourself with the skills to efficiently and effectively manage data. Whether your goal is to advance your career, streamline your business processes, or simply gain a valuable skill set, our Microsoft Excel course is a gateway to achieving these objectives. Enroll today and take the first step towards becoming an Excel power user.

  • 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.53 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(589 votes)

Lesson 1: Excel Basics - Navigating the World of Spreadsheets

11 Points
Dive into the essentials of Microsoft Excel, uncovering the mysteries of spreadsheets and their practical applications. Learn why mastering Excel is a vital skill in today's data-driven world. Additional lesson topics: New Features in Microsoft Excel; Learn Excel The Easy Way; Quick Excel Tutorial
  • Lesson 1 Video
  • Lesson discussions: Your Excel Course Goals
  • Complete Assignment: An Introduction
  • Assessment: Lesson 1 Exam

Lesson 2: The Anatomy of Excel: Workbooks and Data Management

18 Points
Explore the core components of Excel 365: workbooks and worksheets. Delve into Excel's terminology, data organization principles, and the fundamentals of data entry and editing. Additional lesson topics: Understanding the Worksheet Window; How to Create a Workbook; Learn About Multiple Workbooks, Worksheets, and Views
  • Lesson 2 Video A
  • Lesson 2 Video B : Entering Data
  • Assessment: Lesson 2 Exam

Lesson 3: Styling and Data Integrity in Excel

18 Points
Discover the art of data presentation in Excel. Learn how to format cells, ensure data accuracy, and create references to enhance data usability and appearance. Additional lesson topics: Formatting Numbers and Labels; Conditional Formatting in Excel; Creating and Managing Cell Styles
  • Lesson 3 Video
  • Assessment: Lesson 3 Exam

Lesson 4: Advanced Editing Techniques in Excel

20 Points
Advance your Excel skills with in-depth editing techniques. Learn about comment management, cell protection, and the intricacies of modifying columns, rows, and cells. Additional lesson topics: How to edit columns, rows, and cells in Excel; Editing cell contents; How to lock and protect cells; How to add, edit and delete comments
  • Lesson 4 Video
  • Assessment: Lesson 4 Exam

Lesson 5: The Power of Formulas and Functions

20 Points
Unlock Excel 365's full potential through its formula and function capabilities. This lesson will guide you through creating accurate and efficient calculations, enhancing your data analysis skills. Additional lesson topics: How to Enter Basic Formulas; Starting Working with Function such as Sum and Average
  • Lesson 5 Video A
  • Lesson 5 Video B : Formulas and Calculations
  • Assessment: Lesson 5 Exam

Lesson 6: Visual Impact: Adding Images and Graphics to Spreadsheets

20 Points
Enhance your spreadsheets with visual elements. Learn to insert and manage images and graphics in Excel 365, making your data not just informative but visually appealing. Additional lesson topics: How to Use and Insert Online Pictures; How to Use Copy, Cut, and Paste
  • Lesson 6 Video A
  • Lesson 6 Video B : Working with Graphics
  • Assessment: Lesson 6 Exam

Lesson 7: Crafting Compelling Charts and Diagrams

20 Points
Master the art of visual data representation in Excel. This lesson covers creating insightful charts and diagrams directly from your spreadsheet data. Additional lesson topics: Basic Chart Creation Tutorial; Using Recommended Charts in Excel
  • Lesson 7 Video A
  • Lesson 7 Video B : Working with Charts and Diagrams
  • Assessment: Lesson 7 Exam

Lesson 8: Exploring What-If Analysis

20 Points
Dive into scenario planning with Excel's What-If Analysis tools. Learn how to simulate different outcomes and make informed decisions based on varying data scenarios. Additional lesson topics: How to Show Show; How to Create Scenarios; What-If Analysis Overview
  • Lesson 8 Video
  • Assessment: Lesson 8 Exam

Lesson 9: Data Management Mastery: Lists and Forms

12 Points
Excel is not just about numbers; it's about data integrity. Learn the best practices for data entry using lists and forms to ensure accuracy and clarity in your spreadsheets. Additional lesson topics: How to Create and Format Tables; Understanding Data Validation; How to Create Drop-Down lists in Excel
  • Lesson 9 Video A
  • Lesson 9 Video B : Managing Data
  • Assessment: Lesson 9 Exam

Lesson 10: PivotTables and Charts: Data Analysis Essentials

15 Points
Build upon your data list knowledge to create dynamic PivotTables and Charts. This lesson will teach you how to analyze and present data in a compelling and easy-to-understand format. Additional lesson topics: Focus on PivotCharts; How to Use PivotTables to Analyze Data
  • Lesson 10 Video
  • Assessment: Lesson 10 Exam

Lesson 11: Automating Tasks with Macros

16 Points
Learn to streamline repetitive tasks in Excel using macros. This lesson will introduce you to creating, recording, and running macros to increase your efficiency. Additional lesson topics: Using Excel Templates; How to Run a Macro; Using Macros; Access Free Templates
  • Lesson 11 Video
  • Assessment: Lesson 11 Exam

Lesson 12: Integrating Excel with External Data Sources

12 Points
Expand your Excel capabilities by learning to import and export data from various sources. Understand how Excel interacts with other applications like Microsoft Access. Additional lesson topics: How to Import DOM Data into Excel; Exporting Workbooks As PDF Files; Import and Export Text Files .csv ; Export data to Excel
  • Lesson 12 Video
  • Assessment: Lesson 12 Exam

Lesson 13: Mastering Data Organization: Filters, Sorting, and Conditional Formatting

17 Points
Become proficient in organizing and presenting data in Excel. Learn advanced techniques for sorting, filtering, and applying conditional formatting to make your data stand out. Additional lesson topics: More on Conditional Formatting; Sorting Data Tutorial; How to Sort PivotTable Data in Excel
  • Lesson 13 Video
  • Assessment: Lesson 13 Exam

Lesson 14: Excel Function Deep Dive: Conditional Logic and Text Manipulation

50 Points
Explore the depth of Excel functions, focusing on conditional logic, date/time manipulation, and text functions. This lesson brings together advanced concepts to elevate your Excel proficiency. Additional lesson topics: Using Nested Formulas; Using the IF with AND, OR and NOT functions in Excel
  • Lesson 14 Video
  • Assessment: Lesson 14 Exam
  • Assessment: Final Exam
269
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 1
Course Number: 57700144
Lessons Rating: 4.53 / 5 Stars (589 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: With online access available nationwide, this course reaches all U.S. states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. Additionally, it’s open to learners in English-speaking countries such as the UK, Australia, Canada, and New Zealand.
Last Updated: June 2024
Course Type: Self-Paced, Online Class
CEU Value: 1.2 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+