Published 12/2022Created by Foresight BI & Analytics,Ahmed OyelowoMP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 58 Lectures ( 3h 59m ) | Size: 1.76 GB
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 The only experience you need is how to operate a computer. Windows Computer with Microsoft Excel Installed (Preferably Excel 2016 and above) 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:Chag Excel SettingsProtecting Excel with PasswordsNavigating between Excel Workbooks and WorksheetsWorking with Excel Data including:Formatting Excel ContentSorting and FilteringDifferent methods for copying and filtering dataDifferent methods for finding and replacing dataCreating Dropdowns in ExcelCreating Expand and Collapsible buttons in Excel Data RangesSeparating Texts to different columnsWorking with Excel Formulas includingSUM function and Auto Sum MagicAVERAGE functio and MAX functionsSMALL and LARGE functions Aspiring Data Analysts and Data Scientists Finance Professionals HR Professionals Fresh Graduates Anyone that works with Excel HomePage:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.
Themelli |
