5453 Courses delivered Online

Delve into the world of SAP Controlling (CO) - Product Costing S4HANA, a course meticulously designed to usher learners into the sophisticated realm of financial management and cost analysis within the SAP ecosystem. This course, spread across nine comprehensive sections, offers a unique opportunity to grasp the intricacies of SAP CO with a focus on product costing. It meticulously covers an array of topics, from the basics of material master data and pricing controls to the complexities of cost component structures and standard cost estimation execution. The curriculum is crafted to not only impart theoretical knowledge but also to equip learners with the skills to apply these concepts in real-world scenarios, making it a vital tool for anyone looking to excel in the field of financial controlling and cost management. The journey through this course is an enlightening one, offering insights into the core aspects of SAP CO, such as BoM (Bill of Materials), activities, and routing, as well as the nuances of overheads in costing, cost sheets, and costing variants. Each section is tailored to provide a deep dive into the respective areas, ensuring a thorough understanding of every facet of product costing within the S4HANA environment. Whether you are a novice in SAP or looking to enhance your existing skills, this course stands as a beacon of knowledge, guiding you towards mastery in SAP CO Product Costing. Learning Outcomes Gain a thorough understanding of SAP CO's role in product costing, including the integration of material master data and pricing controls. Acquire the ability to efficiently manage and utilise BoM, activities, and routing within the SAP environment. Develop competence in managing overheads and understanding the implications of costing sheets in the costing process. Learn to configure and apply costing variants effectively in various business scenarios. Master the process of executing standard cost estimation, enhancing decision-making skills in cost management. Why choose this SAP Controlling (CO) - Product Costing S4HANA course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this SAP Controlling (CO) - Product Costing S4HANA course for? Individuals aiming to advance their careers in financial controlling and cost management. SAP enthusiasts keen to deepen their knowledge in the specific area of product costing. Business analysts and consultants seeking to add SAP CO expertise to their skillset. Finance and accounting professionals aspiring to integrate SAP CO into their work. Managers and decision-makers looking to improve cost efficiency and financial decision-making in their organisations. Career path SAP CO Consultant (Average Salary: £45,000 - £65,000) Financial Controller (Average Salary: £55,000 - £75,000) Cost Analyst (Average Salary: £40,000 - £60,000) Business Process Consultant (Average Salary: £50,000 - £70,000) Management Accountant (Average Salary: £45,000 - £65,000) ERP Analyst (Average Salary: £42,000 - £62,000) Prerequisites This SAP Controlling (CO) - Product Costing S4HANA does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Introduction Unit 1: Introduction to the Course 00:02:00 Unit 2: Introduction to Product Costing 00:02:00 Unit 3: Scenario for Product Costing 00:03:00 Section 02: Material Master Data and Pricing Controls Unit 1: Create Material Master Data; Introduction to MAV, Standard Price and Planned Price 00:14:00 Section 03: BoM, Activities and Routing Unit 1: Introduction to Bill of Materials, Activities, Routing and Overheads 00:08:00 Unit 2: Introduction to Activity Type Price Planning 00:05:00 Unit 3: Configuration of Bill of Materials 00:04:00 Unit 4: Configuration for Activity Types and Creation of Secondary CE in S4HANA 00:09:00 Unit 5: Configuration for cost element input planning 00:09:00 Unit 6: Configuration for Activity type price planning 00:04:00 Unit 7: Activity price calculation 00:03:00 Section 04: Overheads in Costing Unit 1: Configuration for Overhead Management 00:05:00 Unit 2: Configuration of Overhead Key and Overhead Group 00:08:00 Section 05: Costing Sheet Unit 1: Introduction to Costing Sheet 00:04:00 Unit 2: Configuration of Costing Sheet 00:13:00 Section 06: Costing Variant Unit 1: Introduction to Costing Variant 00:05:00 Unit 2: Configuration of Costing Variant 00:07:00 Section 07: Routing and Work Centres Unit 1: Introduction to Routing and Work Centres 00:03:00 Unit 2: Configuration for Routing and Work Centres 00:21:00 Section 08: Cost Component Structure Unit 1: Introduction and Configuration of Cost Component Structure 00:08:00 Section 09: Execution of Standard Cost Estimation Unit 1: Steps in Standard Costing Run 00:02:00 Unit 2: Execution of Cost Estimation Run 00:05:00 Unit 3: Marking and Releasing the cost 00:05:00 Resources Resources - SAP Controlling (CO) - Product Costing S4HANA 00:00:00 Assignment Assignment - SAP Controlling (CO) - Product Costing S4HANA 00:00:00

