Microsoft Excel - Excel with The Ultimate Excel Course

Learn Microsoft 365 Excel intermediate level going over basic table features, adding charts and graphs, working with functions, IF, VLOOKUP COUNTIF power functions, finalize printing saving workbooks, security and sharing workbooks. A downloadable Test Quiz is included with enclosed answer key. What you will learn: Introduction Excel 365 Intermediate Overview of entire course Excel 365 Intermediate Chapter 1 Basic Table features Chapter 1 Overview What tables are Sort and filter data part 1 Sort and filter data part 2 Creating and using tables Chapter 2 Adding charts and graphics Chapter 2 Overview Charts and Graphs What are Charts and Graphs and the difference Creating a chart Enhancing a chart Modifying chart data Changing chart types Inserting shapes and other features Working with chart elements Formatting charts Inserting pictures Creating in-cell charts with sparklines Chapter 3 Working with functions Chapter 3: Overview Statistical functions Using statistical functions Calculating present value Calculating loan payments and payoff Calculating principle interest paid Calculating interest rate, auto calculations Working with text functions Working with ranges Using date and time functions Working with logical functions Copying formula values Chapter 4 IF, VLOOKUP, COUNTIF, Power Functions Chapter 4 Overview Using the IF Function Using IF with relational operators Using the IFS function Using VLOOKUP Using VLOOKUP approximate table data Using VLOOKUP exact table data Using COUNTIF

Reimagine how you design, develop, and deliver learning programs using Microsoft Copilot.Learning Development teams are under more pressure than ever to build high-quality training faster, customize content for diverse audiences, and support organizational growth. Copilot changes what’s possible. This course gives L D professionals a practical, step-by-step guide for integrating Copilot into every stage of instructional design and training development.In this hands-on, scenario-based course, you’ll learn how to use Copilot across Word, PowerPoint, Excel, Outlook, Teams, and Copilot Chat to streamline content creation, automate repetitive tasks, improve training communications, and turn raw information into polished, usable learning experiences. Everything is built around real L D workflows—drafting learning objectives, designing instructor-led training, updating eLearning content, summarizing feedback data, preparing stakeholder updates, and managing training projects.We move far beyond theory. You’ll see exactly how to prompt Copilot to generate facilitator guides, build slide decks, analyze training metrics, create microlearning scripts, rewrite existing content, propose learning pathways, and brainstorm interactive activities. Every lesson is designed to save time, improve clarity, and elevate the quality of your learning materials.Whether you support leadership development, onboarding, technical training, compliance programs, or organizational development initiatives, this course equips you with the Copilot skills needed to enhance your impact immediately. Even if you’re brand new to AI or instructional design, you’ll be able to follow along easily with the guided examples and repeatable templates.If you want to work faster, design better learning, and stay ahead in a rapidly changing L D landscape, this course will help you transform how you work—starting today.

Excel is already powerful. Excel with Copilot changes how work gets done.This course teaches you how to use Excel Copilot inside MS Office 365 / Microsoft 365 to handle formulas, logic, data cleanup, analysis, pivot tables, charts, and everyday spreadsheet tasks with speed and confidence.Most Excel users struggle with formulas, nested logic, lookup errors, messy data, and slow reporting. They spend hours searching online or fixing sheets by trial and error. Excel Copilot removes that pain — but only if you know how to talk to it correctly.This course shows you how to think, ask, and work with Copilot so Excel becomes faster, cleaner, and easier.You won’t just watch features. You will practice real tasks:Writing formulas using natural languageFixing broken logic without guessingCleaning raw data in minutesCreating pivot tables and charts without manual setupSearching, sorting, and filtering large datasetsTurning questions into answers directly inside ExcelEach lecture follows a simple rule: one real problem, one clear solution using Copilot.By the end of the course, you will stop fearing formulas and stop wasting time on manual steps. You will know how to guide Copilot to do the heavy work while you stay in control.What changes after this course?Before:You Google formulas again and againYou hesitate with IF, VLOOKUP, XLOOKUP, and logicYou clean data row by rowYou avoid pivot tablesReports take too longAfter:You describe what you want, Copilot writes itYou check, adjust, and move onData cleanup feels quick and predictableAnalysis feels structuredYou focus on decisions, not syntaxThis course is

Purchase Requisition Release Procedure Step by Step Configuration with classification includes define characteristics, class and release codes along with multiple strategiesPurchase Requisition Release Procedure TestingPurchase Order Release Procedure Step by Step Configuration with classificationPurchase Order Release Procedure Testing at different approval levelsBusiness requirements of Release ProcedureQ A session videos on Release ProcedureFew issues related to Release Procedure discussions

Microsoft Excel is the go-to tool for working with data. There are probably a handful of people who haven’t used Excel, given its immense popularity. Excel is a widely used software application in industries today, built to generate reports and business insights. Excel supports several in-built applications that make it easier to use. To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them. A macro can do that for you. You can record a macro applying the format you want, and then replay the macro whenever needed.When you record a macro, the macro recorder records all the steps in Visual Basic for Applications (VBA) code. These steps can include typing text or numbers, clicking cells or commands on the ribbon or on menus, formatting cells, rows, or columns, or even importing data from an external source, say, Microsoft Access. Visual Basic Application (VBA) is a subset of the powerful Visual Basic programming language, and is included with most Office applications. Although VBA gives you the ability to automate processes within and between Office applications, it is not necessary to know VBA code or computer programming if the Macro Recorder does what you want.It is important to know that you when you record a macro, the Macro Recorder captures almost every move you make. So if you make a mistake in your sequence, for example, clicking a button that you did not intend to click, the Macro Recorder will record it. The resolution is to re-record the entire sequence, or modify the VBA code itself. This is why whenever you record something, it's best to record a process with which you're highly familiar. The more smoothly you record a sequence, the more efficiently the macro will run when you play it back.

nous avons pu classer le programme de cette formation en 17 sections et chaque section est divisée en sous section pour vous permettre de bien assimiler et comprendre les technique qui vous permettrez de gagner en efficacité sur la gestion des tâches répétitives nécessitant un tableur. Au-delà des fonctions de base, le contenu d'un programme de formation en bureautique peut porter sur des fonctionnalités plus complexes.لقد تمكنا من تصنيف برنامج هذا التدريب إلى 17 قسمًا وكل قسم مقسم إلى أقسام فرعية للسماح لك بالاستيعاب الكامل وفهم التقنيات التي ستسمح لك باكتساب الكفاءة في إدارة المهام المتكررة التي تتطلب جدول بيانات. بالإضافة إلى الوظائف الأساسية، يمكن أن يغطي محتوى برنامج التدريب المكتبي وظائف أكثر تعقيدًا.Section 01 : Organisation du tableau et des donnéesSection 02: Les Options Importantes d'Excel 01Section 03: Les Options Importantes d'Excel 02Section 04: Les Raccourcis Et Les FiltresSection 05: Les Formules Mathématiques 01Section 06: Les Formules StatistiquesSection 07: Les Formules Mathématiques 02Section 08: Les Formules TextesSection 09: Les Formules de DateSection 10: Les Formules de Recherches Section 11: Les Tableaux Croisés DynamiquesSection 12: Les Formules LogiquesSection 13: La Mise en Forme ConditionnelleSection 14: Introduction Power QuerySection 15: Introduction SolverSection 16: L'Analyse des ScénariosSection 17: Les Graphiques et la data visualization