Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - Beginners Introduction to Excel (Volume 3)
Rating: 4.5 out of 5(76 ratings)
1,747 students

Microsoft Excel - Beginners Introduction to Excel (Volume 3)

A non-technical professional guide to using Microsoft Excel
Created byAhmed Oyelowo
Last updated 12/2024
English

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

Course content

1 section • 8 lectures • 38m total length

  • Introduction to Excel Formulas1:23

    The lecture introduces Excel formulas as the backbone of Excel workbooks, guiding users from simple formulas with primitive values to using functions and aggregate functions for greater efficiency.

  • Writing formulas with primitive values4:17

    Learn to write simple Excel formulas using primitive values and cell references, perform arithmetic with plus, multiply, divide, and raised to power, and update results by editing cells.

  • Introduction to Excel Functions2:16

    Explore Excel functions as helpers using the function library on the formulas tab, including autosum and financial, logical, text, and date and time groups.

  • How to use functions in Excel8:11

    Master how to use the sum function in Excel to total values by referencing cells. Start with the equal sign, learn function syntax, and understand required versus optional arguments.

  • Adding cell data with SUM function5:15

    Learn to use the sum function to add numbers across a range, define ranges with a colon, and see automatic updates when values change in Excel.

  • Saving time with Autosum feature6:12

    Discover how to save time with autosum using the alt + = shortcut to total vertical or horizontal ranges, fill formulas down, and compute per row and grand totals.

  • Using other aggregator functions8:24

    The lecture demonstrates how to use Excel aggregate functions such as sum, average, min, max, large, and small to compute totals, means, and ranked values with dynamic updates.

  • Course wrap up2:12

    Master workbook and worksheet management, data movement across workbooks, and protection with passwords; learn find and replace with formats or wildcards, paste options, data validation, and formulas, sum, and average.

Requirements

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

Description


Microsoft Excel Skills, for may Techies is not only an essential skill, but also arguably the best place to start before venturing into the likes of Python, SQL, Power BI/ Tableau or even any other programming Language.

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.

This Introduction to Excel Course is the first of the series that will include other courses on Microsoft Excel Formulas, Pivot Tables, Power Query, Excel Charts and Data Visualization, Power Pivot and Macros.

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 3 and here you will get an introduction to writing formulas with Excel.

Who this course is for:

  • Aspiring Data Analysts and Data Scientists
  • Finance Professionals
  • HR Professionals
  • Fresh Graduates
  • Project Managers
  • Business Analysts
  • Job Seekers
  • Anyone that works with Excel

Report abuse