Boost Your Career By Enrolling In This Rail Training Advanced Diploma Bundle To Overcome Your Challenges! 15 in 1 Rail Training Advanced Diploma Bundle Did you know Over 1.8 billion passengers travel by train in the UK each year? Over 2,500 rail apprentices are now training in the United Kingdom, a critical industry for the country's infrastructure with an increasing demand for trained experts. Our Rail Training bundle offers an unparalleled opportunity for individuals aiming to excel in the dynamic rail industry. According to recent statistics, the UK rail sector supports over 600,000 jobs, highlighting the sector's vitality and potential for career growth. This comprehensive Rail Training bundle encompasses nine meticulously designed courses, covering various aspects from Trainee Train Driver to Port Management. Each course is structured to provide in-depth knowledge and skills, ensuring learners are well-equipped for the challenges and opportunities in the rail industry. With the UK rail network planning to invest £48 billion in infrastructure over the next five years, there has never been a better time to embark on a career in rail. This bundle ensures our learners are not just prepared, but ahead of the curve, in understanding and managing the complexities of the rail industry. This Bundle Contains 15 of Our Premium Courses: Course 01: Trainee Train Driver Course 02: Vehicle Maintenence Course 03: Driving Theory Test Preparation Course 04: Transport Manager Course 05: Import/Export Processing Course 06: Logistic Management Course 07: Delivery Manager Course 08: Delivery Driver Training Course 09: Port Management Course 10: Quality Management and Strategic Training - ISO 9001 Course 11: Lean Organisation Management Principles, Process and Techniques Course 12: Warehouse Course 13: Manual Handling Interactive Training Course 14: Project and Operation Management Course 15: Time Management Embrace the future of rail transportation with our Rail Training bundle and embark on a rewarding career journey. Learning Outcomes Acquire comprehensive knowledge of train operation and safety as a Trainee Train Driver. Master vehicle maintenance techniques crucial for rail industry efficiency. Understand and apply driving theory for optimal rail transportation safety. Gain skills in managing transport operations effectively as a Transport Manager. Learn import/export processing essentials for global rail logistics. Develop strategic logistic management skills for efficient rail network operation. Why Prefer Us? All-in-one package of 15 premium courses' Rail Training Essentials bundle Earn a certificate accredited by CPDQS. Get a free student ID card with this Rail Training Essentials Bundle Get instant access to this Rail Training Essentials course. Learn from anywhere in the world This Bundle is affordable and simple to understand This Bundle is entirely online, interactive lesson with voiceover audio Lifetime access to the course materials This Bundle comes with 24/7 tutor support Enrol now in this Rail Training Advanced Diploma to advance your career! This Rail Training Advanced Diploma's curriculum has been designed by experts with years of Rail Training Advanced Diploma experience behind them. The Rail Training Advanced Diploma course is extremely dynamic and well-paced to help you understand the Rail Training Advanced Diploma with ease. You'll discover how to master the Rail Training Advanced Diploma skill while exploring relevant and essential topics. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Rail Training Advanced Diploma bundle is suitable for everyone. Requirements You will not need any prior background or expertise to enrol on this Rail Training Advanced Diploma. Career path This Rail Training Advanced Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
ð Unlock Your Productivity Potential with 'Maximizing Efficiency Through Google Applications' Online Course! ð Are you tired of drowning in a sea of unorganized emails, scattered documents, and missed deadlines? Do you wish there was a magic wand to transform your work life into a seamless, efficient, and highly productive experience? Look no further! Introducing our groundbreaking online course: 'Maximizing Efficiency Through Google Applications.' ð⨠ð¥ What's Inside? ð¥ ð Master the Power of Gmail: Say goodbye to email overwhelm! Learn advanced techniques to streamline your inbox, automate responses, and effortlessly manage your communication flow. ðï¸ Google Drive Mastery: Discover the art of collaborative document creation and storage. Unleash the full potential of Google Drive to keep your files organized, accessible, and secure. ð Calendar Control: Never miss a deadline again! Maximize your scheduling efficiency with Google Calendar hacks, enabling you to manage your time like a pro. ð Data Dominance with Google Sheets: Turn raw data into actionable insights! Dive deep into Google Sheets and unlock the secrets of data analysis and visualization. ð¤ Automation Awesomeness with Google Apps Script: Become a Google Apps Script wizard! Automate repetitive tasks and customize your Google Apps to work seamlessly for you. ð¯ Optimize Your Workflows: Discover how to integrate various Google Applications to create personalized, efficient workflows tailored to your specific needs. ð¼ Business Boost: Explore how Google Applications can supercharge your business operations, enhance collaboration, and drive success. ð Expert-Led Learning: Benefit from the expertise of industry professionals who have mastered the art of productivity through Google Applications. Learn from real-world examples and practical scenarios. ð Accessible Anytime, Anywhere: Our online course is designed to fit your busy schedule. Access the materials whenever and wherever it suits you, and progress at your own pace. ð Transform Your Professional Life: By the end of this course, you'll not only be a Google Applications pro but also a productivity powerhouse. Transform your professional life and achieve more than you ever thought possible! ð¨ Don't Miss Out! Enroll Now and Take Control of Your Productivity Destiny! ð¨ Ready to revolutionize the way you work? Click the link below and embark on a journey to maximize efficiency through the unparalleled power of Google Applications! ð Join the ranks of successful professionals who have harnessed the full potential of Google Applications. Your optimized, efficient, and productive future starts now! ð Course Curriculum Basic Overview 00:00 Base Account Settings 00:00 G-Mail 00:00 G-Mail Productivity 00:00 Google Tasks 00:00 Desktop and Mobile Synchronization 00:00 Google Sites 00:00 Google Voice for Audio Contact and SMS 00:00 Google Voice for Business Tracking 00:00 Google Photos and Google Sites 00:00 Google Photos 00:00 Allo-Hangouts and Messenges 00:00 Google Duo for Video Calling 00:00 Chrome Remote Desktop 00:00 Google Keep 00:00 Google Drive 00:00 Google Calendar for Collaboration 00:00 Google Custom Search 00:00 Export Google Docs To WordPress 00:00 Conclusion 00:00 Advanced Overview 00:00 Create Text With Voice Typing 00:00 Record Audio in Google Chrome 00:00 Publish Audio On Google Podcasts 00:00 Publish Books on Google Play 00:00 Google Docs for Shared Word Processing 00:00 Google Sheets for Shared Calcualtion 00:00 Import and Export with Excel 00:00 Google Slides for Shared Presentations 00:00 Import and Export with PowerPoint 00:00 Recording A Voice Over with Google Slides 00:00 Presenting Live Using Google Slides 00:00 Google Hangouts for Real Time Video 00:00 Create Branded Video Content With YouTube 00:00 Create Branded Video Content For YouTube 00:00 Publishing Indexed (Google) Documents 00:00 Google Research Tools 00:00 Citation of Sources 00:00 Using Blogger 00:00 Conclusion 00:00
Who are these qualifications for? These qualifications are designed for managers and leaders who have the authority and responsibility for developing and implementing a coaching and mentoring strategy across the organisation. The qualifications require managers and leaders to build on their strategic management and leadership skills and to focus on the requirements of embedding the organisation’s strategy.
This course takes you through the concepts of Alteryx from scratch. With the help of interesting case studies, you will learn how to use Alteryx for joining datasets, performing union operations, finding and replacing text, sorting and filtering data, and a lot more.
***HGV, Transport and Logistics Management Training - CPD Accredited*** HGV driving is a valuable, rewarding and secure career in the UK, and the demand for HGV drivers through HGV, Transport and Logistics Management Training has also increased over the years. Getting a job as a driver with HGV training isn't very difficult compared to other jobs. Through HGV training and experience, you can eventually become an HGV instructor and even move into management. The starting salary as an HGV driver often starts at £19,000, and with time & experience, you can earn up to £36,000 to £40,000. As an instructor or manager, you will approximately earn more than £40,000. Our HGV training bundle course will introduce you to transport management, driver safety, car mechanic and repair, vehicle routing problems, driving instructor, logistic management, and so much more. Along with this HGV, Transport and Logistics Management Trainingcourse, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This HGV, Transport and Logistics Management Training Bundle Consists of the following Premium courses: Course 01: Large Goods Vehicle (LGV) Course 02: Transport Management Diploma Course 03: Freight Consultant Training Course 04: Vehicle Routing Problem with Spreadsheet Course 05: Driving Instructor Course 06: Driver Safety Awareness Certificate - CPD Certified Course 07: Car Mechanic and Repair Training Course 08: Engine Lubricant System Training - Level 4 Course 09: Import/Export Processing Course 10: Logistic Management Course 11: Manual Handling Level 2 Learning Outcomes Obtain the Large Goods Vehicle (LGV) qualification. Earn the Transport Management Diploma. Become a certified Freight Consultant. Solve the Vehicle Routing Problem using spreadsheet software. Obtain the Driving Instructor qualification (optional). Earn the Driver Safety Awareness Certificate. Understand and apply mechanic and repair techniques. Gain knowledge and apply engine lubrication systems. Describe and apply import/export processing principles. Learn and apply logistics management concepts. So, enrol now in this HGV, Transport and Logistics Management Training to advance your career! Curriculum of HGV, Transport and Logistics Management Training Bundle Course 01: Heavy Goods Vehicle (HGV) Module 01: Knowing Your LGV Module 02: Characteristics of Vehicle Module 03: Vehicle Limit Module 04: Loads and Load Restraint Module 05: Drivers' Hours and Records Module 06: Vehicles and Driving Module 07: Health and Conduct Module 08: Your LGV Module 09: Qualified LGV Driver Module 10: Provisional LGV Licence Module 11: CPC Test Part 01 and 02 Module 12: CPC Test Part 03 and 04 CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this HGV, Transport and Logistics Management Training. Requirements Our HGV, Transport and Logistics Management Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. Career path HGV, Transport and Logistics Management Training HGV Driver (£26,000 - £35,000 per year) Transport Manager (£30,000 - £45,000 per year) Freight Consultant (£30,000 - £40,000 per year) Driving Instructor (£30,000 - £40,000 per year) Vehicle Mechanic (£25,000 - £35,000 per year) Logistics Manager (£30,000 - £50,000 per year) Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Transport Management Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Microsoft Excel 2016 Advanced is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Microsoft Excel and looks at skills needed to improve Microsoft Excel. By taking this course you will gain the necessary skills to perform effectively in this field. The Microsoft Excel 2016 Advanced is organised into 6 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 8hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. 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 Video lessons 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. Course Content Automating Worksheet Functionality Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:30:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Auditing Worksheets Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Analyzing and Presenting Data Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Working with Multiple Workbooks Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Exporting Excel Data Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Importing and Exporting XML Data Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 Advanced 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Tired of browsing and searching for a Purchasing & Procurement course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Purchasing & Procurement bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Purchasing & Procurement course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Purchasing & Procurement and help you along your learning journey. Advanced audio-visual learning modules of these Purchasing & Procurement courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Purchasing & Procurement, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Purchasing & Procurement Bundle Consists of the following Premium courses: Course 1: Purchasing & Procurement Course - Level 3 Course 2: Logistic Management Course 3: Retail Operations Training Level 3 Course 4: Facilities Management Level 3 Course 5: Basic Product Management Course 6: Import/Export Processing Course 7: SAP Controlling (CO) - Product Costing S4HANA Course 8: Warehouse Course 9: Freight Consultant Training Course 10: Merchandising Course 11: Manual Handling Level 2 Course 12: Supply Chain Management Course 13: Level 2 Microsoft Office Essentials Course 14: Time Management Enrol now in Purchasing & Procurement to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Purchasing & Procurement expertise and essential knowledge, which will assist you in reaching your goal. Course Curriculum: Course 1: Purchasing & Procurement Course - Level 3 Module 01: Supply Chain Basics Module 02: Role of Procurement in an Organisation Module 03: The Purchasing Cycle Module 04: Purchasing Toolkits Module 05: Managing Competitive Bids Module 06: Quality Management Module 07: Supplier Relationship Management Module 08: Analysing and Reducing Risk in the Supply Chain Module 09: Improving Efficiency and Accuracy Module 10: Category Management Module 11: Inventory Management Module 12: E-Procurement ---------- Other Courses Are --------- Course 2: Logistic Management Course 3: Retail Operations Training Level 3 Course 4: Facilities Management Level 3 Course 5: Basic Product Management Course 6: Import/Export Processing Course 7: SAP Controlling (CO) - Product Costing S4HANA Course 8: Warehouse Course 9: Freight Consultant Training Course 10: Merchandising Course 11: Manual Handling Level 2 Course 12: Supply Chain Management Course 13: Level 2 Microsoft Office Essentials Course 14: Time Management How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Purchasing & Procurement bundle. Requirements Our Purchasing & Procurement course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Purchasing & Procurement expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Purchasing & Procurement Course - Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Description: Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is intended to prepare you to get complete control on Microsoft Office 2016. It is designed to educate about Microsoft Office 2016. In this course, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the essentials to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, adjust cells, create columns, rows and much more. This advanced course helps you to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Finally, you will learn how to set up and use Outlook on Windows. It will assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and so much more. Overall, this course is created especially for you to provide all information to access Microsoft Office 2016. Enroll today and get benefit from this course. Learning Outcomes: Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions Ways to update worksheet properties, create and edit macros, applying conditional formatting and add data validation criteria Auditing worksheets through tracing cells, troubleshooting invalid data and formula errors, watching and evaluating formulas, and creating a data list online Create Sparklines, scenarios and interactive data using Power View Perform what-if analysis and statistical analysis with the Analysis ToolPak Ways to multitask by consolidating data, linking cells in different workbooks, and merging them Export Excel data, import delimited text files, integrate Excel data with the web and create web queries How to import and export XML data PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets Change message settings, properties, options, using automatic replies and inserting objects Sort and filter options, organising and searching messages, managing junk mail and mailbox Managing advanced calendar options, additional calendars, meeting responses, and assigning tasks Advanced, forward and export contact options, handling contacts and editing electronic business cards Sharing calendars and contacts whilst also delegating access to mail folders to others Modifying data file settings and backing up Outlook items Email security and configuring email message security Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options 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 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) 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 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) 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. Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Advanced 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00