Excel - Zero To Hero: Master Basic To Advanced

Master Excel from beginner to advanced in 13 hours. Learn formulas, data analysis, macros, and more with hands-on lesson

What you'll learn

Excel Interface Navigation: Understand all components of Excel's interface.

Working with Workbooks: Efficiently create, save, open, and manage workbooks.

Data Entry: Basic and advanced techniques for data manipulation.

Formulas and Functions: From simple to advanced like LAMBDA and LET.

Worksheet Management: Adding, moving, copying, and organizing.

Conditional Formatting and Styles: Highlighting and data visualization.

Charts and PivotTables: Creation and customization for analysis.

Data Validation and Cleaning: Ensuring accuracy and preparing for analysis.

Requirements

There are no prerequisites for this course. All are welcome

Description

The "Excel - Zero to Hero" course is a comprehensive and detailed program designed to transform anyone from an absolute beginner in Excel to an advanced and confident user. With 71 lessons spread across 8 sections, totaling 13 hours of intensive content, this course covers all essential and advanced areas of Excel, providing students with a solid foundation and practical skills to tackle any challenge using this powerful tool.What You Will LearnExcel Interface Navigation: Understand all components of the Excel interface, including toolbars, menus, and customization options.Working with Workbooks: Learn how to create, save, open, and manage workbooks efficiently.Data Entry: Basic and advanced data entry techniques, including cell formatting and cell referencing.Basic and Advanced Formulas and Functions: From simple formulas to complex functions like LAMBDA and LET, this course covers everything you need to know to calculate and analyze data.Managing Worksheets: How to add, move, copy, and organize worksheets within a workbook.Conditional Formatting and Cell Styles: Apply conditional formatting and styles to highlight important data and improve visualization.Charts and PivotTables: Creating and customizing charts, as well as using PivotTables to analyze large datasets.Data Validation and Cleaning: Techniques to ensure data accuracy and methods for cleaning data to prepare it for analysis.Data Analysis Tools: Using advanced analysis tools like Power Query, Power Pivot, and Excel data models.Automating Tasks with Macros: Learn to automate repetitive tasks in Excel using macros.Excel Integration with Other Applications: Explore how Excel integrates with other Microsoft Office applications and external tools.Keyboard Shortcuts and Productivity Tips: Practical tips to improve your efficiency when using Excel.Course BenefitsComprehensive Content: Covers everything from basics to advanced functionalities of Excel.Hands-on Training: Practical lessons with downloadable example files, allowing you to follow along and practice what you are learning.Lifetime Access: Once enrolled, you have lifetime access to the course content, allowing you to revisit the lessons whenever needed.Certificate of Completion: Upon finishing the course, you will receive a certificate of completion that can be added to your resume or LinkedIn profile.Student Support: Access to an active student community and instructor support to answer questions and share knowledge.Target AudienceThis course is ideal for:Excel Beginners: People who have never used Excel before and want to start from scratch.Intermediate Users: Those who already have some experience with Excel and want to enhance their skills.Business Professionals: Anyone who uses Excel at work and wants to increase their efficiency and productivity.Students: Students who need Excel for their studies and academic projects.Data Analysts: Professionals who work with data analysis and need advanced Excel skills.Enroll now and transform your Excel skills from "Zero to Hero"!

Overview

Section 1: Before You Start

Lecture 1 All files that will be used in training

Section 2: Enter the arena - Introduction to Excel

Lecture 2 Introduction to Excel

Lecture 3 Excel Interface Navigation

Lecture 4 Working with Workbooks

Lecture 5 Basic Data Entry

Lecture 6 Customizing Quick Access Toolbar

Lecture 7 Basic Formulas and Functions

Lecture 8 Cell Referencing

Lecture 9 Formatting Cells

Section 3: Goose egg - Excel Basics

Lecture 10 Managing Worksheets

Lecture 11 Copying and Moving Data

Lecture 12 Using Find and Replace

Lecture 13 Printing and Page Layout

Lecture 14 How Functions Work

Lecture 15 Functions and Formulas

Lecture 16 Data Sorting and Filtering

Lecture 17 Working with Tables

Lecture 18 Cell Styles and Themes

Section 4: Unsong Hero - Intermediate Excel

Lecture 19 Conditional Formatting

Lecture 20 Charts and Graphs

Lecture 21 Freeze Panes and Split View

Lecture 22 Removing Duplicates

Lecture 23 Creating Data Validation Lists

Lecture 24 Flash Fill

Lecture 25 Day to Day functions

Lecture 26 Nested Functions

Lecture 27 Text Functions

Lecture 28 Date and Time Functions

Lecture 29 Lookup and Reference Functions

Lecture 30 Protecting and Sharing Workbooks

Lecture 31 Evaluate formula

Section 5: Dashing Hero - Advanced Excel Topics

Lecture 32 Subtotals and Outlines

Lecture 33 Using PivotTables

Lecture 34 PivotCharts

Lecture 35 PivotTable - Excel Data Model

Lecture 36 Data Validation

Lecture 37 Data Cleaning Techniques

Lecture 38 Sorting with Multiple Criteria

Lecture 39 Using Filters and Slicers in PivotTables

Lecture 40 Advanced Charting

Lecture 41 LAMBDA Function

Lecture 42 The magic LET function

Lecture 43 Sparklines

Lecture 44 Data Analysis Tools

Lecture 45 Advanced Conditional Formatting

Lecture 46 Dynamic Arrays and New Functions

Lecture 47 Dynamic Arrays and New Functions

Section 6: Veteran Hero - Expert Excel Topics

Lecture 48 Using Named Ranges

Lecture 49 Data types

Lecture 50 Using Form Controls

Lecture 51 Importing Data

Lecture 52 Using the Watch Window

Lecture 53 Linking and Embedding

Lecture 54 Automate - Office Scripts

Lecture 55 Statistical Functions

Lecture 56 Creating and Using Data Models

Lecture 57 Using Power Query for Data Transformation

Lecture 58 Power Pivot Basics

Lecture 59 Creating PivotTable Calculated Fields

Lecture 60 Creating Heat Maps and Data Bars

Lecture 61 Array Formulas

Lecture 62 Consolidating Data

Lecture 63 Creating Dashboards

Lecture 64 Automating Tasks with Macros

Section 7: Tools of the trade - Excel Tips and Tricks

Lecture 65 Excel Integration with Other Apps

Lecture 66 Keyboard Shortcuts

Lecture 67 Selection Pane

Lecture 68 Troubleshooting Common Issues

Lecture 69 Excel Add-Ins

Lecture 70 Check accessibility

Section 8: Course Wrap-Up

Lecture 71 Review and Practice

This course is ideal for beginners looking to learn Excel from basic to advanced techniques.,It is also recommended for intermediate users seeking to enhance their skills in the tool.,Professionals aiming to increase their efficiency using Excel in daily work will find significant benefits.,Students and data analysts can leverage this course to develop essential data analysis and automation skills.