Microsoft Excel Basic To Advanced: A Complete Learning Path

Master Microsoft Excel from the ground up, covering essential basics to advanced techniques in this comprehensive course

What you'll learn

Create and Open Workbook

Tabs and Ribbon

Errors Functions

AND, OR, XOR, SWITCH, CELL Functions

IF and Nesting IF() Functions

Filter Functions

DATE and DATEVALUE Functions

Convert Time Hours, Minutes and Seconds

COUNT, ROUND, SUM, AVERAGE Functions

Subtotal and Power Functions

INT & TRUNC Function

Find and Replace

LEN, MID, REPT, SPLIT, TEXT and TRIM

INDEX, MATCH, EXACT Functions

VLOOKUP, HLOOKUP and XLOOKUP Functions

Exact match vs Approximate match

Import Data Web to Excel

Convert Number to Word

Dynamic dropdown List

Dependent dropdown List

Charts & Graphs

Sort and Filter Functions

Proetect Worksheet and Worksheet

Freeze and Split Panes

Headers and Footers

Page settings

Set Print Area

Requirements

No Prior Experience Required

Description

Master the power of Microsoft Excel with this comprehensive course that guides you from beginner-level basics to advanced techniques. Whether you're just starting with Excel or aiming to enhance your skills for work, this all-inclusive course covers everything you need to become a proficient Excel user and take on complex tasks with confidence.What You’ll Learn:Excel Fundamentals: Navigate the Excel interface, understand spreadsheets, and perform basic tasks such as data entry, formatting, and calculations.Formulas and Functions: Gain a strong grasp of Excel’s core formulas and functions, including SUM, AVERAGE, VLOOKUP, and IF statements, to perform essential calculations and data analysis.Data Visualization: Create compelling charts and graphs to visually present data, and apply conditional formatting to highlight trends and patterns.PivotTables and PivotCharts: Dive deep into PivotTables and PivotCharts for summarizing large datasets, making it easier to extract insights and report findings.Data Analysis and Validation: Use Excel’s built-in data analysis tools like Goal Seek, Solver, and Data Validation to enhance decision making and streamline your workflow.Macros and Automation: Automate repetitive tasks by recording and running macros, making your Excel processes more efficient and productive.Advanced Excel Techniques: Learn more advanced features such as What If Analysis, INDEX & MATCH, and Power Query for handling large datasets and performing complex tasks.This Course Includes:Create and Open WorkbookTabs and RibbonErrors FunctionsAND, OR, XOR, SWITCH, CELL FunctionsIF and Nesting IF() FunctionsFilter FunctionsDATE and DATEVALUE FunctionsConvert Time Hours, Minutes and SecondsCOUNT, ROUND, SUM, AVERAGE FunctionsSubtotal and Power FunctionsINT & TRUNC FunctionFind and ReplaceLEN, MID, REPT, SPLIT, TEXT and TRIMINDEX, MATCH, EXACT FunctionsVLOOKUP, HLOOKUP and XLOOKUP FunctionsExact match vs Approximate matchImport Data Web to ExcelConvert Number  to WordDynamic dropdown ListDependent dropdown ListCharts & GraphsSort and Filter FunctionsProtect Worksheet and WorksheetFreeze and Split PanesHeaders and FootersPage settingsSet Print AreaAnd Many MoresWhy Take This Course?Comprehensive Curriculum: From basic to advanced, this course is designed to build a complete set of Excel skills.Practical Applications: Real world examples and projects that enable you to apply your new skills immediately.Step-by-Step Learning: Lessons are structured to ensure gradual, effective learning, with clear instructions.By the end of this course, you will have mastered Excel from the basics to advanced features, making you a powerful and efficient Excel user. Enroll now and take your Excel skills to the next level!

Overview

Section 1: Introduction

Lecture 1 Create and open Workbook

Lecture 2 Tabs and Ribbon

Lecture 3 Errors Function

Lecture 4 AND() and OR() Function

Lecture 5 NOT() Function

Lecture 6 XOR() Function

Lecture 7 SWITCH() Function

Lecture 8 CELL() Function

Lecture 9 IFS() Functions

Lecture 10 Nesting IF() Functions

Lecture 11 Use IF function to calculate letter grades in Excel

Lecture 12 Use IFS function to calculate letter grades in Excel

Lecture 13 Use Filter Function in Excel

Lecture 14 DATE() Function

Lecture 15 DATEIF() Function

Lecture 16 EDATE Function

Lecture 17 EOMONTH Function

Lecture 18 DateValue Function

Lecture 19 TODAY and NOW Function

Lecture 20 Convert Time Hours, Minutes and Seconds

Lecture 21 Count Function

Lecture 22 Round Function

Lecture 23 Sum Function (SUM, SUMIF, SUMIFS, SUMPRODUCT)

Lecture 24 Average Function

Lecture 25 Subtotal Function

Lecture 26 Power Function

Lecture 27 Mod Function

Lecture 28 INT & TRUNC Function

Lecture 29 MAX(), MIN(), MAXA() and MINA() Function

Lecture 30 Find and Replace

Lecture 31 LEN Formulas

Lecture 32 MID Formulas

Lecture 33 Rept Formulas

Lecture 34 Split Formulas

Lecture 35 Text Formulas

Lecture 36 Trim Formulas

Lecture 37 Show Gridlines

Lecture 38 INDEX Function

Lecture 39 MATCH Function

Lecture 40 EXACT Function

Lecture 41 VLOOKUP APPROXIMATE MATCH Function

Lecture 42 VLOOKUP Function

Lecture 43 HLOOKUP Function

Lecture 44 XLOOKUP Function

Lecture 45 Exact match vs Approximate match

Lecture 46 Hyperlink

Lecture 47 How to import data web to excel

Lecture 48 Use DETECTLANGUAGE formula in google spread sheets

Lecture 49 How to convert number to word

Lecture 50 Dynamic Drop Down List

Lecture 51 Dependent dropdown List

Lecture 52 Charts & Graphs

Lecture 53 How to Use Pivot Tables

Lecture 54 Sort Function

Lecture 55 Filter Function

Lecture 56 Merge and Separate data using flash fill

Lecture 57 Freeze panes

Lecture 58 Split panes

Lecture 59 Rename and Color Worksheets

Lecture 60 Add and Delete Worksheets

Lecture 61 Hide and Unhide Worksheets

Lecture 62 Move and Copy Worksheets

Lecture 63 Worksheet Groups

Lecture 64 Proetect Worksheet

Lecture 65 Protect Workbook

Lecture 66 Lock Individual Cells and Protect Sheets In Excel

Lecture 67 Sharing Excel Workbook with Multiple Users

Lecture 68 Headers and footers

Lecture 69 Page settings

Lecture 70 Page break view

Lecture 71 Print selection

Lecture 72 Set print area

Anyone interested in becoming a proficient Excel user.,Start from the basics and advance step by step.