Microsoft Excel: Beginners to Advanced (All-In-One)
What you'll learn
- Learn Excel from beginners to advanced
- Learn basic and advanced functions and formulas
- Understand how to perform tasks quicker and easier
- Learn how to apply knowledge to real-world work projects
- Gain confidence through knowledge
- Gain knowledge that you can use in almost any field!
Requirements
- No prior knowledge or experience is required to take this course.
Description
This course is a detailed, all-inclusive curriculum in Microsoft Excel. It is outlined in 3 parts: Beginners/Navigating Excel, Next Level (working with databases), and Advanced Functions and Formulas.
There are a little more than 50 videos of step-by-step instruction on how to navigate Excel, how to do highly desired tasks, and how to use functions and formulas to automate certain tasks to make your work quicker and easier. ***This course begins at a very basic level, and works its way up!*** Please keep that in mind before you purchase. If you need something a little more advanced, although you may enjoy the functions and formulas section, you may want to consider my From Staff to Management course which covers budget creation, automating numbers across multiple worksheets, data visualization, working with grants, databases/spreadsheets, etc.
This Beginners to Advanced course includes a downloadable Customizable Study Guide to help you get through the course in less than 1 month (if you so desire), a Shortcuts Guide, and downloadable optional assignments to practice what you learn.
What You’ll Learn In This Course:
From basic knowledge to fun things in working with databases, to advanced functions and formulas (3-part course for one price)
Navigating Excel
Course is taught using sample projects
Formulas are taught using real-work world scenarios for office jobs
Basic & Advanced functions and formulas, such as XLOOKUP, TRANSPOSE, SUMPRODUCT, different COUNT, SUM, and DATE functions, and more.
Intro to Pivot Tables
Finding, Removing, and Preventing Duplicate Data
Formatting to Print on one sheet
Creating drop-down lists
Freezing panes
Sorting data
Splitting text from one column into two
Merging text from two columns into one
Calculating age
Adding checkmarks, checkboxes, and progress marks
Easy-to-understand, step-by-step instructions
This Course Includes:
Over 50 videos of instruction
A Customizable Study Plan to help you keep track and finish what you start to get your money’s worth
Downloadable files to follow along and practice (optional)
50 Excel Shortcuts Guide
Certificate of Completion
Who this course is for:
- Beginners and anyone who wishes to advance their knowledge in Microsoft Excel.
Instructor
- 3.7 Instructor Rating
- 5 Reviews
- 13 Students
- 2 Courses
Cheriamor Houston is a Program Coordinator and former Development Manager and Administrator with over 20 years in the nonprofit sector. She has worked in many facets of nonprofit and managed multiple projects. Cheriamor’s areas of experience in nonprofit include community engagement, social media marketing, office administration, special and annual events, graphic design, volunteer coordination, human resources, and fundraising management, using Excel in many of these capacities. Cheriamor has led a number of training courses, including a series in Excel. She has a Master’s of Nonprofit Administration and three non-profit certificates.