In the bustling realm of financial operations, streamlining processes is paramount. 'Efficient Accounts Payable Processing: Streamlining Financial Transactions' illuminates the pathway to enhanced financial transaction efficiency. Dive deep into the intricacies of Accounts Payable, exploring vendor management, invoice logistics, emergent technologies, purchase ledger management, and the art of financial budgeting, auditing, and reporting. Equip yourself with insights that transform complex tasks into simplified, coherent procedures. Learning Outcomes Understand the foundational concepts of Accounts Payable Processing. Gain proficiency in managing vendors for optimal transaction fluidity. Master the techniques of effective invoice and payment operations. Recognise and leverage cutting-edge technologies influencing Accounts Payable. Comprehend purchase ledger nuances and apply principles of financial budgeting, auditing, and reporting. Why buy this Efficient Accounts Payable Processing: Streamlining Financial Transactions? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Efficient Accounts Payable Processing: Streamlining Financial Transactions for? Financial analysts aiming to enhance their process comprehension. Accounts payable clerks aspiring for proficiency. Business owners desiring a streamlined financial operation. Finance students yearning for in-depth industry knowledge. Tech enthusiasts curious about technological integrations in financial processing. Career path Financial Analyst: £40,000 - £55,000 Accounts Payable Clerk: £20,000 - £25,000 Purchase Ledger Manager: £30,000 - £40,000 Financial Auditor: £45,000 - £60,000 Budget Analyst: £35,000 - £50,000 Financial Reporting Manager: £50,000 - £70,000 Prerequisites This Efficient Accounts Payable Processing: Streamlining Financial Transactions does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Accounts Payable Processing Introduction to Accounts Payable Processing 00:16:00 Module 02: Vendor Management Vendor Management 00:16:00 Module 03: Invoice & Payment Processing Invoice & Payment Processing 00:12:00 Module 04: Technologies in Accounts Payable Processing Technologies in Accounts Payable Processing 00:18:00 Module 05: Purchase Ledger Management Purchase Ledger Management 00:11:00 Module 06: Financial Budgeting, Auditing, and Reporting Financial Budgeting, Auditing, and Reporting 00:18:00

This course is a short and crisp introduction to those who do not have any prior knowledge of scripting or any programming basics. The instructor has tried to explain the concepts in such a simple terminology that even non-technical people will find it very easy to grasp the various Windows PowerShell concepts.

