Online Class: Excel 2013
We're sorry, this course is no longer open for enrollment.
-
20Lessons
-
22Exams &
Assignments -
11Hours
average time -
1.1CEUs
Course Description
Microsoft Excel 2013 is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating address books, mailing lists, grocery lists, tracking expenses, creating invoices and bills, doing financial accounting, balancing checkbooks, as well as any other purpose that requires a spreadsheet or table.
This course will teach you the skills you'll need to successfully use Excel 2013. Each lesson contains step-by-step instructions and explanations to show you how to use all the features, and also provides video tutorials on how everything is done. You don't need previous experience with Excel to be able to complete this course. This course will start with basic skills, then move forward to more advanced features and techniques.
In our Excel 2013 course, you'll learn how to:
· Create a spreadsheet
· Format cells, rows, columns, and entire worksheets so they fit and match your data
· Enter data into a spreadsheet
· Use formulas and functions for math, accounting, and totaling
· Create formulas and functions
· Create charts and diagrams for your data
· Create data lists and forms
· Create and use pivot tables and pivot charts
· Work with Excel templates
· Share and protect your worksheets and workbooks
· Use What-If Analysis to determine possible outcomes
· And much, much more
This course breaks up the most complex features of Excel into easy-to-understand blocks of information. Each lesson is a building block that moves you one step closer to using Excel like a pro – which you will be by the end of this course. Even if you're new to Excel, you're just 20 lessons away from having the advanced skills you need to use this amazing program.
- 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

Course Lessons
Lesson 1. Harnessing Excel 2013 for Modern Data Challenges
Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Motives for Taking this Course
Assessment: Lesson 1 Exam
Lesson 2. Excel 2013 Navigation Essentials
Lesson 2 Video
Assessment: Lesson 2 Exam
Lesson 3. Beyond the Basics: Exploring Excel Workbooks and Worksheets
Lesson 3 Video
Assessment: Lesson 3 Exam
Lesson 4. Distilling Data into Excel with Precision
Lesson 4 Video
Assessment: Lesson 4 Exam
Lesson 5. Fundamentals of Excel: Cells, Rows & Columns
Lesson 5 Video
Assessment: Lesson 5 Exam
Lesson 6. Transform Your Data Presentation
Lesson 6 Video
Assessment: Lesson 6 Exam
Lesson 7. Excel Formatting Mastery: From Columns to Rows
Lesson 7 Video
Assessment: Lesson 7 Exam
Lesson 8. Navigating Excel: Mastering Cell and Worksheet Editing
Lesson 8 Video
Assessment: Lesson 8 Exam
Lesson 9. Excel's Formula Magic: Streamline Workflows and Reduce Errors
Lesson 9 Video
Assessment: Lesson 9 Exam
Lesson 10. Excel Formulas 101
Lesson 10 Video
Assessment: Lesson 10 Exam
Lesson 11. A Journey Toward Excel Mastery
Lesson 11 Video
Assessment: Lesson 11 Exam
Lesson 12. Forecasting with Excel: Exploring the What-If Analysis Toolbox
Lesson 12 Video
Assessment: Lesson 12 Exam
Lesson 13. Excel Image Integration: Enhance Your Data with Graphics
Lesson 13 Video
Assessment: Lesson 13 Exam
Lesson 14. Excel Insights: Crafting Effective Visual Narratives
Lesson 14 Video
Assessment: Lesson 14 Exam
Lesson 15. Harnessing Data Lists for Actionable Insights: Transform Information into Success
Lesson 15 Video
Assessment: Lesson 15 Exam
Lesson 16. Optimizing Your Data Entry Process with Excel Forms
Lesson 16 Video
Assessment: Lesson 16 Exam
Lesson 17. Mastering Data with Pivot Efficiency
Lesson 17 Video
Assessment: Lesson 17 Exam
Lesson 18. Excel Printing Unleashed: From Page Layout to Precision Output
Lesson 18 Video
Assessment: Lesson 18 Exam
Lesson 19. Elevate Your Workflow with Customizable Excel Templates
Lesson 19 Video
Assessment: Lesson 19 Exam
Lesson 20. Mastering the Art of Data Protection, Saving, and Sharing in Excel
Lesson 20 Video
Lesson discussions: End of Course Poll; Reasons for Taking this Course; Course Comments
Assessment: Lesson 20 Exam
Assessment: The Final Exam
Learning Outcomes
- Describe what a spreadsheet is and what Excel 2013 can do.
- Demonstrate navigation, creating workbooks and worksheets, and entering information into Excel 2013
- Demonstrate working with cells, rows, and columns in Excel.
- Demonstrate formatting data in cells and how to format rows and columns.
- Demonstrate editing cells, rows, columns, and worksheets.
- Demonstrate creating and using formulas and calculations.
- Demonstrate using the What-If Analysis.
- Demonstrate adding images, graphics, charts and diagrams.
- Demonstrate creating data lists and managing data.
- Demonstrate Pivot Table and chart usage.
- Summarize creating and using templates in Excel 2013.
- Demonstrate printing, protecting, saving, and sharing workbooks in Excel.
- Demonstrate mastery of lesson content at levels of 70% or higher.
Student Testimonials
- "This course was very helpful to improve English grammar." -- Ahmadzia F.
- "I like how the chapters are broken down...allowed me to learn about different aspects in a step-by-step format." -- Margaret M.
- "Wonderful!" -- Candace H.
- "Excellent course, Excellent instructor, Excellent experience!!! I thought I already knew Excel but I learned a great deal...Thank you UniversalClass for offering this course!" -- Becky A.
- "Instructor was quick to mark my work which encourages progress!" -- CAROLE C.
- "The best part was watching the videos. I was able to watch the videos and do what the instructor was doing at the same time. I learn better by actually doing it." -- Ashley S.
- "Loved the instructor; overall just perfect with his instruction and pace of each class. Instructor was easy to follow and understand; making this a great class. I really enjoyed it!" -- Cynthia G.
- "The instructor was very good...he made learning the class easier than I expected it to be." -- Cynthia G.
- "The instructor's Lesson Plans were Great!" -- Diane B.
Related Courses
-
26 hours 2.6 CEUs Ultimate Excel Training Bundle + More Info
-
20 hours 2.0 CEUs Photoshop Elements 101 + More Info
-
7 hours 0.7 CEUs Microsoft Excel Level 3 + More Info
-
7 hours 0.7 CEUs Google Slides + More Info
-
6 hours 0.6 CEUs Google Docs + More Info
-
7 hours 0.7 CEUs Google Sheets + More Info
-
6 hours 0.6 CEUs Microsoft Publisher Level 1 + More Info
-
7 hours 0.7 CEUs Microsoft Word Level 1 + More Info
-
12 hours 1.2 CEUs Microsoft Excel Level 1 + More Info
-
9 hours 0.9 CEUs Microsoft Project Level 1 + More Info
-
8 hours 0.8 CEUs Microsoft PowerPoint Level 1 + More Info
-
4 hours 0.4 CEUs Slack + More Info
-
5 hours 0.5 CEUs Microsoft Outlook Level 1 + More Info
-
7 hours 0.7 CEUs Microsoft Visio Level 1 + More Info
-
14 hours 1.4 CEUs QuickBooks Online + More Info