Microsoft Office Excel: Beginner to Advance

5.0

(1 Reviews)

Duration 10 h 14 m 24 s

Price

R 159 ~~R 500~~ Buy now

Microsoft Office Excel: Beginner to Advance

About Course

Unlock the full potential of Microsoft Excel and embark on a transformative journey from novice to master with our comprehensive course, "Microsoft Office Excel: Beginner to Advance."

Whether you're an absolute beginner or seeking to upgrade your Excel skills, this course is your gateway to becoming a proficient Excel user.

Course content

Excel from A-Z3 m 21 s Start

What is Microsoft Excel4 m 16 s Start

Who is this Course for?3 m 30 s Start

Microsoft Excel Marketplace4 m 9 s Start

Microsoft Office Excel Job Opportunities2 m 43 s Start

Excel Job Types3 m 51 s Start

Finding and Opening Excel1 m 4 s Start

Excel Workbook vs Excel Worksheet2 m 13 s Start

Excel Shortcut Keys1 m 43 s Start

Adjusting Height and Width4 m 34 s Start

Hiding and Unhiding Excel Rows and Columns4 m 28 s Start

Renaming, Moving and Deleting Excel Worksheets5 m 27 s Start

Adding Protection to Specific Cells4 m 24 s Start

Protecting the Structure of a Workbook2 m 12 s Start

Adding a Workbook Password2 m 10 s Start

Grab User's Attention using Illustrations8 m 39 s Start

Customizing Icons4 m 41 s Start

Create Compelling Graphics with SmartArt5 m 36 s Start

Excel Page Layout Preview6 m 37 s Start

Printing a Specific Range of Cells2 m 38 s Start

Converting Spreadsheets to PDF2 m 28 s Start

Formatting Fonts and Cell Background Colour4 m 55 s Start

Adding Cell Borders4 m 47 s Start

Formatting Data Appropriately5 m 21 s Start

The Magic Behind Excel's Format Painter3 m 30 s Start

Creating Styles for Formatting Efficiency5 m 56 s Start

Merging Cells for a Cleaner Look3 m 27 s Start

The Power of Conditional Formatting6 m 9 s Start

Excel Functions Explained2 m 35 s Start

Min()-Max() Function3 m 44 s Start

SUM() Function7 m 31 s Start

AVERAGE() Function2 m 1 s Start

COUNT() Function4 m 57 s Start

Excel IF Function5 m 17 s Start

IF() Function with AND()5 m 23 s Start

IF() with OR()5 m 14 s Start

Nesting Multiple IF()7 m 24 s Start

COUNTIF() Function4 m 6 s Start

What is Excel Data Validation?1 m 56 s Start

Creating a Dropdown List7 m 9 s Start

Different Types of Data Validation5 m 39 s Start

Adding Custom Alerts to Data Validation6 m 53 s Start

Creating a Dynamic Dropdown List3 m 10 s Start

Complex Validation8 m 39 s Start

Creating an Excel PivotTable5 m 31 s Start

Modifying Excel PivotTables5 m 39 s Start

Grouping6 m 30 s Start

Drilling Down into PivotTable Data2 m Start

Creating Pivot Charts8 m Start

What is Power Pivot?3 m 46 s Start

Activating the Excel PowerPivot Add in1 m 34 s Start

Creating Relationships Between Data Tables6 m 22 s Start

Using Data Models to Create Pivot Tables4 m 31 s Start

How to Create PowerPivot KPI's8 m 26 s Start

LEFT(),RIGHT() and MID() Function7 m 8 s Start

Extracting Specific Text Using LEN() and SEARCH()12 m 45 s Start

Combining Text with CONCATENATE()6 m 5 s Start

Quick Tips5 m 49 s Start

SUMIF() Function8 m 42 s Start

DSUM() Function7 m 47 s Start

DSUM() Function Cont.7 m 6 s Start

SUBTOTAL() Function6 m 29 s Start

VlookUp() Function9 m Start

Beauty of Excel's IFERROR() Function3 m 56 s Start

HLookUp() Function6 m 21 s Start

INDEX() Function4 m 43 s Start

MATCH() Function4 m 56 s Start

Two-Way Lookup4 m 10 s Start

Entering Numerical Values in Excel3 m 25 s Start

Formatting Date Values in Excel5 m 19 s Start

Tracing Precedents4 m 28 s Start

Showing Formulas1 m 53 s Start

Grouping Data2 m 42 s Start

Referencing in Formulas5 m 4 s Start

Utilizing the Watch Window in Excel2 m 44 s Start

Freeze Panes in Excel2 m 56 s Start

Introduction to VBA2 m 14 s Start

Modules and Procedures6 m 34 s Start

Objects, Methods and Properties5 m 59 s Start

Excel VBA Variables4 m 39 s Start

Referencing a Range13 m 30 s Start

InputBox5 m 33 s Start

Using Variables in VBA Code4 m 32 s Start

If then Else Statement10 m 23 s Start

Worksheet Functions inside VBA7 m 32 s Start

Creating User Defined Functions9 m 19 s Start

User Defined Functions within VBA Script6 m 9 s Start

Find Last Row of Data5 m 46 s Start

Find Last Column of Data3 m 12 s Start

With Statement4 m 51 s Start

Debugging_Error Handling6 m 36 s Start

Debugging Error Handling (Cont.)6 m 45 s Start

For Next Loop9 m 12 s Start

Do Until Loop6 m 3 s Start

For Each Loop3 m 36 s Start

Assigning Macros to Shapes3 m 33 s Start

Form Controls vs ActiveX Controls7 m 50 s Start

Worksheet Events3 m 44 s Start

Workbook Events2 m 54 s Start

Fun with VBA Events6 m 55 s Start

Excel's Scenario Manager5 m 56 s Start

Goal Seek in Excel6 m 15 s Start

Compare Results with Excel Data Tables4 m 24 s Start

Solver Tool10 m 59 s Start

Commonly Used Column Chart2 m 46 s Start

Changing Chart Design1 m 58 s Start

Formatting Elements of a Chart6 m 24 s Start

Modifying the Data6 m 6 s Start

Little Slice of Pie Charts5 m 12 s Start

Creating an Excel Resume4 m 51 s Start

Getting Started with Freelancing6 m 16 s Start

How to Become an Excel Freelancer5 m 12 s Start

Top Freelance Websites5 m 12 s Start

How to Get Your First Client7 m 45 s Start

Personal Branding6 m 47 s Start

Networking Do's and Don'ts4 m 22 s Start

The Importance of Having a Website4 m 24 s Start

Buy now

Course Instructor

Director and Owner

Reviews

5.0

(1 Reviews)

Microsoft Office Excel: Beginner to Advance

About Course

Power Education

Course Instructor