Harness the unlimited power of Microsoft Access by creating and maintaining your own basic database system, as well as learning how to develop user-friendly programs. Microsoft Access is a well-known and widely used data-management software application. This Microsoft Access course will teach you how to make the most of this versatile and useful programme, so sign Microsoft Access course up today to quickly gain a valuable new skill that will broaden your portfolio and advance your career. After completing this Microsoft Access course, you will have mastered the most commonly used Access tools and will be able to complete any access task with efficiency and grace. So why wait any longer? Enrol now and become a Microsoft Access guru! Upon completion of this Microsoft Access course, you will be able to: Fully understand tables, queries, reports, and forms Make useful database tables and effective reports Build dynamic user data forms Effectively retrieve data using access queries Automate access database tasks with Macros and VBA And more Why Prefer This Microsoft Access Course? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. *** Course Curriculum *** Here is the curriculum breakdown of the Microsoft Access course: Microsoft Access for Beginners Module 01 Orientation to Microsoft Access Create a Simple Access Database Get Help and Configure Options in Microsoft Access Module 02 Modify Table Data Sort and Filter Records Module 03 Create Basic Queries Sort and Filter Data in a Query Perform Calculations in a Query Module 04 Create Basic Access Forms Work with Data on Access Forms Module 05 Create a Report Add Controls to a Report Enhance the Appearance of a Report Prepare a Report for Print Organize Report Information Format Reports Assessment Process Once you have completed all the modules in the Microsoft Access course, you can assess your skills and knowledge with an optional assignment. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Access Course is for: Users wishing to advance their understanding of Microsoft Access from beginner to advanced Those who have used Access but want to learn some little-known tips, tricks, and shortcuts in order to become more efficient. This Microsoft Access course is also appropriate for students who have prior experience with Access and want to learn more about it. Entrepreneurs, office workers, teachers, and students interested in database work Requirements You will not need any prior background or expertise to enrol in this Microsoft Access Course. Career path Upon completion of this Microsoft Access course, learners will be able to add their new skills to their CV and take the very first step towards the following careers: Database Administrator: £37,000 Data Analyst: £32,000 Office Manager: £28,000 Administrative Assistant: £22,000 Business Analyst: £40,000 Project Coordinator: £27,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Description: To build a successful career, you need to have excellent presentation skills. As a result, you need to have expertise on different software. This Corel Presentations X3 Application Training will help you with just that. This course will teach you about Corel Presentations X3, a highly customizable software which includes animations of text and images, sounds, spreadsheets, etc. These features will facilitate you to make an attractive presentation and in turn, it will help you stand out among others in any professional field. So if you want to promote your career, this course should help a lot. Learning Outcomes: Common presentation applications, opening and closing the program, understanding the application and getting help Create blank presentations, enter text in standard and outline view, and edit and delete text Create presentations from a template, saving multiple times, opening presentations, switching between open presentations, and closing them Using editing tools like undo, cut, copy, find and replace, QuickCorrect and more Using viewing tools by changing views, using zoom, showing and hiding toolbars, and changing basic options Adding new, copying, moving and deleting slides; also discover how to change slide layout and design Explore how to apply master to a presentation, switch masters, add animations and slide transitions Format texts by changing font type, size, colours, applying effects, using alignment, styles and much more Discover how to choose an output format, use 'Show on the Go', add speaker notes, change orientation and size, access print settings and print out slides Hide and show slides, start and navigate through slide show, and stop the show Add pictures from a file or scrapbook, move, resize, cut, copy and paste them Working with data and organisation charts Working with and editing objects through drawing text box, shapes, rotation, resize and other options Create Master slides and footers, work with background and layout layers, and add dynamic elements Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Corel Presentations X3 Application Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Corel Presentations X3 Application Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started 01:00:00 Creating a Presentation 00:30:00 Working With Files 01:00:00 Editing Tools, Part 1 00:30:00 Editing Tools, Part 2 01:00:00 Viewing Tools 01:00:00 Basic Presentations 01:00:00 Designing a Presentation 01:00:00 Formatting Text 01:00:00 Finishing Touches 01:00:00 Delivering Your Presentation 01:00:00 Working With Images 01:00:00 Working with Data Charts 01:00:00 Working with Organization Charts 01:00:00 Working with Objects 01:00:00 Editing Objects 01:00:00 Master Slides and Layers 01:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 PowerPoint Advanced - Complete Video Course covers more advanced features of PowerPoint 2013. In this series, you will learn how to modify the PowerPoint environment, using methods like customizing design templates, working with media and animations, and adding SmartArt to a presentation, customizing a slide show and securing and distributing a presentation, use tables and spreadsheets to display data in a presentation, learn how to add, format and edit charts with the chart tools and quick clicks, design slide masters and apply slide transitions, apply animations to images in a slide show and edit the timing, add videos to a PowerPoint presentation and trim the media, practice delivering presentations with the presenter's tools, use the review tools to proof and protect presentations, and more. If, you have the basic skills with Microsoft Office 2013 PowerPoint and want to learn advanced-level skills then this course will be perfect for you. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 PowerPoint Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 PowerPoint Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Modifying the PowerPoint Environment Customize the User Interface FREE 00:12:00 Set PowerPoint 2013 Options 00:04:00 Customizing Design Templates Modify Slide Masters and Slide Layouts 00:12:00 Add Headers and Footers 00:06:00 Modify the Notes Master and the Handout Master 00:04:00 Adding SmartArt to a Presentation Create SmartArt 00:06:00 Modify SmartArt 00:07:00 Working with Media and Animations Add Audio to a Presentation 00:13:00 Add Video to a Presentation 00:12:00 Customize Animations and Transitions 00:14:00 Collaborating on a Presentation Review a Presentation 00:18:00 Store and Share Presentations on the Web 00:11:00 Customizing a Slide Show Annotate a Presentation 00:04:00 Set Up a Slide Show 00:04:00 Create a Custom Slide Show 00:04:00 Add Hyperlinks and Action Buttons 00:10:00 Record a Presentation 00:07:00 Securing and Distributing a Presentation Secure a Presentation 00:09:00 Broadcast a Slide Show 00:08:00 Create a Video or a CD 00:09:00 Mock Exam Mock Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields. The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Excel 2016 Introduction is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Excel 2016 Introduction is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Getting Started with Excel What is Excel 00:02:00 Opening Excel 00:04:00 Navigating the Excel User Interface 00:07:00 Using the Excel Ribbon 00:03:00 Understanding Excel Work Components 00:04:00 Using the Backstage View 00:03:00 Creating Workbooks and Using Templates Creating a New Workbook 00:03:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using Convert and Checking Compatiblity 00:02:00 Entering Data Navigating a Worksheet by Mouse or Keyboard 00:05:00 Excel Data Types 00:03:00 Cell and Range Addressing 00:02:00 Data Selection Techniques 00:05:00 Common Excel Commands 00:07:00 Using the Autofill Handle 00:03:00 Excel Formula Basics Data What are Formulas and Functions 00:02:00 Components of a Formula 00:06:00 Calculation Hierarchy Using the Order of Operations_Revise 00:02:00 Creating Basic Formulas 00:08:00 Working with Basic Functions and Autosum 00:04:00 Using Cell References 00:04:00 Using the Quick Analysis Tool 00:01:00 Adjusting a Worksheet Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:03:00 Formatting and Aligning Worksheet Data Formatting and Aligning Data 00:06:00 Merging Data 00:03:00 Wrapping Text Orientation 00:02:00 Formatting Numbers 00:03:00 Using Borders and Shading 00:03:00 Using the Format Painter 00:01:00 Removing Formatting Quickly 00:01:00 Using Cell Styles and Themes Understanding Cell Styles 00:02:00 Applying Cell Styles 00:04:00 Applying Themes 00:03:00 Inserting Objects and Graphics Inserting and Formatting Images 00:03:00 Inserting and Formatting Shapes 00:04:00 Inserting and Formatting Smart Art 00:04:00 Inserting Screenshots 00:02:00 Inserting Hyperlinks 00:03:00 Inserting Symbols and Equations 00:03:00 Inserting Word Art Or Text Boxes 00:04:00 Inserting Other Excel Objects 00:04:00 Arranging Objects 00:04:00 Proofing a Workbook Using Find and Replace 00:04:00 Finding and Replacing Formatting 00:01:00 Using Got to and Go to Special 00:02:00 Using the Spell Checker 00:03:00 Using the Theasaurus and Translation Feature 00:03:00 Printing an Excel File Printing and Previewing Excel Files 00:03:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:04:00 Formatting a Page with the Page Layout Tab 00:03:00 Printing Titles and Specific Worksheet Areas 00:05:00 Exporting to PDF and XPs 00:02:00 Managing Worksheets Renaming and Coloring Worksheet Tabs 00:03:00 Adding, Deleting, and Navigating Worksheets 00:03:00 Moving and Copying Worksheets 00:04:00 Hiding and Unhiding Worksheets 00:02:00 Navigating and Viewing Excel Files Viewing Workbooks 00:03:00 Using Zoom Tools 00:02:00 Configure Sheet Options 00:02:00 Using Freeze Panes and Split Commands 00:05:00 Working with Window Commands 00:04:00 Adjusting Workbook Properties 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Project 2016 Complete Course is one of our best. Offering excellent value for money, we can promise you high-quality and comprehensive content created by our subject matter experts. Organised into separate, digestible modules, the course is guaranteed to provide you with everything you need to know in order to accomplish your professional goals. If so, this is the perfect course to help you develop as a leader, and to learn how the Microsoft Project software package can be an essential tool in your project's success. This course will teach you how to exchange project plan data with other applications, customise element of your plan, and reuse project plan information. You will gain all the knowledge you need to plan, track and report on projects, in turn helping you set clear goals to manage in a cost-effective manner. By staying on top of seemingly minor details, you will develop essential skills in managing both your project and team effectively, now and in the future. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Anyone who already has an understanding of project management concepts, and possesses the basics in creating and modifying project plans in Microsoft Project 2016. This is an essential course for those who need to use Microsoft Project 2016 to manage and customise project plans throughout the implementation stage.

