Online Class: Excel 2013

Name: Excel 2013
Price: 95.00 USD

$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.

20

Lessons
22

Exams &
Assignments
8,737

Students
have taken this course
11

Hours
average time
1.1

CEUs

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.

Courses Frequently Bought Together:

QuickBooks 101

Adobe Photoshop

Microsoft Office: Word, Excel, PowerPoint and Outlook

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:

"Extraordinarily Helpful"

(6,150 votes)

Lesson 1: Harnessing Excel 2013 for Modern Data Challenges

12 Points

I'm sorry, but I can't create alternate summaries of the lesson since the lesson wasn't provided in a concise format for summarization. If you have a specific text or a more concise version of the lesson, feel free to provide it, and I'll be happy to help!

Lesson 1 Video
Review 2 Practice Worksheets
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Motives for Taking this Course
Assessment: Lesson 1 Exam

Lesson 2: Excel 2013 Navigation Essentials

9 Points

With its array of keyboard shortcuts and touch-friendly features, Excel 2013 offers flexible navigation across cells and sheets, optimizing data handling for all users. These quick commands enhance productivity, turning Excel into a dynamic tool for data-driven workspaces.

Lesson 2 Video
Review 2 Practice Worksheets
Assessment: Lesson 2 Exam

Lesson 3: Beyond the Basics: Exploring Excel Workbooks and Worksheets

10 Points

Modern Excel includes advanced functions like conditional formatting, pivot tables, and real-time collaboration through cloud services, streamlining data analysis and enhancing teamwork across geographical boundaries. Staying informed about these evolving features ensures competitive advantage in data-driven decision-making.

Lesson 3 Video
Review 2 Practice Worksheets
Assessment: Lesson 3 Exam

Lesson 4: Distilling Data into Excel with Precision

10 Points

Excel offers advanced functionalities like relative, absolute, and mixed references in formulas, ensuring flexibility and consistency across spreadsheets. Power users can harness these features alongside functions like SUM and AVERAGE for insightful data interpretations.

Lesson 4 Video
Review 2 Practice Worksheets
Assessment: Lesson 4 Exam

Lesson 5: Fundamentals of Excel: Cells, Rows & Columns

10 Points

Artful copying of cells can transform data management, allowing efficient synthesis of reports by replicating crucial data. Excel's copy feature, accessible through multiple pathways, extends over entire rows and columns, promoting uniform data handling.

Lesson 5 Video
Review 2 Practice Worksheets
Assessment: Lesson 5 Exam

Lesson 6: Transform Your Data Presentation

10 Points

Excel's number formatting options keep data accurate and easy to understand by customizing the appearance of numerical entries. Preserving core values while presenting styled numbers fosters clarity and facilitates user-friendly interactions with the data.

Lesson 6 Video
Review 2 Practice Worksheets
Assessment: Lesson 6 Exam

Lesson 7: Excel Formatting Mastery: From Columns to Rows

9 Points

Understanding the intricacies of formatting rows and columns in Excel 2013 is crucial for enhancing both productivity and data presentation. Mastery of these tools allows for seamless integration of data, from financial reports to personal budgets, making the information both accessible and aesthetically pleasing.

Lesson 7 Video
Review Practice Worksheet: 8900203aa52957zz.png
Assessment: Lesson 7 Exam

Lesson 8: Navigating Excel: Mastering Cell and Worksheet Editing

8 Points

Excel’s 'Freeze Panes' feature allows users to maintain essential data visibility across large spreadsheets. Whether managing a comprehensive financial report or monitoring inventory levels, this functionality ensures key reference points remain constant, enhancing data clarity and navigation.

Lesson 8 Video
Review 2 Practice Worksheets
Assessment: Lesson 8 Exam

Lesson 9: Excel's Formula Magic: Streamline Workflows and Reduce Errors

10 Points

Excel's comprehensive formula features enhance accuracy and efficiency for data management and financial analysis through automation of calculations and error reduction. It empowers users to perform mathematical operations using a variety of operators, from basic arithmetic to complex comparisons and text concatenation.

Lesson 9 Video
Review 2 Practice Worksheets
Assessment: Lesson 9 Exam

Lesson 10: Excel Formulas 101

9 Points

Excel’s robust toolkit, including features like named constants and diverse referencing styles, simplifies complex data sets, paving the way for more intuitive analyses and collaboration. By mastering these elements, users enhance their proficiency in handling dynamic worksheets and enforce data consistency across multiple platforms.

Lesson 10 Video
Review 2 Practice Worksheets
Assessment: Lesson 10 Exam

Lesson 11: A Journey Toward Excel Mastery

10 Points

Leveraging AI and cloud integration within Excel showcases a new era of predictive analytics and dynamic data handling, elevating basic spreadsheets into a smart analytical and organizational tool. This innovation allows users to harness detailed insights, promoting agility and strategic foresight in business operations.

Lesson 11 Video
Review 2 Practice Worksheets
Assessment: Lesson 11 Exam

