SAP Data Science & ML for SAP Consultants

Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros. Topics include: What is Excel and what is it used for? Using the menus Working with dates and times Creating simple formulas Formatting fonts, row and column sizes, borders, and more Inserting shapes, arrows, and other graphics Adding and deleting rows and columns Hiding data Moving, copying, and pasting Sorting and filtering data Printing your worksheet Securing your workbooks Tracking changes

مايكروسوفت إكسل Microsoft Excelيعد مايكروسوفت إكسل Microsoft Excel أحد أهم البرامج بسبب دوره الرئيسي في العديد من القطاعات حيث إنه برنامج جداول البيانات الأكثر استخدامًا في الحسابات وفي العديد من أنشطة الأعمال والفصول الدراسية وحتى تنظيم البيانات الشخصية.أهمية برنامج إكسل :برنامج الأكسل هو من أروع برامج حزمة الأوفيس و هو برنامج مجانى مفيد فى العديد من المجالات منها المحاسبية و الهندسية و الإدارية وهو فى الأساس برنامج للجداول و التعامل مع الأرقام بشكل متميز .لا يمكن حصر وظائف لهذا البرنامج العملاق فيمكنك إعداد دراسات و مخططات بيانية ويمكنك عمل فواتير و برامج لإدارة المشتريات و المبيعات و كافة أوجه النشاط المحاسبى .أيضا يمكن الإستفادة منه فى المجال الدراسى من إعداد جداول الحصص و التقويم و رصد الدرجات فى الكنترولات المختلفة.كما يلعب الإكسل دورًا مهمًا للغاية في الرسوم البيانية حيث إنه لديه القدرة على إنشاء مجموعة متنوعة من الرسوم البيانية المختلفة ، والتي قد تستخدمها الإدارات في مختلف الشركات أو المؤسسات حيث يمكن تلك الشركات من الحصول علي إحصاءات تقديرية مفصلة موضحة بشكل بسيط علي هيئة أعمدة بيانية أو خطوط .. الخوايضا من المميزات الهامة لبرنامج الاكسل العبقري هو إعداد تقارير مختلفة وإحصائية لمؤشرات اداء الموظفين وإعداد التقارير المختلفة والتي تتيح للإدارات المختلفة إمكانية اتخاذ قرارات تصحيحية للإدارة العليا للوصول إلي أعلي أداء وكفاءة .

Microsoft PowerPoint for Beginners is an introductory on-screeen slide presentation course. The target audience for this course is anyone with little or no experience using Microsoft PowerPoint. Lesson content will be explained and presented in a way that is easy to understand and follow. This class includes 5 lessons: Orientation Basics, Formatting Editing, Working with Illustrations Objects, Transitions Animations, and Working with Slide Shows. With each lesson you will be provided with Microsoft PowerPoint learning files, a PDF for each lesson, a video that explains and demonstrates each concept in the lesson, an optional activity for each lesson and a 10 question multiple choice quiz. Upon completion of this course you will be able to create, edit, format, and run on-screen slide presentations in Microsoft PowerPoint. Learning Microsoft PowerPoint will provide a solid foundation for learning other on-screen slide presentation programs such as: Google Slides, Keynote, Visme, Prezi, Zoho Show, and Canva. Microsoft PowerPoint is one of the most widely used on-screen slide presentation software programs. Microsoft estimates that roughly half a billion people use the Microsoft Office suite, which includes PowerPoint.As our world becomes more and more digitally driven, it is necessary to develop skills that enable us to better create, edit and format digital information.

One of the most demanded skills in any industry is proficiency in Microsoft Word. While, the rest of the requirements may change depending on the occupation, Word has remained a constant across almost all careers. Microsoft Word is one of the most used word editor and is a part of Microsoft’s larger Office Suite. The latest version of Microsoft Word 2016 offers more improved functions such as Tell Me. From writing simple documents to essays, letters, resumes and even newsletters, Microsoft Word can be used for almost all your document writing and editing needs. In addition to writing, Word also gives you the freedom to change the text font, color and even add pictures to your documents. With Word, the sky is the limit! Do you want to learn how to master this complex document editor? Well, look no further! This course will break down and teach you Word in the EASIEST way possible. This SIMPLE, yet comprehensive Word 2016 course is the one-stop shop for learning and mastering Microsoft Word for any beginner. You will learn everything you need to know about Word and how to start using Word to increase your proficiency. From creating a simple document to learning more complex features, this course has got your back! Our Word course has been broken down into 11 different sections, each covering an aspect of Word and each section ending with a lab exercise and a Question and Answer document. You will not only learn how to create, edit, and save a document; but also more complicated functions of Word such as mail merge, macros and even indentations. The Word tutorial will also include understanding the components of a Word screen, getting started with Word, basic editing, formatting, sectioning, printing, adding clipart and images, adding bullets and numbering, incorporating tables, and so much more! With so much packed in this course, what are you waiting for? Let’s get started on making you a Word Wiz.

In this course, you will learn PowerPoint software from basic to advanced. And in the continuation of this course, you can create attractive motion graphics and infographics for your content.Also, you do not need to have powerful computer hardware. With any hardware you have, you can create motion graphics and infographics with PowerPoint and save a lot of money.Because after teaching, learning and, practicing the points presented in this training, you can easily create motion graphics and infographics for your content, get order work and generate income.Currently, PowerPoint software has more than 500 million active users, and an average of over 30 million PowerPoint presentation files are created daily.The popular PowerPoint software is best known for designing and creating presentation slides. But if you have mastered and learned PowerPoint and have a little creativity, you can produce content such as motion graphics and infographics with powerful PowerPoint software.Motion graphics videos have many uses. Like these:1. Making advertising teasers to introduce products, services, etc.2. Personal and business branding3. Making attractive educational videos on various topics and sharing them on your social media or website4. Content Marketing5. Content production for websites as well as social media such as YouTube, Facebook, Instagram, etc6. Culture building (It will be more attractive, better, and faster to introduce a cultural issue in the society with the help of motion graphics.)7. Making gifs and animated banners8. Designing animated infographicsetcWhy learn to create motion graphics and infographics with PowerPoint?Most of us are familiar with simple but powerful PowerPoint software, and it is enough to spend a little time and learn PowerPoint very

Hello, my name is Igor. I’d like to invite you to join over 1400 students to learn Excel conditional formatting in this course. Excel offers you quite a few amazing tricks that can instantly create a huge difference in your professional life - if you take just a little bit of time to learn. In this course, you’ll discover the amazing secrets of conditional formatting that will transform your spreadsheets from excruciatingly boring to infinitely more exciting - super-powerful and hyper-useful. The best part, it is so embarrassingly easy, you’ll be wondering why you haven’t decided to learn it before. In fact, you may feel that enrolling in this course may be one of the best decisions you’ve ever made - to improve your Excel skills. Now… when you take this course, you’ll get to enjoy several important benefits. First and foremost, this course will teach you how to transform your flat spreadsheets into colorful, dynamic, actionable reports. So you can immediately see what’s important in your data and make a decision faster. As a result, you’ll tremendously boost your productivity - since you’ll no longer need to squander your precious time squinting - looking for what’s important in your spreadsheets. This course may skyrocket your career as well. Because nothing in Excel creates the “wow factor” as conditional formatting. You’ll be astonished. And so will everyone else. What you are about to learn in this course will knock the socks off your boss, your clients, and your colleagues. It’s like taking a “couch potato” from 1950s and placing them in front of the latest LED HDTV panel. They’ll think you are a “God” from the future.<