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 2)
Rating: 4.5 out of 5(40 ratings)
1,297 students

Microsoft Excel - Beginners Introduction to Excel (Volume 2)

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 • 28 lectures • 1h 58m total length

  • Introduction to cell formatting7:17
  • Introduction to cell formatting (part 2)3:43
  • Introduction to number formatting3:55
  • Customizing number formats4:51
  • Understanding behavior of numbers and text formatting7:06
  • Customizing date formats6:04
  • Formatting cells roundup exercise5:40

    Explore advanced formatting in Excel by converting dates to just years, applying thousand separators, and displaying negative figures in red with parentheses using custom formats.

  • Introduction to sorting data2:16
  • Basic data sorting4:30

    Discover how to sort data in Excel using the data tab, with A to Z and Z to A, while rows stay aligned as the driver column determines order.

  • Sorting data with empty spaces between cells2:58
  • A better way to sort data4:41

    Learn how to handle spaces in data when sorting in Excel by identifying empty rows or columns, highlighting the data range, and using the filter button with dropdowns.

  • Using more sorting options2:43
  • Using Advanced Sorting Options6:45
  • Introduction to Data Filtering4:19
  • Clearing filters and using Search in filters4:43
  • Filtering data based on rules4:54

    Master smart filtering in Excel using color, text, date, and number rules to focus on specific records, with calendar-based dates and top ten options.

  • Using Advanced Filters2:28

    Learn to use advanced filters to extract data from a criteria list; copy the selection, paste below the data, and configure list and criteria ranges with a matching header.

  • Using Freeze Panes to keep workbook headers during scrolling3:50
  • Using Outlines to add expand and collapse button to excel data7:36
  • Introduction to fill data series and auto fill3:23
  • Filling data series with the fill dialog box3:55
  • Filling data series with Linear and Growth options2:55
  • Filling series based on trends1:52
  • Using Flashfill1:28
  • Introduction to Data Validation in Excel4:14

    Use data validation in Excel to limit cell inputs by setting constraints such as whole numbers, dates, or decimals, and customize input messages and error alerts.

  • Creating Dropdown lists in Excel3:20
  • Separating Text to columns using delimiter3:37

    Use text to columns to split cell content by delimiters, such as space, into first name and surname, and set the destination columns B and C from the data tab.

  • Separating Text to columns using fixed widths3:20

Requirements

  • Complete the FREE Volume 1 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 2 and here you will learn how to manage data in Microsoft 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