Home » IT & Software » Microsoft Excel – Beginners Introduction to Excel (Volume 2)

[Free] Microsoft Excel - Beginners Introduction To Excel (Volume 2)

A non-technical professional guide to using Microsoft Excel – Free Course

Added on December 27, 2024 IT & Software 2 min read

What you’ll learn

• Managing Excel Workbooks & Worksheets
• Working with Excel Data Tools
• Writing Basic Excel Aggregator Formulas
• Excel Keyboard Shortcuts
• Manipulating Cells in Excel
• Excel Tips and Tricks

Requirements

• Complete the FREE Volume 1 of this course
• Windows Computer with Microsoft Excel Installed (Preferably Excel 2016 and above)

Description

However, most Excel Courses ignore the little and basic essential knowledge areas and that makes Advanced concepts difficult for Excel users along the line.

In this course, Ahmed Oyelowo (Microsoft MVP and Microsoft Certified Trainer) has taught Excel from grounds up. Assuming zero knowledge on the part of the Student.

Ahmed’s teaching is simple and concise, with explanations done in layman’s terms. His Power BI Course has for long been a Udemy Best Seller and on many occasions remained the Highest Rated course in that category.

If you are looking to set the right foundation for your Excel knowledge, the impact of which you will continue to gain as you transition to Advanced Excel and diversify into other technologies, then you should take this course.

In this course, you will learn:

1. Basic Excel Operations including:

   1. Changing Excel Settings

   2. Protecting Excel with Passwords

   3. Navigating between Excel Workbooks and Worksheets

2. Working with Excel Data including:

   1. Formatting Excel Content

   2. Sorting and Filtering

   3. Different methods for copying and filtering data

   4. Different methods for finding and replacing data

   5. Creating Dropdowns in Excel

   6. Creating Expand and Collapsible buttons in Excel Data Ranges

   7. Separating Texts to different columns

3. Working with Excel Formulas including

   1. SUM function and Auto Sum Magic

   2. AVERAGE function

   3. MIN and MAX functions

   4. SMALL and LARGE functions

This course has been broken down into 3 Volumes. This is Volume 2 and here you will learn how to manage data in Microsoft Excel