Comprehensive Excel Training

Master Excel from the basics to advanced functions, empowering you to excel in your professional endeavors.

Practical Hands-On Experience

Gain practical experience through real-world examples and exercises, ensuring you can apply your Excel skills confidently.

Expert Guidance and Support

Receive expert guidance and support throughout your learning journey, helping you overcome any Excel challenges with ease.

About the Course

Are you struggling with Excel and want to become a proficient user? Our course is designed to take you from a beginner to an advanced Excel user, providing you with the skills and knowledge needed to succeed in your career. Join us and unlock the full potential of Excel today!

Meet Your Instructor, Excel Guru

Hi there! your Excel expert ready to guide you through this transformative learning experience. I understand the challenges you face with Excel and am here to help you excel in Excel. Join me in this journey towards mastering Excel and boosting your professional skills!

Course Curriculum

12 Chapters · 80 Lessons

  1. 1

    Introduction

    1. (Included in full purchase)

      1.5 Saving an Excel File

    2. (Included in full purchase)

      1.4 Explaining the Ribbon

    3. (Included in full purchase)

      1.3 The Excel Workbook and Worksheets

    4. (Included in full purchase)

      1.2 Understanding Excel Interface

    5. (Included in full purchase)

      V1

  2. 2

    2.1 Combined What you can enter a cell

    1. (Included in full purchase)

      Combined what you can enter a cell

    2. (Included in full purchase)

      2.2 Relative And Absolute Cell Referencing

    3. (Included in full purchase)

      2.3 Entering Formula

    4. (Included in full purchase)

      2.4 Order of Operations

    5. (Included in full purchase)

      2.5 Date Serial Numbers

  3. 3

    3.1 Copy And Drag

    1. (Included in full purchase)

      3.1 Copy and Drag

    2. (Included in full purchase)

      3.2 Working with rows and Columns

    3. (Included in full purchase)

      3.3 Working with Sheets

  4. 4

    4.0 Functions

    1. (Included in full purchase)

      4.1 Functions

    2. (Included in full purchase)

      4.2 Sum Function

    3. (Included in full purchase)

      4.3 Copy and Drag Formula

    4. (Included in full purchase)

      4.4 More basic functions

    5. (Included in full purchase)

      4.5 Named Ranges

    6. (Included in full purchase)

      4.6 Names Constants ANd Formula

    7. (Included in full purchase)

      4.7 shortcuts

    8. (Included in full purchase)

      4.8 More Shortcuts

  5. 5

    Formatting

    1. (Included in full purchase)

      5.1 Formatting Font

    2. (Included in full purchase)

      5.2 Formatting Alignment

    3. (Included in full purchase)

      5.3 Formatting Borders

    4. (Included in full purchase)

      5.4 Formatting Numbers

    5. (Included in full purchase)

      5.5 Conditional Formatting Preconfigured

    6. (Included in full purchase)

      5.6 Conditional Fomatting With Fomula

  6. 6

    6.1 Icons Shapes And Formatting

    1. (Included in full purchase)

      6.3 Printing Headers Footers

    2. (Included in full purchase)

      6.2 Printing Page Layout

    3. (Included in full purchase)

      6.1 Icons Shape And Formatting

  7. 7

    7.1 Data Sort

    1. (Included in full purchase)

      7.8 Freeze Panes

    2. (Included in full purchase)

      7.7 Group And Outline

    3. (Included in full purchase)

      7.6 Data Validation

    4. (Included in full purchase)

      7.5 Flash Fill

    5. (Included in full purchase)

      7.4 text to columns

    6. (Included in full purchase)

      7.3 Tables

    7. (Included in full purchase)

      7.2 Filtering

    8. (Included in full purchase)

      7.1 Data Sort

  8. 8

    Relative And Absolute Referencing

    1. (Included in full purchase)

      8.1 Relative And Absolute Referencing

    2. (Included in full purchase)

      8.2 VLOOPUP

    3. (Included in full purchase)

      8.3 Index Match

    4. (Included in full purchase)

      8.4 IF

    5. (Included in full purchase)

      8.5 Nested if

    6. (Included in full purchase)

      8.6 Countif Countifs

    7. (Included in full purchase)

      8.7 Sumif Sumifs

    8. (Included in full purchase)

      8.8 LEN

    9. (Included in full purchase)

      8.9 Right Left MID

    10. (Included in full purchase)

      8.10 Search

    11. (Included in full purchase)

      8.11 Common Errors Types

    12. (Included in full purchase)

      8.12 IFERROR

  9. 9

    Chart Basics

    1. (Included in full purchase)

      9.1 Chart Basics

    2. (Included in full purchase)

      9.2 Chart Series And Column Charts

    3. (Included in full purchase)

      9.3 Bar Charts

    4. (Included in full purchase)

      9.4 Pie Charts

    5. (Included in full purchase)

      9.5 Composite Charts

  10. 10

    10.1 Power Query Consolidation

    1. (Included in full purchase)

      10.1 Power Query Intro

    2. (Included in full purchase)

      10.2 Power Query Consolidation

    3. (Included in full purchase)

      10.3 Pivot Tables

    4. (Included in full purchase)

      10.4 Setting up a Pivot Table

    5. (Included in full purchase)

      10.5 Pivot Field Settigns

    6. (Included in full purchase)

      10.6 Pivot Table Calculated Fields

    7. (Included in full purchase)

      10.7 Pivot Table Groupings

    8. (Included in full purchase)

      10.7a For Loop

    9. (Included in full purchase)

      10.7 b Dowhile Do until Loop

    10. (Included in full purchase)

      10.7c Foreach Loop

    11. (Included in full purchase)

      10.8 Pivot Table Slicers And Timelines

    12. (Included in full purchase)

      10.9 Dashboard P1

    13. (Included in full purchase)

      10.9.2 DashBoard P2

  11. 11

    11.1 Macro

    1. (Included in full purchase)

      11.3 Relative And Absolute Macros

    2. (Included in full purchase)

      11.2 Recording A Macro

    3. (Included in full purchase)

      11.1 What is a macro

  12. 12

    VBE

    1. (Included in full purchase)

      12.1 Intro to Vbe

    2. (Included in full purchase)

      12.2 Object Model

    3. (Included in full purchase)

      12.3 Module Worksheets Classes

    4. (Included in full purchase)

      12.4 Variables And Constants

    5. (Included in full purchase)

      12.5 vba Formatting

    6. (Included in full purchase)

      12.6b Select Case

    7. (Included in full purchase)

      12.8a Errors

    8. (Included in full purchase)

      12.8b Errors

    9. (Included in full purchase)

      12.9 Consolidate

Ready to Excel in Excel?

Take the first step towards mastering Excel and unlocking a world of opportunities.

$39.00

Enroll Now