Excel - Introductory Spreadsheet Course For Beginners
- Description
- Curriculum
- FAQ
- Reviews
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:
- Changing Excel Settings
- Protecting Excel with Passwords
- Navigating between Excel Workbooks and Worksheets
- Working with Excel Data including:
- Formatting Excel Content
- Sorting and Filtering
- Different methods for copying and filtering data
- Different methods for finding and replacing data
- Creating Dropdowns in Excel
- Creating Expand and Collapsible buttons in Excel Data Ranges
- Separating Texts to different columns
- Working with Excel Formulas including
- SUM function and Auto Sum Magic
- AVERAGE function
- MIN and MAX functions
- SMALL and LARGE functions
-
1IntroductionVideo lesson
-
2PrerequisitesVideo lesson
-
3Excel Knowledge OverviewVideo lesson
-
4Understanding the Excel EnvironmentVideo lesson
-
5Changing Settings in Excel OptionsVideo lesson
-
6Saving and Using Passwords for ExcelVideo lesson
-
7Navigating between Excel WorksheetsVideo lesson
-
8Navigating between Excel WorkbooksVideo lesson
-
9Chapter 1 - Introduction and Basic Excel QuizQuiz
-
10Intro to Copying & Pasting Data in ExcelVideo lesson
-
11Pasting with OptionsVideo lesson
-
12Using the Paste Option Dialog BoxVideo lesson
-
13Pasting from the Clip Board ButtonVideo lesson
-
14Replicating Worksheet data with Move or Copy toolVideo lesson
-
15Intro to Find & Replace in ExcelVideo lesson
-
16Find & Replace OptionsVideo lesson
-
17Find & Replace using * Wild CardVideo lesson
-
18Find & Replace using ? Wild CardVideo lesson
-
19Find & Replace based on Cell FormatVideo lesson
-
20Understanding CellsVideo lesson
-
21Increasing Cell Size, Row/Column Height & WidthVideo lesson
-
22Understanding Excel Data TypesVideo lesson
-
23Dates are treated like Numbers in ExcelVideo lesson
-
24Intro to Cell FormattingVideo lesson
-
25Intro to Cell Formatting (2)Video lesson
-
26Intro to Numbers FormattingVideo lesson
-
27Customizing Numbers FormattingVideo lesson
-
28Behavior of Text and Numbers FormattingVideo lesson
-
29Customizing Date FormatsVideo lesson
-
30Cell Formatting SampleVideo lesson
-
31Chapter 2 - Working with Excel Data Part 1Quiz
-
32Intro to Data Sorting in ExcelVideo lesson
-
33Basic Data SortingVideo lesson
-
34Sorting Data that has empty rows or columnsVideo lesson
-
35A better way to sortVideo lesson
-
36More sorting optionsVideo lesson
-
37Advanced Sorting optionsVideo lesson
-
38Intro to Data Filtering in ExcelVideo lesson
-
39Clearing Filters & Using Search for FilteringVideo lesson
-
40Filtering data based on rulesVideo lesson
-
41Using Advanced FilteringVideo lesson
-
42Freeze PanesVideo lesson
-
43Use Outlines for Expand/Collapsible ButtonsVideo lesson
-
44Intro to Autofill and Fill SeriesVideo lesson
-
45Using Fill Dialog BoxVideo lesson
-
46Fill Series with Linear & GrowthVideo lesson
-
47Fill Series based on TrendsVideo lesson
-
48Using Flash FillVideo lesson
-
49Intro to Data Validation in ExcelVideo lesson
-
50Creating Dropdown Lists in ExcelVideo lesson
-
51Text to Different Columns with DelimitersVideo lesson
-
52Text to Columns using Fixed WidthVideo lesson
-
53Chapter 3 - Working with Data Part 2Quiz
External Links May Contain Affiliate Links read more