The Diploma in Event Management is a comprehensive online course designed to equip you with the essential skills and knowledge to excel in the fast-paced event industry. Whether you dream of organizing corporate conferences, weddings, music festivals, or sporting events, this course covers event planning, budgeting, marketing, logistics, and risk management. You’ll learn from industry experts through real-world case studies, interactive modules, and hands-on projects. This course blends theoretical knowledge with practical insights, ensuring you understand the latest trends, digital tools (like event management software), and sustainability practices in events. By the end, you’ll be able to plan, execute, and evaluate successful events while managing clients, vendors, and teams efficiently. Perfect for aspiring event planners, entrepreneurs, or professionals looking to switch careers, this diploma provides a globally recognized certification to boost your credibility in the industry. With flexible online learning, you can study at your own pace and gain access to exclusive resources, networking opportunities, and career support. Start your journey towards becoming a skilled event manager today! Learning Outcomes Master end-to-end event planning, from concept to execution. Develop budgeting and financial management skills for profitable events. Learn effective marketing strategies, including social media & branding. Understand venue selection, logistics, and vendor management. Gain expertise in risk assessment and crisis management. Utilise event technology & software (e.g., Eventbrite, Cvent). Enhance client communication and negotiation skills. Explore sustainable and eco-friendly event practices. Build a professional portfolio with real-world projects. Who is This Course For? This course is ideal for aspiring event planners, hospitality professionals, marketing executives, entrepreneurs, and career changers seeking entry into the event industry. It’s also beneficial for small business owners who want to organize their own events or corporate professionals handling company meetings and conferences. No prior experience is required—just a passion for creating unforgettable experiences! Career Path Event Coordinator – £22,000 - £30,000 Wedding Planner – £25,000 - £40,000 Corporate Event Manager – £30,000 - £50,000 Festival Organizer – £28,000 - £45,000 Conference Producer – £35,000 - £55,000 Exhibition Manager – £32,000 - £48,000 Why Enroll? Industry-recognised certification Flexible online learning Expert-led training & case studies Career support & job placement guidance Start your journey in event management today and turn your passion into a thriving career! 🎉