SharePoint Online part 1 Sites, Lists and Libraries

This is concise Excel course that will give you all the key ingredients to master how to use Excel and make you become proficient at using Excel to its full potential.The course starts at a basic level showing you the way around Excel, the ribbon and the different options you have at your disposal. The course then delves into the different functions Excel has, as well as the more advanced level features such as pivot tables, advanced formulas and charts alongside combining all these different functions together to create valuable dashboards and great ways of showcasing and highlighting important information in a clear and concise manner.The course has a number of sections and will go through the below functions and topics:1. Introduction - This will highlight the structure of the course and provide the basics needed to progress to more intermediate and advanced level content.2. Mathematical Functions - This section covers all the key mathematical formulas such as: sum, average, min, max and subtotal.3. Textual Functions - This section covers all the key textual formulas such as: concatenate, trim, length, upper, lower, proper, left, mid and right.4. Logical Functions - This section covers all the key logical formulas such as: if, and, or, countif and sumif.5. Date/time Functions - This section covers the date/time related functions such as: today. now. day. month, year and datedif.6. Lookup Functions - This section covers key look up formulas such as: vlookup, hlookup, index and match and xlookup.7. Data Tools - This section covers data tools such as: sorting, filtering, data validating, removing duplicates and text to column importing of data.8. Formatting data - This section covers how to format tables to highlight data effectively by the use of conditional formatting and other features.9. Pivot tables - This sect

This course is designed for the Excel beginner or the Excel user looking for a refresher. In this course you'll learn how to work with text and numeric data, create basic Excel functions, build impactful charts, and construct basic PivotTables. You'll also learn a variety of tips and tricks to improve your productivity in Excel. The course is taught using Excel 2016, but much of the content is relevant for older versions.

No tool is more important than your word processor.And Microsoft Word is the most popular word processor in use today. But, do you REALLY understand how to use Word, or do you hack through whatever tasks you need to complete? A strong understanding of Word can pay serious dividends in your productivity, efficiency, and the appearance of your documents. In this course, you'll meet expert online instructor Maggie Federici, who will take you through the fundamental, critical tools within Microsoft Word 365. You'll learn how to create documents that look great, are well structured, and (due to Word's editing tools) are generally error-free. With this course, you'll learn to put your most professional written work out there. Maggie will start with a review of Word Basics. She'll continue to demonstrate tools like the format painter, spelling and grammar check, and accessibility tools, which will make you far more productive and make your documents appear far more professional. Since this is Word 365, Maggie will also discuss the essential collaborative tools that allow you to work together with others.If you use Word and want to understand its features fully, this course is for you. Even if you're just getting started with the Microsoft 365 office suite, this course offers much! Join Maggie as she shows you how to become a Microsoft Word 365 power user!

In this course, you’ll build the skills you need to manage, explore, analyze and visualize data in Microsoft Excel using real-world projects and datasets.We’ll start by introducing the Excel landscape and interface, then dive into spreadsheet fundamentals like table structures, data types, formatting, sorting, and filtering.From there, we’ll dig into formulas and functions, introduce key topics like syntax, reference types, and common errors, and practice applying some of the most common and powerful techniques for data management and analysis. We’ll use functions to count and aggregate values, create logical tests, join data across tables, manipulate text and date values, and more. Next, we’ll introduce pivot tables, an essential spreadsheet tool for data exploration. We’ll prepare raw data for analysis, create views to slice and dice the data, apply different calculation options, and use tools like sorting, filtering, and calculated fields.Last but not least, we’ll dive into the world of data visualization and storytelling, review best practices for effective design, and bring our data to life using essential visuals like bar, line, and pie charts, scatterplots, histograms, and maps. This is a hands-on and project-based course designed to help you build practical data literacy and analytical thinking skills, whether you're brand new to the field or a professional analyst. You’ll explore unique, real-world datasets from Flight Delays to Sales Pipelines, practice applying the tools and techniques you learn throughout the course, and leverage AI tools like Microsoft Copilot to help accelerate your skills.COURSE OUTLINE:Introducing Microsoft ExcelCreate your first spreadsh

Transform your Microsoft Excel skills from beginner to expert with "Excel Zero to Hero 2026: Practical Skills Real-World Uses." This in-depth course is designed to equip you with the knowledge and practical expertise needed to master Excel for personal and professional success. Starting from the fundamentals, you’ll explore topics like navigation, cell formatting, and basic formulas. As you progress, you'll delve into advanced features such as VLOOKUP, INDEX-MATCH, PivotTables, and conditional formatting. You'll also learn powerful data analysis techniques, automation using macros, and creating compelling data visualizations through charts and dashboards. What sets this course apart is its focus on real-world applications. Through hands-on projects and case studies, you’ll gain practical experience in organizing data, analyzing trends, and generating reports that drive actionable insights. Whether you're managing business data, streamlining workflows, or improving your productivity, this course has you covered. update: Learn the top AI tools every professional needs to boost productivityDesigned for students, professionals, and entrepreneurs, this course will build your confidence in Excel and help you tackle challenges with ease. By the end, you’ll be prepared to handle any Excel-related task and impress with your newfound expertise. Join now and become an Excel hero in 2026!About Your InstructorSekhar Metla is a software engineer with 20+ years of professional experience. He is the author of several online-selling courses with more than 1,78,000+ students in many countries. He has a Master of Science in Computer Applications in Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.

Dear Students,This course is designed in such a way that any beginners or freshers or candidates from any domain can learn SAP FICO Configuration, Implementation and End-User Activities pretty easily.If you observe, many faculties are putting more stress on explaining "how to do the configuration" but when you go for an interview, the interviewer will ask you about “why to do” i.e. logic behind configuration.Hence, In this Course i have explained both i.e. "how to do" and "why to do"To explore further ,please check preview videos.Who this course is for:Anyone who wants to learn SAP FICO configuration ,End-user Activities, implementation in detailSAP end Users who want to extend their knowledge by learning configuration to become SAP FICO consultantAny ERP Consultants who want to learn SAP FICO configuration and implementationThis Course is designed to become Successful SAP FICO Consultant with practical understanding of All Typical Business Process in SAP FICOThis tutorial will be extremely useful for professionals who aspire to learn the ropes of SAP FICO and implement it in practice. It is especially going to help consultants who are mainly responsible for implementing the finance module.Disclaimer SAP is a registered trademark of SAP AG in Germany and many other countries. I am NOT associated with SAP.Who this course is for:Any beginners or freshersCandidates from any domainSAP End UsersG/L Accountant / ControllerAP AccountantAsset AccountantsAR AccountantOther Finance Users - Accounting Manager/Finance Manager/ControllerCommerce Graduates -FresherAnyone who is interested in the subject