Microsoft Excel Fundamentals: Module 1

Boost your Excel proficiency! Whether you're a beginner or an experienced user, this course hones your skills for work and daily tasks. Dive into data entry, formatting, and analysis. Unlock practical tips and basic formulas for workplace efficiency.

Buy Now

Microsoft Excel Fundamentals: Module 1

Buy Now

Course Content

Section 1: What is Excel?

1. What is Excel 00:03:10

Section 2: How to Become an Excel Expert

1. Love mistakes 00:01:52

2. Master the basics 00:02:07

3. Progressive overload 00:02:21

Section 3: Finding your way in excel

1. Navigate your way 00:01:59

2. Command buttons & Quick Access Bar, Formula Bar 00:03:30

3. File Tab 00:02:26

4. Need Help 00:02:30

Section 4: Entering data in excel

1. Entering data into a single cell 00:02:59

2. Entering data into multiple cells 00:04:35

3. Copying and pasting data 00:03:00

4. Moving or Copying worksheets 00:06:18

5. Undo and Redo 00:03:26

Section 5: working with formulas in excel

1. why use excel formulas 00:01:53

2. formulas vs functions 00:06:01

3. why pedmas 00:03:00

4. logical operators 00:09:02

5. To check if the data exist 00:07:25

6. Cell reference 00:03:27

7. Absolute, mixed and relative cell reference 00:07:39

8. conclusion 00:00:44

Buy Now

About This Course

Are you ready to enhance your proficiency in Excel? Whether you are an experienced Excel user or a beginner, this course will test your skills and help you become more efficient at work and in your professional endeavors. You will acquire fundamental knowledge of utilizing Microsoft Excel for data entry, formatting, and analysis, as well as gain insights into practical tips and basic Excel formulas that you can utilize in your workplace and daily routine.

To enroll in this course, you will require access to Microsoft Excel (version 2016 or later) and a basic understanding of computer operations, such as using a mouse and keyboard.

So, why wait? Join us on this exciting journey to Excel mastery and have fun as you learn!

What You Will Learn

In this course, you will learn :

The basics of Excel: How to navigate the user interface, creating and formating worksheets, and using basic formulas and functions.
Data Entry and Management: Learn how to enter data into Excel and how to manage it using features such as sorting, filtering, and conditional formatting.
Data Analysis: Learn how to use Excel's built-in features to analyze data, including charts and graphs, pivot tables, and data validation.
Collaboration and Sharing: Learn how to collaborate with others by sharing Excel workbooks and using Excel's collaboration features.

Meet Your Trainer

Crispo Mwangi

Microsoft Certified Trainer (MCT) |Microsoft Certified Solutions Expert: Data Management & Analytics (MCSE) | Microsoft Excel Expert (MOS) | SSRS Reporting | Certified: Power Platform App Maker | NITA Accredited Trainer His passion is helping organizations manage their data assets and find the best and fastest way to get insights from said data

10th Floor ABC Place, Nairobi

support@zydii.com

sales@zydii.com

+254717258305