Learn Microsoft Excel Automation From Scratch + Sap

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[/center]
| 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.