Microsoft Excel - Beginners Introduction to Excel (Volume 1)

Name: Microsoft Excel - Beginners Introduction to Excel (Volume 1)
Rating: 4.6 (122 reviews)

Non-technical Professional Guide to Excel

Created byAhmed Oyelowo

Last updated 11/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

2 sections • 22 lectures • 1h 23m total length

Introduction1:53
Explore how Microsoft Excel functions as a spreadsheet for computing, analyzing, and manipulating data. See how number crunching in Excel underpins startup funding and mergers or acquisitions.
Prerequisites1:21
Identify the essential prerequisites for learning Excel on Windows, including having Excel installed from 2016 onward, using Microsoft 365 developer accounts for free, and signing into Office.
Excel Knowledge Overview1:28
Develop proficiency in basic spreadsheet operations, formulas with Excel functions, and data analysis, including pivot tables, charts, and the Power Query, Power Pivot, and macros toolset.
Understanding the Excel Environment5:52
Launch a blank workbook to explore worksheets and cells, highlight the name box, and understand columns, rows, menu tabs, the ribbon, status bar, and quick access toolbar.
Changing Settings in Excel Options4:21
Learn to customize Excel settings via the Excel Options dialog, adjust default font and theme, and tailor the ribbon by creating a new Ahmed tab with the Calculate command.
Saving and Using Passwords for Excel5:31
Learn how to save and password protect Excel workbooks, using save as, the disk icon, and Ctrl+S for regular saves, with password to open and reminders to remember it.
Navigating between Excel Worksheets1:40
Learn to navigate across worksheets and workbooks in Excel using Ctrl+Page Up or Page Down, and access the sheet list by right-clicking the sheet tab area.
Navigating between Excel Workbooks1:52
Navigate between multiple Excel workbooks by using the taskbar icon, alt tab, and control tab to switch windows and cycle between open workbooks.
Chapter 1 - Introduction and Basic Excel Quiz

Intro to Copying & Pasting Data in Excel4:30
Master copying and pasting in Excel using right-click or keyboard shortcuts to move data across cells and worksheets. Explore pasting options, multi-cell selection, and canceling with escape.
Pasting with Options5:59
Learn how to use Excel's paste options from the Ctrl+V dropdown, including pasting formulas, values, number formatting, and keeping source formatting, plus how to transpose data.
Using the Paste Option Dialog Box4:01
Learn to use the paste special dialog in Excel to paste formulas, values, formats, data validation, and comments, and apply operations like multiply, add, or transpose on a range.
Pasting from the Clip Board Button2:49
Copy multiple items over time and paste them in any order using Excel's clipboard; open the clipboard to view stored items and paste them individually, or use paste special values.
Replicating Worksheet data with Move or Copy tool4:48
Master replicating worksheet data with move or copy, create a copy, and decide whether to copy within the same workbook or to a new workbook.
Intro to Find & Replace in Excel3:34
Learn to use find and replace in Excel by opening the home tab, using the find and select tool, then find next, find all, and replace or replace all.
Find & Replace Options3:38
Learn to use find and replace in excel with control F and control H, explore scope options (worksheet or workbook), and apply match case or match entire cell contents.
Find & Replace using * Wild Card3:32
Use wild cards in Excel's find and replace to normalize spellings, matching starts with mi and ends with l, and replace all with mike using the asterisk.
Find & Replace using ? Wild Card3:05
Learn to perform find and replace in Excel using the question mark wildcard to match an exact number of characters, with practical examples like matching variations.
Find & Replace based on Cell Format2:10
Master find and replace by cell format in Excel, locating red fonts and bold cells with find all and using format from Excel to target specific formatting.
Understanding Cells2:54
Learn how to work with cells in Excel by entering data, using primitive values, writing formulas, and referencing other cells, with practical tips and tricks.
Increasing Cell Size, Row/Column Height & Width7:42
learn to adjust excel cell display by expanding column width and row height, wrapping text, and using format options to keep numbers intact in the formula bar.
Understanding Excel Data Types5:48
Learn how Excel handles data types, including numbers and text, and how alignment works. See how dates are stored as numbers and how to keep leading zeros with an apostrophe.
Dates are treated like Numbers in Excel4:56
Dates in Excel are numbers, enabling arithmetic and serial day counts since January 1, 1900. You can switch between date and number formats to view the underlying serial value.
Chapter 2 - Working with Excel Data Part 1
Chapter 3 - Working with Data Part 2

Requirements

The only experience you need is how to operate a computer.
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:

Basic Excel Operations including:
1. Changing Excel Settings
2. Protecting Excel with Passwords
3. Navigating between Excel Workbooks and Worksheets
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
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

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

Microsoft Excel - Beginners Introduction to Excel (Volume 1)

What you'll learn

Explore related topics

Course content

Introduction & Simple Excel Operations8 lectures • 24min

Working with Excel Data (Part 1)14 lectures • 59min

Requirements

Description

Who this course is for: