1296 Courses delivered Online

Microsoft Office Outlook 2016 Advanced Training Overview Are you looking to begin your Microsoft Office Outlook career or want to develop more advanced skills in Microsoft Office Outlook? Then this Microsoft Office outlook 2016 advanced online training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Outlook. This Microsoft Office outlook 2016 advanced online training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Microsoft Office outlook 2016 advanced online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a office admin. The Microsoft Office outlook 2016 advanced online training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a office admin. This comprehensive Microsoft Office outlook 2016 advanced online training course is the perfect way to kickstart your career in the field of Microsoft Office Outlook. This Microsoft Office outlook 2016 advanced online training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a office admin or want to learn more skills on Microsoft Office Outlook but unsure of where to start, then this Microsoft Office outlook 2016 advanced online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This Microsoft Office outlook 2016 advanced online training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive Microsoft Office outlook 2016 advanced online training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Outlook. Entry Requirement  There are no academic entry requirements for this Microsoft Office outlook 2016 advanced online training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Career path This Microsoft Office outlook 2016 advanced online training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Modifying Messages and Setting Global Options Insert Advanced Characters and Objects - Introduction Insert Advanced Characters and Objects in an Email Modify Message Settings and Options - Introduction Modify Message Settings, Properties, and Options Configure Global Outlook Options - Introduction Create Email Accounts and Setting Options Customize the Outlook Interface Organizing, Searching, and Managing Messages Organize, Search and Manage Messages - Introduction Sort and Group Your Messages Filter Messages Clutter Use Search for Outlook Items Managing Your Mailbox Manage Your Mailbox - Introduction Manage Junk Mail Manage Your Mailbox Automating Message Management Automate Message Management - Introduction Use Automatic Reply Organize Your Messages Create and Use Quick Steps Working With Calendar Settings Work with Calendar Settings - Introduction Manage Advanced Calendar Options Create and Manage Additional Calendars Manage Meeting Responses Managing Contacts Manage Contacts - Introduction Import and Export Contacts Edit and Send an Electronic Business Card Managing Activities by Using Tasks Assign and Manage Tasks - Introduction Manage a Task Sharing Workspaces with Others Share Workspaces with Others - Introduction Delegate Calendar Access Share Your Calendar with Another User Share Your Contacts Sharing with Another User Managing Outlook Data files Manage Outlook Data Files - Introduction Use Archiving to Manage Mailbox Size Create a Data File and Change Settings Course Follow-Up Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Microsoft Office is an office suite that can be used for business as well as for personal use. Although Microsoft Office is already rich with features and essential for productivity, with each new release, it continues to improve and enhance the office package. It's a wise investment for both your professional and personal life if you learn how to use Microsoft Office. Our Microsoft Office 2013 Complete Course course will help you hone your skills in Microsoft Office and take them to an advanced level.  This Microsoft Office 2013 Complete Course course involves advanced lessons on Word, Excel, PowerPoint, Access and Outlook. Throughout this course, learners will go through the practical skills, knowledge, and information needed to make full use of Microsoft Office apps. They'll explore all the key areas related to these applications and their proper utilisation.  Now is your chance to show potential employers that you are confident and comfortable with using Microsoft Office applications. Enrol now and explore the more complex features and tools of Microsoft Office.  Learning Outcomes:  Gain sufficient knowledge of the advanced features of Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, and Microsoft Outlook Understand how to produce standard documents using Microsoft Word Familiarise with the key skills to master Microsoft Excel worksheets Get a solid understanding of advanced accounting calculations Develop your creative PowerPoint presentation skills Familiarise with advanced editing and formatting tasks in Microsoft Word Understand how to perform advanced email tasks and learn how to manage Outlook data Learn how to create forms and reports using Microsoft Access Familiarise with PowerPoint's research tools and learn how to use these tools for preparing a presentation Learn how to create pivot tables and pivot charts and understand grouping and outlining data 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 Microsoft Word Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Advanced Editing and Formatting Tasks 01:00:00 Module Four - Working with Illustrations 01:00:00 Module Five - Formatting Pictures 01:00:00 Module Six - Adding SmartArt 01:00:00 Module Seven - Adding Tables 01:00:00 Module Eight - Inserting Special Objects 01:00:00 Module Nine - Working with Document References 01:00:00 Module Ten - Reviewing Your Document 01:00:00 Module Eleven - Using Comments and Tracking 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Word Advanced Level 00:00:00 Microsoft Excel Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel - Advanced Level 00:00:00 Microsoft PowerPoint Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with Shapes 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Advanced Drawing Tasks 01:00:00 Module Six - Adding Tables 01:00:00 Module Seven - Inserting Audio and Video 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Preparing for Your Presentation 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint Advanced Level 00:00:00 Microsoft Access Advanced Level Module One - Getting Started 00:30:00 Module Two - Using App Views 01:00:00 Module Three - Customizing Apps, Part One 01:00:00 Module Four - Customizing Apps, Part Two 01:00:00 Module Five - Working with More Record Tasks 01:00:00 Module Six - Using Advanced Field Tasks 01:00:00 Module Seven - Working in Table Design View 01:00:00 Module Eight - Working with the Expression Builder 01:00:00 Module Nine - Working with External Data 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Creating Forms and Reports 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access Advanced Level 00:00:00 Microsoft Outlook Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with Messages 01:00:00 Module Three - Customizing Your Profile 01:00:00 Module Four - Advanced Email Tasks 01:00:00 Module Five - Managing Junk Mail 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More With Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Printing 01:00:00 Module Eleven - Managing Outlook Data 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Outlook Advanced Level 00:00: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.

This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems

Course on all the Essentials of Microsoft Office Looking to learn everything there is about all the Microsoft Office programs? This course will give you exactly what you are looking for. Learn all there is about Microsoft Word, Excel, Outlook, PowerPoint, OneNote, Access, Publisher, Project, InfoPath, SharePoint Designer and Visio. Certified Microsoft Office Essentials introduces a new graphical interface user called the Fluent User Interface, which uses ribbons and an Office menu instead of menu bars and toolbars. Office also introduced Office Open XML file formats as the default file formats in Excel, PowerPoint, and Word. Office also introduces a feature called 'Live Preview', which temporarily applies formatting on the focused text or object, when any formatting button is moused-over. This Course is designed to make you learn everything about all the Microsoft Office tools of and all of its new features. Learning all the office softwares increases your credibility in today's competitive job market. So what are you waiting for? This is the course for you. Course Highlights Certified Microsoft Office Essentials is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Office Essentials into 77 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 2 days, 19 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Office Essentials Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Office Essentials is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Certified Microsoft Office Essentials 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Word for Beginners Accredited Course 00:00:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certified Microsoft PowerPoint for Beginners - Activities 00:00:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access FREE 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners CPD Accredited 00:00:00 Microsoft Outlook Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Outlook FREE 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Accredited Microsoft Outlook for Beginners 00:00:00 Microsoft Publisher Module One - Getting Started 00:30:00 Module Two - Opening Publisher 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Publication 01:00:00 Module Five - Working with Pictures 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Fonts 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Objects 01:00:00 Module Ten - Working with Pages 01:00:00 Module Eleven - Publishing Your Work 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Certified Microsoft Office Essentials 00:30:00 Final Exam Final Exam- Certified Microsoft Office Essentials 00:30:00

This Microsoft Office 2016 Excel VBA is designed to introduce you to VBA in as non-threatening a manner as possible. Beginning with wizards and macros, you will get through the methods and syntax of simple programming in VB, culminating in writing custom code, customizing Excel elements and debugging. In this course you will learn automation, styles, version tracking and mail merge, macros, customizing and tailor Word to suit your workflow, and more. You will gain confidence in using the more esoteric features of Word to create efficient long documents. Course Highlights Microsoft Office 2016 Excel VBA is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Office 2016 Excel VBA into 19 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Office 2016 Excel VBA Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Office 2016 Excel VBA is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Microsoft Office 2016 Excel VBA 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Developing Macros Create a Macro Using the Macro Recorder FREE 01:00:00 Edit a Macro FREE 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Formatting Worksheets Using Macros Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel VBA 00:00:00 Mock Exam Final Exam

Highlights of the Course Course Type: Online Learning Duration: 3 Hours 21 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Office Outlook Understand the core competencies and principles of Microsoft Office Outlook Explore the various areas of Microsoft Office Outlook Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Office Outlook 2016: Part 2 (Advanced) Training Course Master the skills you need to propel your career forward in Microsoft Office Outlook. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Office Outlook advanced course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Office Outlook advanced course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Outlook practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Outlook industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Outlook. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Outlook. Enrol in this Microsoft Office Outlook advanced course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Office Outlook advanced course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Outlook can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Office Outlook advanced course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Office Outlook advanced course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Office Outlook advanced course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Modifying Messages and Setting Global Options Insert Advanced Characters and Objects - Introduction 00:01:00 Insert Advanced Characters and Objects in an Email 00:12:00 Modify Message Settings and Options - Introduction 00:01:00 Modify Message Settings, Properties, and Options 00:05:00 Configure Global Outlook Options - Introduction 00:01:00 Create Email Accounts and Setting Options 00:09:00 Customize the Outlook Interface 00:09:00 Organizing, Searching, and Managing Messages Organize, Search and Manage Messages - Introduction 00:01:00 Sort and Group Your Messages 00:10:00 Filter Messages 00:05:00 Clutter 00:05:00 Use Search for Outlook Items 00:08:00 Managing Your Mailbox Manage Your Mailbox - Introduction 00:01:00 Manage Junk Mail 00:07:00 Manage Your Mailbox 00:07:00 Automating Message Management Automate Message Management - Introduction 00:01:00 Use Automatic Reply 00:07:00 Organize Your Messages 00:10:00 Create and Use Quick Steps 00:07:00 Working With Calendar Settings Work with Calendar Settings - Introduction 00:02:00 Manage Advanced Calendar Options 00:05:00 Create and Manage Additional Calendars 00:05:00 Manage Meeting Responses 00:09:00 Managing Contacts Manage Contacts - Introduction 00:01:00 Import and Export Contacts 00:08:00 Edit and Send an Electronic Business Card 00:08:00 Managing Activities by Using Tasks Assign and Manage Tasks - Introduction 00:01:00 Manage a Task 00:12:00 Sharing Workspaces with Others Share Workspaces with Others - Introduction 00:01:00 Delegate Calendar Access 00:08:00 Share Your Calendar with Another User 00:08:00 Share Your Contacts Sharing with Another User 00:04:00 Managing Outlook Data files Manage Outlook Data Files - Introduction 00:01:00 Use Archiving to Manage Mailbox Size 00:05:00 Create a Data File and Change Settings 00:08:00 Course Follow-Up 00:01:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Description: In this Microsoft Office 2016 New Features - Complete Video Course you will learn all the new features and enhancement in the latest version of Office, including suite-wide enhancements and program-specific new features in Word. Excel, PowerPoint, and Outlook. Learn about accessibility, the new charts and graphs Office insights, and new ways to uncluttered your inbox and group contacts. See how to make these features part of a more productive and efficient Office workflow. You will learn to work with files and folders, Browse the Internet with Microsoft Edge, manage workspaces with Virtual Desktop, explore the general environment of Office 2016. You will also learn how to use the key new features of Word, Excel, PowerPoint, and Outlook 2016. Get an introduction with the New Features of Microsoft Office and improve your knowledge and skills. So, don't be late and grab this course now. 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 New Features - 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 2016 New Features - 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. Word 2016 New Features New Themes FREE 00:26:00 New Chart Types 00:05:00 Excel 2016 New Features Power Query Enhancements 00:46:00 More Send As Options 00:04:00 New Chart Types 00:11:00 PowerPoint 2016 New Features Ink Annotations Pen Enabled 00:23:00 New Chart Types 00:07:00 Outlook 2016 New Features Archiving and Decluttering 00:19:00 OneDrive Integration 00:08:00 Mock Exam Mock Exam- Microsoft Office 2016 New Features - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 New Features - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office is a leading family of software, with over 1 billion users worldwide. Employers often expect their employees to have at least fundamental knowledge of its essential functions and features.  The Microsoft Office 2010 Essentials course is designed to help you master Microsoft Office and equip you with the practical skills to manage everyday administrative tasks with ease. Whether you have little or no experience, this training program will take you from beginner to expert in no time.  In this masterclass, you will familiarise with the essential features of Word, Excel, PowerPoint, Outlook and Access. You will learn how to create engaging presentations, automate tasks, create documents and much more. On course completion, you will have the practical skills to utilise Microsoft Office programs for ultimate career progression.  Learning Outcomes of The Microsoft Office 2010 Essentials:  Familiarise with Microsoft Office 2010's key functions and features Get expert training on Excel, Word, PowerPoint, Outlook and Access Go from beginner to expert in just a few hours & add new skills to your CV Learn how to automate tasks in Microsoft Excel using macros Utilise Microsoft PowerPoint to deliver killer work presentations and slides Understand how to format and align text Improve your proficiency in everyday administrative tasks Know how to create queries and reports in Access 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 Microsoft Word Module One - Getting Started 00:15:00 Module Two - Opening and Closing Word 00:30:00 Module Three - Working with Documents 00:20:00 Module Four - Your First Document 00:25:00 Module Five - Basic Editing Tasks 00:20:00 Module Six - Basic Formatting Tasks 00:25:00 Module Seven - Advanced Formatting Tasks 00:20:00 Module Eight - Formatting Paragraphs 00:30:00 Module Nine - Working with Styles 00:25:00 Module Ten - Formatting the Page 00:25:00 Module Eleven - Adding the Finishing Touches 00:25:00 Module Twelve - Wrapping Up 00:10:00 Activities - Microsoft Word 2010 for Beginners 00:00:00 Microsoft Excel Module One - Getting Started 00:15:00 Module Two - Opening and Closing Excel 00:20:00 Module Three - Your First Worksheet 00:20:00 Module Four - Working with Excel Files 00:20:00 Module Five - Viewing Excel Data 00:20:00 Module Six - Printing Excel Data 00:20:00 Module Seven - Building Formulas 00:30:00 Module Eight - Using Excel Functions 00:25:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 00:25:00 Module Eleven - Advanced Formatting Tools 00:25:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started 00:10:00 Module Two - Opening and Closing PowerPoint 00:30:00 Module Three - Working with Presentations 00:25:00 Module Four - Your First Presentation 00:30:00 Module Five - Working with Text 00:20:00 Module Six - Formatting Text 00:20:00 Module Seven - Formatting Paragraphs 00:30:00 Module Eight - Advanced Formatting Tasks 00:20:00 Module Nine - Customizing Slide Elements 00:30:00 Module Ten - Setting Up Your Slide Show 00:20:00 Module Eleven - Showtime 00:25:00 Module Twelve - Wrapping Up 00:20:00 Activities-Microsoft PowerPoint 2010 for Beginners 00:00:00 Microsoft Access Module One - Getting Started 00:15:00 Module Two - Getting Started With Access 00:30:00 Module Three - Using the Access Interface 00:30:00 Module Four - Working with Database Objects 00:35:00 Module Five - Creating Tables 00:30:00 Module Six - Working with Tables 00:35:00 Module Seven - Creating Forms 00:25:00 Module Eight - Working with Forms 00:40:00 Module Nine - Creating Reports 00:40:00 Module Ten - Creating Queries 00:35:00 Module Eleven - Managing Your Database 00:20:00 Module Twelve - Wrapping Up 00:10:00 Activities - Microsoft Access 2010 for Beginners 00:00:00 Microsoft Outlook Module One - Getting Started 00:20:00 Module Two - Opening and Closing Outlook 00:25:00 Module Three - Working with E-mail 00:20:00 Module Four - Creating a New E-mail 00:25:00 Module Five - Managing E-mail 00:30:00 Module Six - Managing Junk Mail 00:30:00 Module Seven - Outlook's Organization Tools 00:30:00 Module Eight - Searching for Items 00:20:00 Module Nine - An Introduction to the Calendar 00:35:00 Module Ten - An Introduction to Tasks 00:25:00 Module Eleven - An Introduction to Contacts 00:30:00 Module Twelve - Wrapping Up 00:45:00 Activities-Microsoft Outlook 2010 for Beginners 00:00: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.

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Office Access 2016 Understand the core competencies and principles of Microsoft Office Access 2016 Explore the various areas of Microsoft Office Access 2016 Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Office Access 2016: Part 2 (Intermediate) Course Master the skills you need to propel your career forward in Microsoft Office Access 2016. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft office access intermediate course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft office access intermediate course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Access 2016 practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Access 2016 industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Access 2016. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Access 2016. Enrol in this Microsoft office access intermediate course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft office access intermediate course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Access 2016 can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft office access intermediate course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft office access intermediate course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft office access intermediate course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Study Plex Subscription Study plex also provides a subscription option that allows you unlimited access to more than 700+ CPD courses for learning. You only need to spend £79 to take advantage of this fantastic offer, and you'll get an unlimited subscription for a full year. Additionally, you can cancel your membership from your account at any time by getting in touch with our friendly and devoted customer care team. Visit our subscriptions page for more details if you're interested. Why you should train with Study Plex? At Study Plex, you will have the chance to build social, technical and personal skills through a combination of extensive subjects tailored according to your interest. Along with receiving comprehensive knowledge and transferable skills, there are even more reasons o be involved with us, which include: Incredible Customer Support: We offer active customer service in the form of live chat, which you can access 24/7 Expert Tutor Support: You'll have access to our devoted and dedicated tutor support with all of our courses whenever you need it. Price Justified by Quality: We ensure that you will have the best experience possible for the price you are paying for the course. Money-back Guarantee: We provide a money-back guarantee if you are not satisfied with the course's quality. There is a 14-day time limit on this option (according to the terms and conditions). Instalment Facility: If your course costs more than £50, you can pay in three instalments using the instalment option. Satisfaction Guarantee: Our courses are designed to meet your demands and expectations by all means. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Designing a Relational Database Analyze the Relational Database Design Process 00:03:00 Understand Primary Keys 00:02:00 Explore Table Relationships 00:05:00 Create a Table 00:08:00 Create a Table Relationship 00:04:00 Joining Tables Joining Tables - Introduction 00:01:00 Inner and Outer Joins 00:02:00 Create Inner and Outer Joins 00:05:00 Join Unrelated Tables 00:03:00 Relate Data Within a Table 00:03:00 Work with Subdatasheets - Introduction 00:01:00 Work with Subdatasheets 00:04:00 Using Data Validation Use Data Validation - Introduction 00:02:00 Field Validation 00:04:00 Input Mask 00:08:00 Form Validation 00:04:00 Record Validation 00:05:00 Creating Advanced Queries Create Advanced Queries - Introduction 00:02:00 Create Parameter Queries 00:04:00 Use Wildcards in a Parameter Query 00:06:00 Create Queries with Multiple Parameters 00:02:00 Create Crosstab Queries 00:07:00 Update Queries 00:06:00 Update Queries 00:06:00 Append Queries 00:03:00 Delete Queries 00:06:00 Make Table Queries 00:02:00 Unmatched and Duplicated Queries - Introduction 00:01:00 Create Unmatched Queries 00:04:00 Create Duplicate Queries 00:03:00 Organizing a Database for Efficiency Data Normalization 00:05:00 The Table Analyser Wizard 00:06:00 Junction Tables - Introduction 00:01:00 Junction Tables 00:04:00 Improve Table Structures 00:08:00 Using Advanced Reporting Techniques Use Advanced Reporting Techniques 00:01:00 Conditional Formatting - Data Bars 00:05:00 Add a Calculated Field to a Report 00:04:00 Add a Subreport to an Existing Report 00:07:00 Bonus Lecture 00:01:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Easily learn the skills and knowledge you desire in MS Office with our Microsoft Office for Admin, you get an unparalleled learning experience with us and you get a digital certificate, transcript and a student ID card all included with the course price. What makes us the go to choice for people who want to learn about MS Office is our dedication and commitment to providing you with the best service possible. You will get unlimited access to the Microsoft Office for Admin, no matter where you are in the world you will be able to access your Microsoft Office for Admin any time you want. Should you have any questions while studying this Microsoft Office for Admin, our experienced tutors and mentors will answer them via email and live chat. With the original certificate you get after completing your Microsoft Office for Admin you will gain the CPD qualifications that will help you succeed out in the world and in your career. With our Student ID card you will get discounts on things like music, food, travel and clothes etc. Enrol in our Microsoft Office for Admin today and start learning. Why buy this Microsoft Office for Admin? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Office for Admin you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Office for Admin does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Office for Admin 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Office for Admin is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum 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:30: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 Outline1 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 View1 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 - 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 Presentatio 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 Options1 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 Database1 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