Microsoft Excel: Beginners to Advanced (All-In-One)

Microsoft Excel: Beginners to Advanced (All-In-One)

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.

It 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:

• 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

Go From No Knowledge to Using Formulas to Make Your Office Work Quicker and Easier

Url: View Details

What you will learn

• Learn Excel from beginners to advanced
• Learn basic and advanced functions and formulas
• Understand how to perform tasks quicker and easier

Rating: 0

Level: All Levels

Duration: 5 hours

Instructor: Cheriamor Houston