Mastering Microsoft Office Excel in the Workplace

5.0

(2 Reviews)

Duration 3 h 37 m 55 s

Price

R 159 ~~R 800~~ Buy now

Mastering Microsoft Office Excel in the Workplace

About Course

Unleash the full potential of Microsoft Office Excel with our dynamic online course, "Mastering Microsoft Office Excel in the Workspace." Dive into comprehensive modules crafted to transform you into a proficient Excel maestro. From essential spreadsheet skills to advanced data analysis techniques, this course empowers you to navigate the corporate landscape with confidence. Elevate your career by mastering Excel's tools and functions, equipping yourself with indispensable skills for effective data management and analysis. Join us on a transformative journey to become the Excel expert your workplace needs!

Course content

Introduction2 m 22 s Start

How to Get the Most Out of This Course.7 m 23 s Start

Using Excel Templates to Save Time and Effort8 m 56 s Start

Saving Your Document2 m 42 s Start

Entering Data and Navagating Around the Cells2 m 53 s Start

Creating Simple Formulas to Do Powerful Calculations7 m 4 s Start

Working with Workbooks and Worksheets8 m 42 s Start

Introduction - Creating and Formatting Your Heading3 m 24 s Start

Create Formulas to Quickly Calculate Your Costs6 m 8 s Start

Formatting - Grids and Spacing3 m 25 s Start

Introduction to Excel Formulas and Functions4 m 1 s Start

What is a Formula and What Can It Do for You2 m 1 s Start

What is a Function and What Does IT Do8 m 32 s Start

Anatomy of a Formula6 m 35 s Start

Absolute vs. Relative Cell References6 m 53 s Start

AVERAGE and AVERAGEA Functions3 m 4 s Start

COUNT, COUNTA and COUNTBLANK Functions4 m 5 s Start

IF Functions9 m 37 s Start

SUMIF and SUMIFS Functions6 m 22 s Start

COUNTIF and COUNTIFS Functions4 m 27 s Start

VLOOKUP Function12 m 36 s Start

LEFT, RIGHT and MID Functions8 m 55 s Start

CONCATENATE4 m 36 s Start

LEN - Length of Text3 m 4 s Start

FIND and SEARCH3 m 53 s Start

MIN and MAX4 m 54 s Start

AND and OR6 m 10 s Start

ROUND, CEILING and FLOOR13 m 24 s Start

TODAY and NOW2 m 31 s Start

CONDITIONAL FORMATTING8 m 46 s Start

ALT Shortcut Keys for INDEXMATCH4 m 17 s Start

UPPER, LOWER, and PROPER4 m 13 s Start

Introduction - How to Create a Chart7 m 14 s Start

Format Your Chart7 m 14 s Start

Create a Bar Chart5 m 55 s Start

Create a Pie Chart11 m 37 s Start

Buy now

Course Instructor

Director and Owner

Reviews

5.0

(2 Reviews)

Mastering Microsoft Office Excel in the Workplace

About Course

Power Education

Course Instructor