Microsoft Excel for Beginners

Do you want to be know as the Excel VBA Expert in your organization? Do you want to automate your tasks to get more done faster? Are you tired of all of the boring Excel VBA courses? Then this course is perfect for you! Become an Excel Visual Basic for Application Expert by writing video games!This course will cover the Excel VBA basics. You will learn the different types of variables and when to use each type. You will learn how to organize your code for faster debugging. You will learn how to reference different Excel objects (workbooks, worksheets, shapes, etc.). You will learn how to use conditions (If... Then..., Select Case...) to ensure your game player has the best experience possible. You will also learn how to use loops to automate tasks and eliminate time wasting!In this course you will create three full-size games! Outsmart your players in Hangman. Challenge your players to maximize their high score in 2048. Can you reach the final prize in Millionaire Trivia? Each game is shown from start to finish allowing you to learn every detail about the source code.Join the Excel Gamemakers community. Let's have some fun making video games and learning Microsoft Excel VBA Macros!

If you are really new to Excel dashboards or data analytics in general or you want to advance your knowledge, this is the course for you. We have provided you with the fundamentals you need to work with Excel efficiently and effectively.This dashboard is going to take you through Power Query, Power Pivot, Modeling, and DAX (Data Analysis Expression).Learning this advanced Excel Dashboard will make you use Power BI with ease as it uses DAX for computation and Power Query for cleaning and data transformation.Our aim in this course is to show you how to analyze data and create a visualization from the different tables without you using Xlookup, VLOOKUP or Index and Match but just with simple data Modeling in Power Pivot.This course is 100% practicalMicrosoft Excel is the most commonly used data analysis tool available on the market today. In this course, we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)Say no to a boring dashboard. With this course, you will start creating a very powerful interactive and dynamic Excel dashboard from day one.If you are ready to learn with me, let's join the class and see how creative you could be in the few days to come as you begin the class.Remember you have life Time access to this course.This course will be updated frequently with the new dashboard.be free to ask questions should you got stuck in any of the steps.I am already waiting for you in the class, nice to have you.

This course includes downloadable course instructor files and exercise files to work with and follow along.Welcome to Microsoft Word for Beginners. Throughout this short course, you will explore the basic features and interface of Word. Through engaging hands-on exercises and real-world examples, you'll gain proficiency in utilizing the various tools and techniques, enabling you to navigate Microsoft Word with confidence.You’ll start by exploring the Word interface and learning how to work with the ruler and zoom tools to control your layout better. Discover how to check spelling as you type, customize the Quick Access Toolbar for efficiency, and use keyboard shortcuts to speed up common tasks. You’ll also become familiar with helpful features like screentips, contextual menus, and ribbons to streamline your experience.Whether you're a student, a working professional, or someone eager to elevate your proficiency, this course empowers you to unleash the full potential of Microsoft Word. With foundational skills in place, you’ll be well-prepared to create, edit, and manage documents effectively in any personal or professional setting.In this course, you will learn how to:Navigate the Start Screen to create and manage documents effectively.Explore the Word Interface for seamless document manipulation and navigation.Utilize the Ruler and Zoom functions to enhance document layout and visibility.Customize the Quick Access Toolbar for efficient access to frequently used commands.This course includes:73 minutes of video tutorials11 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

سيكون هذا الكورس مناسب لمستواك اذا كنت مبتدأ و سيتم تعليمك من الصفر حتى تحترف البرنامج في نهاية الدورة التدريبية هتتعلم ازاي تعمل ملف احترافي في برنامج الوورد و هتتعرف على كل اداة و اي الوظيفة الي بتقوم بيها وازاي تستخدمها كمان هيكون الكورس مناسب لكل المستويات و هتحس بالتقدم في مستواك في نهاة الكورس هنتعلم الادوات المهمة ليك ك مبتدأ و هنمر بادوات احترافية

Quickly Get a Solid Foundation on Excel 2019 Basics During this Microsoft Excel Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, through the basics of working with the basics on formulas and functions. In very little time you will master the basics of Excel that'll provide a sure foundation for more intermediate to advanced Excel techniques. At completion of this course you will have mastered the most popular Excel basic tools and have the foundational skills with a sureness to complete many daily Excel tasks with efficiency and ease. Below are just a few of the topics that you will master: Build a solid understanding on the basics of Microsoft ExcelWriting formulas and performing calculationsSUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functionsInserting headers and footers, and adjusting marginsPrint row and, or column page titlesColor code data that meet certain criteria with Conditional FormattingSave time applying formatting to other cells with shortcutsCopy formulas about with accuracy by applying Absolute and, or Mixed ReferencesSave time entering data using the AutoFill and FlashFill featuresSplit Worksheet, Freeze Panes and add Multiple ViewsNew to Excel 2019! Sound Feedback, Check Accessibility one click fix, Translate and more!

SAP Cash and Liquidity ManagementThis course teaches SAP Cash Management powered by S4/HANA. It will teach in detail Business Process, Configuration, End to end testing with hands on demonstration in SAP Hana system in the below topics· SAP Bank Account Management· SAP Bank Communication Management· SAP Cash Position Report and Liquidity Forecast· Treasury Payments- Bank to Bank Transfers· Cash Pool and Cash ConcentrationSAP Bank Account Management: Learn to configure and use SAP Bank Account Management. Open, new bank account, Maintain Bank account, Display Banks, Close Bank accounts, set overdraft limit to Bank accounts, Perform Cash Concentration, Run FBAR reports etc.SAP Bank Communication Management: BCM is implemented to enable different levels of approvals for outgoing payment files using Workflow methodology. For e.g., based on Payment file amount, it can go for Auto approval, 1 person Approval or 2 Person approval. Learn to configure and use SAP BCM and SAP PMWB (Payment medium Work Bench)SAP Cash Operations: Under this topic you will learn business process, configuration and testing of SAP Cash Position Report, SAP Liquidity Forecast Report, Create and Manage Memo Records, Initiate Bank to Bank fund transfers in SAP, Cash Pool and Cash Concentration in SAP, Configuration and Data setup on SAP One Exposure Table (Single source of truth for Cash Management)