The Excel Advantage - Basic to Advanced Microsoft Excel

Focused View

Kenneth Ogbebor

4:35:27

108 View

1. INTRODUCTION TO MICROSOFT EXCEL

1. Introduction.mp4

14:58

2. Entering Data.mp4

19:17

3.1 MODULE 3 - ROWS AND COLUMNS.xlsx

3. Working with Rows and Columns.mp4

16:47

4.1 MODULE 4 - COPYING AND MOVING DATA.xlsx

4. Copying and Moving Data.mp4

06:41

5.1 MODULE 5 - FORMATING.xlsx

5. Formatting Worksheets.mp4

24:23

6.1 MODULE 6 - CONDITIONAL FORMATTING.xlsx

6. Conditional Formatting.mp4

10:06

2. WORKING WITH EXCEL

1.1 MODULE 7 - TEXT AND DATA CLEANING FUNCTIONS.xlsx

1.2 MODULE 7 - TEXT AND DATA CLEANING FUNCTIONS.xlsx

1. Text and Data Cleaning Functions.mp4

27:38

2.1 MODULE 8 - WORKING WITH DATA-SORT AND FILTER.xlsx

2. Working with Data- Sort and Filter.mp4

11:52

3.1 MODULE 9 - BASIC CALCULATIONS.xlsx

3. Basic Calculations.mp4

15:51

4.1 MODULE 10 - BASIC CALCULATIONS 2.xlsx

4. Basic Calculations 2.mp4

06:11

3. ADVANCED EXCEL

1.1 MODULE 11 - DATA VALIDATION.xlsx

1. Data Validation.mp4

12:54

2.1 MODULE 12 - NAMED RANGES.xlsx

2. Named Ranges.mp4

11:25

3.1 MODULE 13 - CELL REFERENCE.xlsx

3. Cell Reference.mp4

22:11

4.1 MODULE 14 - PASTE SPECIAL AND TRANSPOSE.xlsx

4. Paste Special and Transpose.mp4

11:56

5.1 MODULE 15 - LOGICAL FUNCTIONS.xlsx

5. Logical Function.mp4

14:08

6.1 MODULE 16 - TABLEES, RUNNING TOTALS.xlsx

6. Tables and Running Total.mp4

06:21

7.1 MODULE 17 - DATA ENTRY FORM.xlsx

7. Data Entry Form.mp4

06:04

8.1 MODULE 18 - CHARTS.xlsx

8. Charting.mp4

15:26

9.1 MODULE 19 - PRINTING.xlsx

9. Printing and Sharing.mp4

21:18

Description

Microsoft Excel Course compatible with MS Excel and suitable for beginners and intermediate users

What You'll Learn?

Build a solid understanding on the Basics of the Microsoft Excel software
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, Pivot Tables and Pivot Charts
Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros and VBA
Create Interactive Dashboards, applying slicers

Who is this for?

This course is for everyone looking to take their Excel skills from beginner or intermediate level to advanced level and beyond.

It is good for people looking to pursue a career in data analytics, business analytics or similar fields

Excel users looking to build powerful analytical thinking and business intelligence skills

Excel users hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

More details

Description
Description
Get the Excel Advantage.
Knowledge of Excel will set you at an advantage on the job, in your business or as a freelancer.

This course will give you a complete understanding of the basics of Excel from the interface and features, through intermediate functions and formulas to advanced excel functions and analytics.
This course will not teach you formulas and functions in isolation, instead you will learn through practical application of the Excel formulas and functions.

By the end of the course, you will be able to write simple, complex and elegant formulas from scratch.
This will help you to:
Easily calculate and analyze data with Excel.
Easily build dynamic tools & Excel dashboards to filter your data
Create your own formula-based Excel formatting rules
Manipulate dates, times, text, and arrays
Create charts and visuals in Excel
We'll dive into a broad range of Excel formulas & functions, including:
Statistical functions
Formula-based formatting
Date & Time functions
Logical operators
Dynamic Array formulas
Text functions
I have seen the power of Excel in the course of my work as an Engineer and it give me great joy to teach others the immense power and functionality of Excel.
My teaching style is practical, conversational, authentic and to the point, and I help student grasp complex concepts in a way that is clear and easy to comprehend.
If you're looking for the ONE course with all of the basic and advanced Excel formulas and functions that you need to know to use Excel to your advantage, you've found it.
See you in the course!
-Kenneth Ogbebor
Who this course is for:
This course is for everyone looking to take their Excel skills from beginner or intermediate level to advanced level and beyond.
It is good for people looking to pursue a career in data analytics, business analytics or similar fields
Excel users looking to build powerful analytical thinking and business intelligence skills
Excel users hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Kenneth Ogbebor

Instructor's Courses

Kenneth Ogbebor is an Engineer, Entrepreneur, Speaker, Trainer, Author with specific interest in understanding and stimulating human potential.He works with individuals, teams and organizations to amplify their Capacity, Competence and Confidence via training and personal development.He is an extremely competent and impactful teachers in areas like Microsoft Excel, Data Analytics, PowerBI, SQL, PowerPoint, Project Management, Effective communication, Leadership, Team and Organisational Effectiveness, …He is a passionate advocate of the limitless possibilities unleashed by personal development, and he trains and coaches with this belief, and guides his clients to effectively strengthen and elevate their personal best to new heights.Kenneth is passionate about people, leadership and successful businesses.He is the author of the highly acclaimed book, “Why I fired my boss” and the convener IGNITE conference, Abuja, a highly impactful annual business conference that has held since 2019.Kenneth is married with three daughters and he lives in Abuja, Nigeria.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.