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

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

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.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 ExcelCourse is taught using sample projectsFormulas are taught using real-work world scenarios for office jobsBasic & Advanced functions and formulas, such as XLOOKUP, TRANSPOSE, SUMPRODUCT, different COUNT, SUM, and DATE functions, and more.Intro to Pivot TablesFinding, Removing, and Preventing Duplicate DataFormatting to Print on one sheetCreating drop-down listsFreezing panesSorting dataSplitting text from one column into twoMerging text from two columns into oneCalculating ageAdding checkmarks, checkboxes, and progress marksEasy-to-understand, step-by-step instructionsThis Course Includes:Over 50 videos of instructionA Customizable Study Plan to help you keep track and finish what you start to get your money’s worthDownloadable files to follow along and practice (optional)50 Excel Shortcuts GuideCertificate of Completion

Overview

Section 1: Introduction

Lecture 1 Introduction: Course Content

Lecture 2 NEW: Specialized Study Plan

Section 2: Navigating Excel

Lecture 3 Introduction to Navigating Excel

Lecture 4 Adding and Scrolling Worksheets

Lecture 5 Worksheet vs. Workbook

Lecture 6 Naming and Coloring Tabs

Lecture 7 Moving and Copying Worksheets

Lecture 8 Zooming and Page View Options

Lecture 9 Cells and Gridlines

Lecture 10 Navigating the Ribbon

Lecture 11 Save vs. Save As

Section 3: Beginners Knowledge

Lecture 12 Adjusting Column Sizes and Wrapping Text

Lecture 13 Calculations: Using the SUM Function

Lecture 14 Calculations: Adding and Multiplying

Lecture 15 Highlighting Cells, Merging Cells, and Changing Row Height

Lecture 16 Borders, Frames, Aligning Text, and Adding Color

Lecture 17 Adding Columns and Rows, and Sorting I: Alphabetizing

Lecture 18 Formulas: Finding Averages. Adding Hyperlinks

Lecture 19 Adding Notes and Comments. Duplicating and Moving Content.

Lecture 20 Formulas: Subtracting, Dividing, Adding. Introducing Tables and Charts.

Lecture 21 Page Layout, Headers, Footers, and Page Numbers

Lecture 22 Formatting to Print on One Page. Saving As a PDF.

Lecture 23 DOWNLOAD: Assignments List I (Optional)

Lecture 24 DOWNLOAD: Assignment Workbook I (Optional)

Section 4: Next Level: Intermediate (Office Tips and Knowledge)

Lecture 25 Introduction to Section

Lecture 26 Creating a Dropdown List

Lecture 27 Date Format Options and Calculating Age.

Lecture 28 Working With Payment Balances

Lecture 29 Adding Checkmarks and Checkboxes. Numbering Sequentially.

Lecture 30 Finding and Removing Duplicates

Lecture 31 Preventing Duplicates

Lecture 32 Freezing Panes

Lecture 33 Sorting II: Numerical Data

Lecture 34 Introduction to Pivot Tables

Lecture 35 Protecting and Unprotecting

Lecture 36 DOWNLOAD: Assignments List II (Optional)

Lecture 37 DOWNLOAD: Assignments Workbook II (Optional)

Section 5: Advanced Functions and Formulas

Lecture 38 Functions vs. Formulas

Lecture 39 Review of Basic Functions and Formulas

Lecture 40 IF

Lecture 41 COUNT

Lecture 42 COUNTIF

Lecture 43 COUNTIFS

Lecture 44 COUNTA

Lecture 45 SUMIF

Lecture 46 SUMIFS

Lecture 47 DATE & DATEIF

Lecture 48 SUMPRODUCT

Lecture 49 ROUND

Lecture 50 Surprise Content!

Lecture 51 CONCATENATE

Lecture 52 Extra Content: Separating Text From 1 to 2 Columns

Lecture 53 TRANSPOSE

Lecture 54 LOOKUP

Lecture 55 XLOOKUP: Primary Features of XLOOKUP

Lecture 56 XLOOKUP: Previous Functions and Syntax

Lecture 57 XLOOKUP: Example of Use

Lecture 58 XLOOKUP: Review of Guidelines on General Use of XLOOKUP

Lecture 59 XLOOKUP: If Not Found Argument

Lecture 60 XLOOKUP: Extra Pointer

Section 6: Additional Quick Tips/Short Tutorials (Videos Only)

Lecture 61 Add Times to a Meeting or Event Schedule QUICKLY!

Lecture 62 Add Days and Months QUICKLY, Without Typing All Individually!

Lecture 63 QUICK Count Options/Number Rows of Data!

Section 7: DOWNLOAD: EXTRA: 50 Shortcuts Guide

Lecture 64 DOWNLOAD: 50 Excel Shortcuts Guide

Beginners and anyone who wishes to advance their knowledge in Microsoft Excel.