Learn Microsoft Excel Automation From Scratch + Sap
Published 4/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English
| Size: 2.34 GB
| Duration: 2h 43m
Beginner-Friendly Microsoft Excel Automation Crash Course for Business, Including SAP Automation and Much More
What you'll learn
You will learn the basic fundamentals of Microsoft Excel effortlessly. You will level up your knowledge as you progress all the way to automation
You will learn all the skills needed to be comfortable in any workplace. You will become independent and a very efficient Excel user
You 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.
Requirements
No required skills needed.
Description
Why 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.
Overview
Section 1: Basic Excel Structure
Lecture 1 Basic Excel Structure
Lecture 2 What is a Workbook and Worksheet
Lecture 3 What is a Cell and How to Navigate
Lecture 4 Basic and Conditional Formatting
Lecture 5 Menu Tabs and Calculation (Manual vs Automatic)
Section 2: Most Useful Functions in Excel
Lecture 6 Most Useful Functions in Excel
Lecture 7 Why Do We Use Formulas
Lecture 8 V(X)LOOKUP and MATCH
Lecture 9 SUM, SUMIF, SUMIFS
Lecture 10 AVERAGE, AVERAGEIF, AVERAGEIFS
Lecture 11 COUNT, COUNTIF, COUNTIFS
Lecture 12 DATE, EDATE, WORKDAYS
Lecture 13 FORMULA REFERENCING
Lecture 14 KEYS
Section 3: Pivot Tables
Lecture 15 Pivot Tables
Lecture 16 Inserting a Pivot Table
Lecture 17 Most Useful Layouts and Functions
Lecture 18 Pivot Charts
Lecture 19 Data Models and Power Pivot
Section 4: Exercises and Solutions
Lecture 20 Exercises and Solutions
Lecture 21 Exercises
Lecture 22 Solution
Section 5: Excel Automation Part 1
Lecture 23 Excel Automation Part 1
Lecture 24 Overview and Setup
Lecture 25 Basics of Automation
Lecture 26 v(x)lookup alternative in automation
Lecture 27 Read the data from another file
Lecture 28 Scrape the data from the internet and record a macro
Lecture 29 Forms and Advanced Data Validation
Lecture 30 Pivot tables, Error Handling, and custom functions
Lecture 31 Worksheet events, password protection, and more
Lecture 32 Artificial Inteligence
Section 6: Excel Automation Part 2 SAP Automation
Lecture 33 SAP GUI Scripting and Connection with Excel
Lecture 34 Automating Transactions Filter Section, Layout, and Export
Lecture 35 Populating the Excel Workbook with and Export from SAP
Lecture 36 Copying Data from Excel to the SAP Transaction
Lecture 37 Changing Values in SAP
This 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.
Free search engine download: Learn Microsoft Excel Automation from Scratch SAP
