SAP PS (Project System) - Plan, Execute & Control Projects

[UPDATED April 2020]SHORT Summary:Check out several examples of Office Automation using Excel UserForm. Apply these ideas in real life situations.***This course explains how simple and free Excel UserForm can be used to improve work with very basic and simple excel workbook:UserForm provides the advantage to have all relevant information in one place that helps to concentrate on task and be productive when dealing with information.UserForm allows customization of data entry to make sure users would collect 'clean' data Course is not focused to teach basics of the VBA coding by doing abstract coding exercises. Focus is made on understanding on how VBA code is applied for this particular situation. Learn coding by re-using provided examples in fun case studies.Ready-to-use templates could be used as is e.g. personal goal tracking templateThe course plan will be the following: Introducing you to the typical data collection – decision – reporting situationUnderstanding and quantifying advantage of UserForm using a funny competitionUnderstand “mechanics” of UserForm Case study on adding inputs to the UserForm How to deal with Images in UserForm Write information from UserFormCase study to add second UserForm and reuse the code How to create reports in PowerPoint from Excel data Case study to practice sending data to the PowerPoint slideBONUS: Archiving/Saving to SharePoint LibraryDrafting Outlook EmailsTemplate 'Set Powerful Goals'</

Hi there, in this Word tutorial course we’re going to learn Microsoft Word together. This is a project based course. We’ll work through real world documents such as a formal business letter, monthly newsletter, a really long business report, a timetable and a visually exciting interactive PDF product document. Projects in the course: Creating a formal business letterCreating a monthly company newsletterFormatting a long business report, adding charts graphs from ExcelCreating a timetable schedule using tablesCreating a company template using corporate fonts, colours imagesCreating a product overview PDF with basic interactivityCreating a business formPrinting personalised letterheads envelopes for client lists This course is for beginners. You don’t need any previous knowledge of Word or any desktop publishing experience. We will start right at the basics but quickly get into working with up to date modern features. You’ll work with images, logos specific company colours. You’ll create corporate templates and reusable styles - automatically personalizing them using Mail Merge. You’ll learn to make a monthly newsletter with links videos ready for sharing commenting. You’ll learn how to take charge of long documents; cleaning them up and adding professional graphs, infographics, tables and much more including exercise files. We will give you a printable 'cheat sheet'. I will be around to help.If you get lost you can drop a comment on the video 'Questions and Answers' section that is below every video I'll be sure to get back to you. So my friend, now is your time to go from Word Zero, to Word Hero and for you to become the Microsoft Word professio

Learn how to use the world’s most popular software tool for organizing and analyzing data.When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel.This is our most requested training course!Topics covered include:Navigating the interfaceCreating and saving workbooksSelecting and entering dataPerforming calculationsFormatting dataManaging multiple worksheetsCustomizing your optionsObjectives. You will be able to:Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering dataPerform calculations using formulas and functionsInsert and delete rows and columnsApply formatting to text, numbers, and cells including using Cell Styles and Conditional FormattingControl how your worksheets print using Page Layout options, Page Breaks, and Headers and FootersManage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheetsUse View features to compare workbooks, compare worksheets, or save Custom ViewsCustomize Excel by adding Groups to the Ribbon and modifying the Quick Access ToolbarCourse Goal: By the end of this course, you will be able to use to create your own workbooks and analyze your data.Learn how to use the world’s most popular software tool for organizin

Unlock the Secrets of Creating Digital Planners with Adobe InDesignOur meticulously crafted program is not just a course; it's a gateway to mastering Adobe InDesign for creating interactive digital planners and journals – the kind that captivates customers and keeps them coming back.Mastering Interactive Design Made Easy:Struggling with complex design software? Our course simplifies Adobe InDesign, making it accessible and easy to use. You'll learn to navigate and leverage InDesign’s robust features to create interactive planners and journals, perfect for today's digital-first world.Time-Saving Shortcuts and Techniques:Time is money, especially for a creative entrepreneur. We provide you with key shortcuts and insider tips to expedite your design process. These time-saving techniques are not just about working faster; they're about working smarter, allowing you to focus more on creativity and less on tedious tasks.Generating Ongoing Income with Digital Products:The digital marketplace is booming, and there's a high demand for quality digital planners and journals. Learn how to create a product once that can be sold repeatedly, establishing a passive income stream that can grow over time.Why Choose This Course?Expert Guidance: Learn from seasoned professionals who have navigated the digital product landscape successfully.Practical, Hands-On Learning: Engage with real-world projects and scenarios that prepare you for actual market challenges.Resource-Rich Content: Gain access to exclusive templates, import files, and backgrounds to kickstart your design journey.Course Highlights:Comprehensive Video Tutorials: Step

As an Instructor, that originally started my teaching career showing students Office Applications [i.e.: Excel, Word, PowerPoint Access] and of course Navigation of the Operating Systems almost two (2) decades ago, I decided to make this course after noticing that many students, no matter what field they were in, where having great difficulty with maintaining an organized file system within their computers.I wanted to make this course on FILE MANAGEMENT, because I believe it is the foundation that will help students going forward in either their IT career or any other space that requires the use of computers.Please check the curriculum so you can see the different topics I will be covering to help you with the organizational skills within your PC/Laptop.If you learn these basic concepts and apply them from the start, then you will be ahead of the game!Please keep in mind that I am a Network Engineer Cisco Instructor as well, and this knowledge is used throughout all aspects of IT, not to mention that is is required for any person that works in either an office environment and/or to maintain their personal files data in an organized and accessible manner.In today's world, everyone must learn FILE MANAGEMENT to be able to be productive in their jobs personal life.This course will teach students how to enable a folder to be shared so other users can access the same information in a secure manner.Of course, we will also dive into your hard drive so you can optimize it and be able to run applications much faster and access the data quicker for optimal results.

This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, create named ranges and utilize them in formulas, build Logical functions such as IF, AND, and OR, and use Lookup functions to locate and compare data. Students will also be introduced to and work with Excel’s Table feature, learning to create and modify Tables. Students will also create and modify PivotTables and PivotCharts to analyze large data sets, sort the data, and use Slicers and Timeline Slicers to filter the data. Additionally, students will create and modify Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.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.This course aligns with the CAP Body of Knowledge and should be approved for 4 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.