Microsoft Excel – Beginners Introduction to Excel (Volume 3), A non-technical professional guide to using Microsoft Excel.
Course 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:
- 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
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.