Microsoft Office Excel 2016: Part 2 (Intermediate Level)

Formulas and functions are at the core Microsoft Excel and learning to use them effectively is an essential step in becoming proficient in Excel. This course provides clear and easy-to-follow instructions on how to build formulas for analysis, projection and data cleansing. The course starts by discussing all of the different components that can be used to create a formula. You will be given clear demonstrations of the use of relative, mixed and absolute references, the use of dollar signs and how to name cell ranges to add clarity to your formulas.Naturally, Excel functions are discussed in depth and many examples of using functions to analyze your data, beginning with every day functions like SUM, AVERAGE, MIN and MAX.We then examine the use of text functions to clean up data prior to creating reports; functions like TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID and CONCATENATE.Next, we turn our attention to conditional functions like IF, IFERROR, AND and OR. These functions allow you to make the value displayed in a cell dependent on the results of logical tests.We then see how conditional functions can be combined with mathematical functions; using COUNTIF and SUMIF to produce calculations which only include those cells which match certain criteria. And, naturally, no discussion of Excel functions would be complete without lookup functions. We discuss the use of VLOOKUP and, also, how the INDEX and MATCH functions can be used to lookup up data whose format makes the use of VLOOKUP impossible. When you have completed this course, you will feel more confident about creating your own Excel formulas and taking advantage of Excel's wide variety of powerful functions. This course was last updated on 25th March 2017, with the addition of a new project: the creation of an invoicing model.

Basics of Time evaluation in SAP HCM On-Premise and S/4 HANAIn this course you can learn basic concepts in Time Management module of SAP HCM On-Premise and S/4 HANA systems. Learn standard configuration for Time pairs, Time types, Time IDs and Processing type for handling time evaluation efficiently. Understand how to write PCRs and SCHEMAs for time evaluation (RPTIME00) configuration and reduce dependency on ABAP technical consultants to achieve complex calculations using standard delivered Operations and Functions. Take advantage of the robust framework delivered by SAP for implementing time evaluation and accelerate realization phase of your implementation or change request from customer. Learn how to read time evaluation log and troubleshoot standard as well as custom error messages that frequently occur during time evaluation of employeesIt is a complete course on Time Management basic concepts and time evaluation configuration in SAP HCM On-Premise and S/4 HANA systems. It covers below topics:Introduction to Time Management in SAP HCMInfotypes used in Time ManagementBasics of Time EvaluationTime Evaluation configurationRead Time Evaluation logStandard Operations and Functions for time evaluationTime Evaluation using custom PCRs and SCHEMAsThis course would be helpful to below audience:Functional ConsultantsTechnical Consultants who wish to get a Techno-Functional roleEnd usersStudentsAspirants who wish to seek career in SAP HCM or SAP SuccessFactors

In this course, you will learn how to transform raw data into meaningful visual insights using Power BI, equipping yourself with a critical skill that every successful data analyst needs—data storytelling. You’ll gain hands-on experience with Power BI’s core features, including data modeling, advanced visualizations, and DAX calculations, all designed to help you craft compelling stories from complex datasets.Throughout the course, you'll work on real-world projects and scenarios that will sharpen your skills in creating interactive dashboards, insightful reports, and engaging presentations. These projects are specifically designed to give you practice in solving the kinds of data challenges you will face as a professional, ensuring you not only understand the concepts but can apply them effectively.By the end of this course, you’ll be able to confidently communicate your findings to stakeholders, make data-driven recommendations, and elevate your career as a data analyst. Whether you're already working in analytics or looking to enhance your skills, this course will empower you to create reports that inspire decisions, tell impactful stories, and make your data shine. The knowledge and practical experience gained here will prepare you to excel in any data-driven role. Get the course now.I hope to see you in the Class.

This course is designed to teach students an overview of SharePoint Site Owner roles and responsibilities. Students will learn to add and configure sites, create and configure libraries and lists, create and customize columns, and manage content types. Students will also learn to manage permissions and permission levels, create and modify site pages and work with navigation and regional settings.This course aligns with the CAP Body of Knowledge and should be approved for 5.25 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content!

Are you starting to learn AutoHotkey but don't know where to begin? Have some simple AutoHotkey questions you want answers to but don't want to wade-through hours of video? Then this AutoHotkey course is for you! This is part 2 of the most Frequently Asked Questions regarding AutoHotkey! Part 1 was a Free AutoHotkey course for people BEFORE they started to code. It had lots of free tools to help get started. This course continues on where we left off and begins to program in AutoHotkey.As in the last course the lessons don't "build" upon one another so you can jump around and get the AHK questions you have answered FAST!AutoHotkey is an amazing language designed for people that are not programmers! This means that AHK isn't as "strict" as most languages and there are lots of little things that cause confusion for people just starting out. This course addresses many of those "little things" that cause people grief when they first start programming in AutoHotkey.Learning AutoHotkey should not be difficult! This course is designed to help even the least technical person begin to code in AutoHotkey.Give the AHK FAQ course a try and start learning today! Remember, if you're not, in any way, satisfied, all Udemy courses have 100% money back guarantee!Joe Glines Isaias Baezthe-Automator / RaptorX

This course will be applicable for students who want to learn Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.In this course, students learn about the basic order capture and order fulfillment flows that Oracle Order Management facilitates, and also learn how to perform setup steps, including transaction type, document sequence, order import, and hold setup, that enable these flows. Students learn how to perform the Oracle Inventory setup steps that support Oracle Order Management, including how to create subinventories, units of measure, and items. Students also learn how to perform required Oracle Receivables setup steps, including how to create customers, payment terms, and territories, and how to define credit checking. The course includes information about how to enable multiple organization access control (MOAC) specifically for Oracle Order Management.Learn To:Set up Oracle Order ManagementManage exceptions and holdsUse key Sales order flows (Quote to Order, Blanket agreement to Order and other 10 such flows)Set up Shipping Execution and basic Pricing functionalitySetup configure to order (BOM,Routing, WIP etc.) end to end flow (Model BOM,Option class and options, Option specific routing)Setup basic pricing and integrate with order managementThe training mode will be real time trainer performing transaction on R12 instance and same is video recorded in 720p HD recording. Course will typically take 12+ hours of videos.This course is advisable for any level of experienced (beginers, Intermediate or expert) as this course is very detailed and comprehensive. Ideally students looking for functional consultant role for new implementation or upgrade or support role should take this up. It is expected that students are well aware of Oracle Apps EBS basics, Navigation