Mastering Microsoft Office Excel in the Workplace

5.0

(2 Reviews)

Duration 3 h 37 m 55 s

~~R 249~~Free

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

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

Using Excel Templates to Save Time and Effort8 m 56 s

Saving Your Document2 m 42 s

Entering Data and Navagating Around the Cells2 m 53 s

Creating Simple Formulas to Do Powerful Calculations7 m 4 s

Working with Workbooks and Worksheets8 m 42 s

Introduction - Creating and Formatting Your Heading3 m 24 s

Create Formulas to Quickly Calculate Your Costs6 m 8 s

Formatting - Grids and Spacing3 m 25 s

Introduction to Excel Formulas and Functions4 m 1 s

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

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

Anatomy of a Formula6 m 35 s

Absolute vs. Relative Cell References6 m 53 s

AVERAGE and AVERAGEA Functions3 m 4 s

COUNT, COUNTA and COUNTBLANK Functions4 m 5 s

IF Functions9 m 37 s

SUMIF and SUMIFS Functions6 m 22 s

COUNTIF and COUNTIFS Functions4 m 27 s

VLOOKUP Function12 m 36 s

LEFT, RIGHT and MID Functions8 m 55 s

CONCATENATE4 m 36 s

LEN - Length of Text3 m 4 s

FIND and SEARCH3 m 53 s

MIN and MAX4 m 54 s

AND and OR6 m 10 s

ROUND, CEILING and FLOOR13 m 24 s

TODAY and NOW2 m 31 s

CONDITIONAL FORMATTING8 m 46 s

ALT Shortcut Keys for INDEXMATCH4 m 17 s

UPPER, LOWER, and PROPER4 m 13 s

Introduction - How to Create a Chart7 m 14 s

Format Your Chart7 m 14 s

Create a Bar Chart5 m 55 s

Create a Pie Chart11 m 37 s

Power Education

Course Instructor

Director and Owner

Reviews

5.0

(2 Reviews)