oaxino Posted April 6 Report Share Posted April 6 Learn Microsoft Excel Automation From Scratch + SapPublished 4/2024MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHzLanguage: English | Size: 2.34 GB | Duration: 2h 43mBeginner-Friendly Microsoft Excel Automation Crash Course for Business, Including SAP Automation and Much MoreWhat you'll learnYou will learn the basic fundamentals of Microsoft Excel effortlessly. You will level up your knowledge as you progress all the way to automationYou will learn all the skills needed to be comfortable in any workplace. You will become independent and a very efficient Excel userYou will find the most optimal way of completing tasks, saving time and effort in the process. You will also identify manual,repetitive work and automate it.Learn the basics of AI and how you can leverage it for your work.RequirementsNo required skills needed.DescriptionWhy do boring work when you can automate?!Save 90% of your time by creating a hyper-automated Excel file that works instead of youPicture this; Your automated Excel file that works instead of you.Sounds too good to be true, right?! Wrong.The Complete Step-By-Step CourseThe one-in-all solution for all your Excel Automation needs and a step-by-step guide to automate 90% of your work.Here is what you will learn:Excel Basics For DummiesUseful & Practical FunctionsStrengthen The knowledge With Quick ExercisesUnderstand Pivot Tables effortlesslyExcel Automation Taking a Step FurtherBecome a Confident And Independent Advanced Excel UserExpert Excel Automation Mastery Made So Easy Even Total Beginners Will UnderstandSAP Automation Full TutorialAnd much more...Now let me tell you exactly... How my course will help you...Automate 90% of Your WorkExtremely Easy to SetupSuper Beginner FriendlyClear and concise step-by-step instructionsStraightforward crash course - no beating around the bushWho Am I?I'm Sandi Srkoc, a 35-year-old computer scientist from Slovenia. Passionate about making a positive impact, I've dedicated over a decade to the pharmaceutical industry Novartis and Sandoz.Excel is my key tool for data and process optimization, allowing me to bring efficiency and speed to the forefront. I've mastered Excel to not only advance personally but to support others, creating a lasting impact within the company.Moreover, I have decided to combine my 10+ years of experience into a single course that is easy to follow, aiming to help others make a lasting impact in their careers and improve their work-life balance.OverviewSection 1: Basic Excel StructureLecture 1 Basic Excel StructureLecture 2 What is a Workbook and WorksheetLecture 3 What is a Cell and How to NavigateLecture 4 Basic and Conditional FormattingLecture 5 Menu Tabs and Calculation (Manual vs Automatic)Section 2: Most Useful Functions in ExcelLecture 6 Most Useful Functions in ExcelLecture 7 Why Do We Use FormulasLecture 8 V(X)LOOKUP and MATCHLecture 9 SUM, SUMIF, SUMIFSLecture 10 AVERAGE, AVERAGEIF, AVERAGEIFSLecture 11 COUNT, COUNTIF, COUNTIFSLecture 12 DATE, EDATE, WORKDAYSLecture 13 FORMULA REFERENCINGLecture 14 KEYSSection 3: Pivot TablesLecture 15 Pivot TablesLecture 16 Inserting a Pivot TableLecture 17 Most Useful Layouts and FunctionsLecture 18 Pivot ChartsLecture 19 Data Models and Power PivotSection 4: Exercises and SolutionsLecture 20 Exercises and SolutionsLecture 21 ExercisesLecture 22 SolutionSection 5: Excel Automation Part 1Lecture 23 Excel Automation Part 1Lecture 24 Overview and SetupLecture 25 Basics of AutomationLecture 26 v(x)lookup alternative in automationLecture 27 Read the data from another fileLecture 28 Scrape the data from the internet and record a macroLecture 29 Forms and Advanced Data ValidationLecture 30 Pivot tables, Error Handling, and custom functionsLecture 31 Worksheet events, password protection, and moreLecture 32 Artificial InteligenceSection 6: Excel Automation Part 2 SAP AutomationLecture 33 SAP GUI Scripting and Connection with ExcelLecture 34 Automating Transactions Filter Section, Layout, and ExportLecture 35 Populating the Excel Workbook with and Export from SAPLecture 36 Copying Data from Excel to the SAP TransactionLecture 37 Changing Values in SAPThis course is designed for individuals at all levels of proficiency in Excel who seek to enhance their skills and efficiency in data management, analysis, and automation.,You use Excel for work and you want to easily elevate your skills to a whole new level.Screenshotsrapidgator.net:https://rapidgator.net/file/de00be6e13c37cd114bacee208532889/chyes.Learn.Microsoft.Excel.Automation.From.Scratch..Sap.part1.rar.htmlhttps://rapidgator.net/file/a1e679f3587062242cfbdddd2c70764a/chyes.Learn.Microsoft.Excel.Automation.From.Scratch..Sap.part2.rar.htmlhttps://rapidgator.net/file/73edbcab52fd7a7a1540f0d836c68d07/chyes.Learn.Microsoft.Excel.Automation.From.Scratch..Sap.part3.rar.htmlnitroflare.com:https://nitroflare.com/view/E599968D3AE9B77/chyes.Learn.Microsoft.Excel.Automation.From.Scratch..Sap.part1.rarhttps://nitroflare.com/view/A912A7F2F7CDAB5/chyes.Learn.Microsoft.Excel.Automation.From.Scratch..Sap.part2.rarhttps://nitroflare.com/view/DCF0ABC1633F021/chyes.Learn.Microsoft.Excel.Automation.From.Scratch..Sap.part3.rar Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now