What you'll learn
- Create and format a spreadsheet
- Organize and manage data
- Build and edit formulas and functions
- Create and modify charts and graphs
- Create and modify pivot tables and pivot charts
Requirements
- No prior spreadsheet knowledge required. Must have Microsoft Excel version 2007 or later.
Description
Microsoft Excel for Beginners is an introductory spreadsheet course. The target audience for this course is anyone with little or no experience using Microsoft Excel. Lesson content will be explained and presented in a way that is easy to understand and follow. This class includes 8 lessons: Orientation & Basics, Formatting & Printing, Organizing & Managing Data, Formulas & Functions (Level 1), Formulas & Functions (Level 2), IF Statements & IF Functions, Charts & Graphs, and Pivot Tables & Pivot Charts. With each lesson you will be provided with an Excel learning file, a PDF of the lesson, a video that explains and demonstrates each concept in the lesson and a 10 question multiple choice quiz. Upon completion of this course you will be able to effectively analyze, organize, manage and visually display data in an Excel spreadsheet.
Learning Microsoft Excel will provide a solid foundation for learning other spreadsheet programs such as: Google Sheets, Numbers, Smartsheet, Zoho Sheet, and LibreOffice. According to Forbes Magazine, 54% of all businesses use Microsoft Excel in some way; this number does not take into account other spreadsheet programs that are also used.
As our world becomes more and more data driven, it is necessary to develop skills that enable us to better understand, interact with, and manage data.
Who this course is for:
- Entry level users who what to learn how to organize and manage data in Excel
Instructor
![Patricia Hill](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.8 Instructor Rating
- 6 Reviews
- 14 Students
- 1 Course
I have 22 years of experience in the field of education. Throughout my career, I have worn many hats; technology/business teacher, technology integration specialist, adjunct professor, senior project coordinator, and assistant principal.
I have taught a wide range of technology and business classes to students in grades PK-12 and I hold many teaching and technology certifications. I love teaching technology because I enjoy showing people how technology can make most tasks easier and more fun.
Courses that I have taught include: Microsoft Office Applications, Google Education Apps, Internet Safety, Digital Citizenship, Computing Fundamentals, Computer Science Discoveries, Computer Science Principles, Data Analysis, Cybersecurity, Business Ethics, Business Management, Business Math, Marketing, Financial Literacy, Career Readiness, Resume Writing, and Senior Project.