What you'll learn

Understand the complete basics of Microsoft Excel

Learn what the different tabs do in Microsoft Excel

Learn what cells, rows, and columns are in Microsoft Excel

Learn the most commonly used formulas in Microsoft Excel

Requirements

No Excel experience needed. You will learn everything you need to know in the course.

Description

Summary of CourseThis course walks the complete beginner through Microsoft Excel from the very beginning. The course begins with opening an excel file and progresses to understanding the anatomy of a spreadsheet (columns, rows, and cells), understanding the different tabs, and finally diving into the most common used formulas. Along the way, the student is given examples of how each function or formula works. At the end of the course, there is an entire section dedicated to more examples - this is the real power of the course. Learning by example is the best way to learn and this course embodies that concept. The live examples section is set at a pace where the student can follow along in Excel and work through everything alongside me. This will bring someone from zero knowledge in Excel to an Intermediate level analyst that could ace the initial job recruiter Excel tests.Course ContentOpening an Excel FileColumns, Rows, and CellsHome TabFontAlignmentInsert TabPage Layout TabData TabFiltersText to ColumnsRemove DuplicatesReview TabView TabFreeze PanesIntroduction to FormulasThe XlookupThe IF StatementThe Subtotal FormulaDon't be afraid of excel - this course will teach you everything you need to know and more. You will become your company's subject matter expert in Excel!