Microsoft Excel - Beginners Introduction to Excel
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
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:
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
Who this course is for:
- Aspiring Data Analysts and Data Scientists
- Finance Professionals
- HR Professionals
- Fresh Graduates
- Anyone that works with Excel
Instructors
Foresight BI & Analytics Global Solutions (Foresight BI) is a Business Intelligence and Data Analytics firm focused on delivering world-class Training and Consulting Services.
Our training objective is to ensure participants, understand technical concepts with ease.
Our Trainers are Microsoft Certified, with years of rich Training and Consulting experience.
Our Trainers are publishers of Best Seller Courses on Udemy, with reputations for simplifying technical concepts into a lay man's language.
Ahmed is a Microsoft Data Platform MVP, a Microsoft Certified Trainer, Microsoft Certified Educator, Microsoft Certified Power BI Data Analyst, Microsoft Certified Azure Enterprise Data Analyst, Microsoft Office Specialist Excel Expert ?(He needs to stop ?)
He has developed cutting edge solutions and trained various corporate clients on Business Intelligence and Financial Modeling. He has been consulting & training on Power BI since it’s early days in 2015.
Ahmed has trained courses on:
1. Power BI
2. Power Query,
3. Financial Modelling
4. Advanced Data Analysis & Reconciliation and
5. Data Presentation.
He is the Managing Partner & Lead Trainer at Foresight BI & Analytics.