Home : Book details : Book description

Description of  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 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 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 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.