MS Excel Basics for Professionals : Beginners Course

An step by step brief overview of accounting processes in SAP. gives you an understanding of the various accounts, various functions in finance and controlling, also details the purpose of each of the granular elements in SAP FiCo / Accounting. Instructions are in HD video. At the end of the lectures, you will receive the soft copy of the material discussed with more detailed notes and instructions. The course begins with Accounting in general, takes you through various accounts in financial accounts. drills down to details on each account type. It covers in details all the important concepts and approaches used in SAP Fico. The last section reviews controlling and associated cost concepts.

The Excel Master Class is a comprehensive course that provides you with the skills and knowledge needed to become proficient in using Microsoft Excel. The course is designed for individuals who want to enhance their proficiency in Excel, from beginners to advanced users.Guess What, we have a full lesson on creating your own Chat GPT in Excel.We also offer an optional Certified Certificate (in addition to the Udemy Certificate) from the prestigious Institue of Financial Accountants (IFA, UK). The Digital Certificate demonstrates your proficiency in Excel and can be displayed on your resume, LinkedIn profile, or website. The certificate comes at an additional cost of $100.The course is divided into three levels: Beginner, Intermediate, and Advance. Each level builds upon the previous one, gradually introducing you to more advanced features and capabilities of Excel. The course covers a wide range of topics, including creating and formatting worksheets, basic and advanced formulas and functions, pivot tables, macros, VBA programming, data analysis, and much more.The Excel Master Class also includes practical exercises and quizzes to help you apply what you have learned and test your knowledge. The course is self-paced, allowing you to learn at your own speed and convenience.Overall, The Excel Master Class is an excellent investment if you want to master Excel and become more productive in your work and personal life.

An introductory course about Oracle 19c Database from Oracle. Oracle has been the leading RDBMS vendor in the world. With the industry going towards Data Science and Artificial Intelligent, Database Management is a highly sought after skill. This course will introduce you to RDBMS concepts and also how to install Oracle 19c in a Windows 10 PC. This will also introduce you to Oracle DBA also known as Oracle Database Administration

This course provides a foundational understanding of Google Sheets. It begins with an introduction to its primary functions as a charting tool, simple database, and spreadsheet. Learners will learn to open Google Sheets, import and convert spreadsheets, and navigate the interface. The course covers essential components like the formula bar, rows, columns, cells, and ranges. It includes creating and saving spreadsheets, navigating, working with cells and ranges, and using data selection techniques. Learners will explore commands, copy and paste functions, and data types. Formatting values, using the autofill handle, inserting links, and understanding formulas and functions are also covered. The course emphasizes calculation hierarchy, creating basic formulas, and working with basic functions. Learners will understand cell references, formatting and aligning data, modifying columns and rows, and using borders and fill. Practical exercises include inserting notes, comments, and checkboxes, applying themes, using zoom tools, and working with tabs. The course also covers hiding and unhiding spreadsheets, sorting and filtering data, using filter views, freezing panes, finding and replacing, spell check, preparing spreadsheets for printing, changing settings, downloading and emailing files, sharing spreadsheets, and inserting and formatting charts. By the end, learners will manage and analyze data, create visually appealing spreadsheets, and collaborate effectively.

Welcome to the Microsoft Word Tutorial by Studyopedia.Microsoft Word is a word processor, released in 1983 by Microsoft. Word has documents. You can easily draw text in a Word document. It also has the option to choose templates. It supports bullet lists and numbered lists. We will see how to begin working on Microsoft Word, by comparing and combining multiple documents, With that, we will also learn how to create a word document, insert index, create a resume, etc. We will also see how to edit images in a word document, i.e. to Remove Background, Brightness, Contrast, Sharpen, Shadow, Position Text, Set Image Layout, Crop the image, set artistic effects, etc.In this tutorial, we will learn step-by-step how to walk through Microsoft Word and learn to work on it. Microsoft Word is a part of Microsoft Office. Since 2013, the Microsoft Office suite has been sold as Microsoft 365. The suite also includes Word, Excel, Powerpoint, Outlook, OneDrive, Sharepoint, Exchange, etc.In this course, learn:Format Text in a Word documentInsert Table of Content in a Word documentInsert page numbers in Microsoft WordCombine documents in Microsoft WordCompare documents in Microsoft WordSplit a Word document into twoCreate a table in Microsoft WordAdd a Table to Quick Access ToolbarEdit an image in a Word DocumentCreate a Resume in Microsoft WordConvert a Word Document to PDFChange language in Microsoft WordLet start!

This is a beginner and intermediate Microsoft Excel training class that requires no prior knowledge of Excel. The training provided in this class covers MAC and PC. Ideal for students who use a MAC and just as applicable to students who use a PC. The class starts be describing the interface and then explains different functions a user can utilize to perform a variety of analysis. This is a beginner and intermediate level class, no prior excel experience necessary. Following is a list of topics covered in class: Layout Standard Toolbar Formatting Toolbar Home Tab Layout Tab Tables Tab Charts Tab Smart Art Formulas Data Review Functions Sum Average Max Min Count Vertical and Horizontal Lookup Vertical and Horizontal Lookup with Index SumIf and AverageIf The IF Statement Nested IF Statement Vlookup nested inside an if statement