Lesson 12: Forecasting with Excel: Exploring the What-If Analysis Toolbox

10 Points

Scenarios in Excel enable users to evaluate multiple hypothetical situations within a single workbook by setting up various versions of a scenario, providing a comprehensive comparison of different strategies or business models. This tool is particularly useful for businesses launching new product lines, assessing potential under diverse assumptions like costs and market conditions.

Lesson 12 Video
Review 2 Practice Worksheets
Assessment: Lesson 12 Exam

Lesson 13: Excel Image Integration: Enhance Your Data with Graphics

10 Points

Excel offers dynamic tools for visual storytelling within data spreadsheets, such as inserting vibrant images and applying adjustments like rotations and borders for coherence. Creating consistent, contextually relevant visuals ensures professional presentations that engage audiences effectively.

Lesson 13 Video
Review 2 Practice Worksheets
Assessment: Lesson 13 Exam

Lesson 14: Excel Insights: Crafting Effective Visual Narratives

10 Points

Excel empowers users with a suite of charting tools to translate daunting data tables into engaging visual stories. From pie charts to sophisticated scatter plots, each visual aids in uncovering hidden insights and better communicating data-driven decisions to diverse audiences.

Lesson 14 Video
Review 2 Practice Worksheets
Assessment: Lesson 14 Exam

Lesson 15: Harnessing Data Lists for Actionable Insights: Transform Information into Success

10 Points

Data lists bridge the gap between raw information and strategic insights, aiding a diverse range of applications from business inventory management to personal projects. They offer capabilities such as data sorting, filtering, and seamless expansion, ensuring users can adapt to ever-evolving data needs.

Lesson 15 Video
Review Practice Worksheet: 8900203aa52965zz.png
Assessment: Lesson 15 Exam

Lesson 16: Optimizing Your Data Entry Process with Excel Forms

10 Points

Excel forms offer a transformative capability by allowing businesses and individuals to manage extensive datasets with precision and ease, addressing the issue of overwhelming data entry. Adding the Form button to the Quick Access Toolbar optimizes workflow by allowing seamless data input and updating with visual appeal.

Lesson 16 Video
Review 2 Practice Worksheets
Assessment: Lesson 16 Exam

Lesson 17: Mastering Data with Pivot Efficiency

10 Points

Slicers act like interactive filters within data representations, guiding users effortlessly to the insights they seek. This functional elegance mirrors tagged library sections, directing focus and enhancing productivity within expansive data 'collections.'

Lesson 17 Video
Review 2 Practice Worksheets
Assessment: Lesson 17 Exam

Lesson 18: Excel Printing Unleashed: From Page Layout to Precision Output

10 Points

Printing features within Excel allow accurate data presentation for various professional needs, from logistics planning to comprehensive presentations. Using collated printing and customizable options ensures output meets organizational requirements efficiently.

Lesson 18 Video
Review 2 Practice Worksheets
Assessment: Lesson 18 Exam

Lesson 19: Elevate Your Workflow with Customizable Excel Templates

10 Points

From budget tracking to project management, Excel’s vast template library offers solutions tailored to various needs, allowing users to swap placeholder data for their own. By embracing templates, users streamline tasks, enhancing both efficiency and consistency.

Lesson 19 Video
Review Practice Worksheet: 8900203aa52969zz.png
Assessment: Lesson 19 Exam

Lesson 20: Mastering the Art of Data Protection, Saving, and Sharing in Excel

54 Points

Saving workbooks regularly is essential to prevent data loss, offering options to save locally or via cloud services like OneDrive for flexible access. Utilizing features like 'Save As' ensures systematic organization and easy retrieval, fostering efficient data progression over time.

Lesson 20 Video
Review 2 Practice Worksheets
Lesson discussions: End of Course Poll; Reasons for Taking this Course; Course Comments
Assessment: Lesson 20 Exam
Assessment: The Final Exam

241

Total Course Points

Learning Outcomes

By successfully completing this course, students will be able to:

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.

Additional Course Information

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

Course Title: Excel 2013

Course Number: 8900203

Lessons Rating: 4.31 / 5 Stars (6,150 votes)

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Certification Courses

Availability: This course is fully available online in all 50 states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. It’s also offered in major English-speaking countries, such as the United Kingdom, Canada, Australia, and Ireland.

Last Updated: February 2023

Course Type: Self-Paced, Online Class

CEU Value: 1.1 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

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

Add to Cart

Billed once
This course only

Includes certificate	X
Includes CEUs	X
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Certificate Course

One Course
Certificate & CEUs

$120

for 6 months

Add to Cart

Billed once
This course only

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Platinum Yearly

ALL COURSES
Certificates & CEUs

$189

per year

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	12 Months
No. of courses	600+

Platinum 2 Years

ALL COURSES
Certificates & CEUs

$299

for 2 years

You save $79.00!

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	24 Months
No. of courses	600+

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.