728 Microsoft Office courses

DURATION 1 DAYS 6 CPD HOURS THIS COURSE IS INTENDED FOR THIS COURSE IS DESIGNED FOR MICROSOFT© WINDOWS© AND MICROSOFT OFFICE USERS WHO ARE TRANSITIONING TO A SHAREPOINT ENVIRONMENT, AND WHO NEED TO ACCESS INFORMATION FROM AND COLLABORATE WITH TEAM MEMBERS WITHIN MICROSOFT SHAREPOINT. OVERVIEW LAUNCH A SHAREPOINT SITE AND NAVIGATE AMONG THE PAGES AND RESOURCES PROVIDED BY THE SITE. USE SHAREPOINT LISTS TO TRACK AND VIEW INFORMATION. USE DOCUMENT LIBRARIES TO STORE AND ORGANIZE DOCUMENTS. FIND, SHARE, AND ARCHIVE CONTENT STORED IN SHAREPOINT. AUTHOR DOCUMENTS AS A MEMBER OF A SHAREPOINT TEAM SITE. USE SHAREPOINT WORKFLOW AUTOMATION TOOLS. DESCRIPTION IN MANY PROFESSIONAL ENVIRONMENTS, PEOPLE WORK COLLABORATIVELY IN TEAMS. INFORMATION TECHNOLOGY AND APPLICATIONS FACILITATE THIS BY ENABLING PEOPLE TO EASILY SHARE, ACCESS, EDIT, AND SAVE INFORMATION. MICROSOFT© SHAREPOINT© IS A PLATFORM SPECIFICALLY DESIGNED TO FACILITATE COMMUNICATION AND COLLABORATION, ENABLING PEOPLE TO USE FAMILIAR APPLICATIONS AND WEB-BASED TOOLS TO CREATE, ACCESS, STORE, AND TRACK DOCUMENTS AND DATA IN A CENTRAL LOCATION. IN THIS COURSE, YOU WILL USE SHAREPOINT TO ACCESS, STORE, SHARE, AND COLLABORATE WITH INFORMATION AND DOCUMENTS. PREREQUISITES TO ENSURE YOUR SUCCESS IN THIS COURSE, YOU SHOULD HAVE BASIC END-USER SKILLS WITH A CURRENT VERSION OF MICROSOFT WINDOWS. LESSON 1: NAVIGATING SHAREPOINT SITES * Topic A: Launch SharePoint * Topic B: Gain Access to a Site You Didn't Create * Topic C: Navigate Within a SharePoint Site * Topic D: Access SharePoint from Your Mobile Device LESSON 2: USING LISTS TO TRACK INFORMATION * Topic A: Add and Populate Lists * Topic B: Change View Options * Topic C: Create a Custom View LESSON 3: USING DOCUMENT LIBRARIES TO SHARE AND ORGANIZE DOCUMENTS * Topic A: Store Files in a Document Library * Topic B: Create and Use Document Templates LESSON 4: FINDING, SHARING, AND ARCHIVING CONTENT * Topic A: Search for Items in Lists or Libraries * Topic B: Share Through Links * Topic C: Move Files Offline LESSON 5: AUTHORING DOCUMENTS AS A TEAM * Topic A: Work Together on Documents * Topic B: Manage File Versions and Document Recovery LESSON 6: AUTOMATING BUSINESS PROCESSES * Topic A: Use Rule-Based Automation * Topic B: Use Power Automate to Automate a Workflow

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. OBJECTIVES By the end of the course you will be able to: * Build and customise Pivot Tables * Group and sort information * Filter information * Use slicers and the timeline filter * Add different summary calculations * Create Pivot Charts * Add calculated fields and items CONTENT THE ANATOMY OF A PIVOT TABLE  * Using a Pivot Cache * Building a Pivot Table * The Pivot Table interface * Refreshing the Pivot Table * Adding column, row, page and data fields * Changing data orientation * Showing data fields in columns or rows * Drilling down to underlying data SETTING PIVOT TABLE OPTIONS   * Format options * Totals and filters options * Display and printing options * Data options CUSTOMISING PIVOT TABLES  * Modifying field names * Data formatting * Changing field layout options * Changing summary calculations * Working with subtotals FILTERING AND SORTING  * Filtering items * Sorting data * Value and label filters * Creating top 10 reports * Using the Search filter * Using the Slicer tool * Use the Timeline filter GROUPING  * Grouping date fields * Grouping numeric fields * Adding your own groups SUMMARY CALCULATIONS  * Running totals * Differences year on year, month on month * % Differences year on year, month on month * % of Row, Column, Total and other fields PIVOT CHARTS * Pivot Chart rules * Creating a Pivot Chart * Working with your Pivot Chart CREATING CALCULATIONS * Adding calculated fields * Adding calculated items

Master Microsoft Excel with the Microsoft Office Specialist (MOS) certification. Excel at data analysis, visualization, and productivity with expert-level skills. Excel your career with MOS - Microsoft Excel certification today.

Tired of browsing and searching for a Microsoft Office Course 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 Microsoft Office Course bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Microsoft Office Coursecourse that will enhance your skills and prepare you for the competitive job market. Also, ourexperts are available for answering your queries on Microsoft Office Courseand help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office Coursecourses 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 Microsoft Office Course, 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 Microsoft Office Course Bundle Consists of the following Premium courses: * Course 01: Level 2 Microsoft Office Essentials * Course 02: 50 Tips to Upgrade your Excel Skill * Course 03: New Functions in Microsoft Excel 2021 * Course 04: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query * Course 05: Microsoft Excel: Excel Sheet Comparison with VBA * Course 06: Microsoft Excel: Master Power Query in 120 Minutes! * Course 07: Data Analysis in Microsoft Excel Complete Training * Course 08: PowerPoint Diploma * Course 09: The Complete Microsoft Outlook Masterclass * Course 10: Complete Microsoft Power BI 2021 * Course 11: Outlook Tips and tricks * Course 12: Microsoft Teams * Course 13: Windows 10 Pro Complete Training * Course 14: Functional Skills IT The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Office Courseexpertise and essential knowledge, which will assist you in reaching your goal. Enrol now in Microsoft Office Course to advance your career, and use the premium study materials from Apex Learning. CPD 150 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone from any background can enrol in this SEN Teaching Assistant Bundle. REQUIREMENTS Our Microsoft Office is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. CAREER PATH Having this Microsoft Office 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 P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Level 7 Diploma(FREE QLS Endorsed Certificate)| 11-in-1 Bundle | Free Certificates | CPD Accredited | Lifetime Access

Unlock the full potential of Microsoft Office 2016 with our comprehensive course! From Word to Excel, PowerPoint, and more, master essential skills to boost your productivity and efficiency. Whether you're a beginner or seeking to enhance your proficiency, this course provides step-by-step guidance to navigate and utilize Office tools effectively. Enroll now and elevate your Microsoft Office skills to excel in your personal and professional endeavors!

We know how crucial digital skills are to the modern economy. In the UK, employers report that 33% of positions they find challenging to fill are partly due to applicants' inadequacies in this area. However, because "digital skills" encompasses a broad range of abilities, knowledge, and skills, it is challenging to develop programs that target digital skills demands. Fortunately, Apex Learning has already made an effort to shed light on the matter by highlighting the skills companies seek by summarising all you need to know in a 30-in-1 bundle of Microsoft Office Specialist (MOS) that serves as an excellent foundation to reach the advanced level of Microsoft office. With the help of this bundle, you may quickly and simply master all the most essential and significant aspects of Microsoft Office without wasting time on unimportant stuff. It is designed in a straightforward, easy, and approachable manner. In this bundle, you will be getting the following courses, Package Details: * Number of Courses: 30 Courses * Accreditation: CPD Quality Standards * Free Certificates: * PDF: 30 * Hardcopy: 30 (Delivery Charge Applicable) * Courses Access: Lifetime * Instalment Payment Available Microsoft Office Specialist (MOS) * Course 01: MS Word Diploma * Course 02: Proofreading & Copyediting * Course 03: PowerPoint Diploma * Course 04: Microsoft Excel Level 3 * Course 05: New Functions in Microsoft Excel 2021 * Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query * Course 07: Microsoft Excel: Excel Sheet Comparison with VBA * Course 08: Microsoft Excel: Master Power Query in 120 Minutes! * Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! * Course 10: Excel Pivot Tables * Course 11: Data Analysis in Microsoft Excel Complete Training * Course 12: Excel Must know Formulas and Functions * Course 13: Excel spreadsheet for Beginner * Course 14: Excel Data Analysis for Beginner * Course 15: Diploma in Excel Vlookup Xlookup Match and Index * Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines * Course 17: PowerBI Formulas * Course 18: Outlook Tips and tricks * Course 19: Excel PowerQuery and PowerPivot * Course 20: Complete Microsoft Power BI 2021 * Course 21: The Complete Microsoft Outlook Masterclass * Course 22: The Complete Microsoft OneDrive Course * Course 23: MS Access Tables and Queries for Beginner * Course 24: MS Access Databases Forms and Reports Level 3 * Course 25: Microsoft Teams * Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019 * Course 27: Data Protection and Data Security Level 2 * Course 28: Office Skills and Administration Management Diploma * Course 29: Touch Typing Essentials * Course 30: Document Control Learning Outcomes Upon completion of the course, you will be able to, * Discover the MS Word tools. * Learn how to make PowerPoint presentations. * Gain a thorough understanding of Microsoft Office Excel. * Discover how to use Excel for data analysis. * Explore the PowerBI formulae. * Learn more about Microsoft Access. * Project's fundamentals. * Increase your understanding of office and administrative management. And much more... This comprehensively designed course includes different tools such as word, excel, PowerPoint, outlook, access etc. As a consequence, the knowledge you acquire from it will make you a better worker and colleague. You will master techniques for utilising Microsoft Office products in this course beyond just using the basic functions. It will boost your working efficiency. The high output will eventually result in career success over the long run. So enrol right away to avoid missing out! CPD 315 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone from any background can enrol in this bundle including- * Students * Graduates * Job Seekers * Job Holders REQUIREMENTS None. CAREER PATH The Microsoft Office Specialist (MOS) will help you develop a certain demanding skill and will be beneficial to the following careers, * Office Administrator * Office Manager * Supervisor * Executive Assistant * Personal Assistant The average annual income for these occupations in the United Kingdom is between £22,000 and £28,000.

The job market in the UK has been through a significant amount of turbulence over the last year, mainly due to the pandemic and recent war. As a result, finding a suitable niche in this highly competitive job market has become more challenging. So to cover up all your limitations and uproot all the hurdles to a stable and dignified career, we are here with a package you can't refuse! This time Apex Learning will show you the pathway to a successful career through the most well-researched and expertly made Microsoft Office bundle. Our Microsoft Office package, with the latest digital study materials and innovative learning method, will give you in-depth knowledge of this domain. You will dive deep into the core basics with our step-by-step lessons and proficient tutor guidance. You will be able to hone your knowledge from beginner to advanced level as there will be frequent tests, fun quizzes and practical analysis of the topics. Moreover, you will keep yourself up to date with the current situation in the area of your interest. As Microsoft Office, there are endless opportunities for you if you have the right knowledge and skill. Therefore, to make your career journey a successful one, we designed this bundle as a one-stop solution for you. This 20-in 1 Ultimate Microsoft Office bundle consists of the following Courses: * Course 01: MS Word Diploma * Course 02: Proofreading & Copyediting * Course 03: PowerPoint Diploma * Course 04: Microsoft Excel Level 3 * Course 05: New Functions in Microsoft Excel 2021 * Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query * Course 07: Microsoft Excel: Excel Sheet Comparison with VBA * Course 08: Microsoft Excel: Master Power Query in 120 Minutes! * Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! * Course 10: Excel Pivot Tables * Course 11: Data Analysis in Microsoft Excel Complete Training * Course 12: Excel Must know Formulas and Functions * Course 13: Excel spreadsheet for Beginner * Course 14: Excel Data Analysis * Course 15: Excel Vlookup, Xlookup, Match and Index * Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines * Course 17: PowerBI Formulas * Course 18: Outlook Tips and tricks * Course 19: Excel PowerQuery and PowerPivot * Course 20: Complete Microsoft Power BI 2021 Additionally, you will get 5 other career-guided courses in this Microsoft Office bundle: * Course 01: Career Development Plan Fundamentals * Course 02: CV Writing and Job Searching * Course 03: Interview Skills: Ace the Interview * Course 04: Video Job Interview for Job Seekers * Course 05: Create a Professional LinkedIn Profile So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Microsoft Office bundle. Learning Outcomes of Microsoft Office bundle This career-oriented bundle will help you to * Gain the ability to excel in the role of Microsoft Office * Know your responsibilities as Microsoft Office and convey your experience to others * Gain excellent interpersonal and communication skills * Know the pros and cons of working as Microsoft Office * Adhere to the regulations around this area * Gain time and risk management skills to ensure efficiency * Manipulate technological advancement to become more effective * Maintain moral standards and set an example for your peers CPD 250 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone from any background can enrol in this Microsoft Office bundle. REQUIREMENTS This Microsoft Office course has been designed to be fully compatible with tablets and smartphones. CAREER PATH Having this 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 (MS Word 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.

THE MICROSOFT OFFICE DIPLOMA COURSE Includes the following courses: * Microsoft Excel for Beginners Certificate * Microsoft Excel Advanced Certificate * Microsoft Excel Intermediate Certificate * Microsoft Outlook Certificate * Microsoft PowerPoint Certificate * Microsoft Word Certificate Please Note: This course uses the Microsoft 365 version of Office. Any other versions will have some differences in the functions. This comprehensive and all-encompassing course on the most popular and widely used Microsoft Office programs aims to provide you with thorough and detailed knowledge in all areas of Microsoft Office. In fact, this bumper course combines the content of six individual courses, making it the ideal package for those of you who want to solidify your learning on Microsoft Office, for either professional or personal reasons. Those who work in an office environment or who are re-entering the workplace after a break will really benefit from the structured learning that this course offers, allowing you to hit the ground running at work. However, the course is equally useful for those using Microsoft Office in a personal capacity, as many tasks that you need to do on your home PC will likely involve working on these programs. Each of the courses which make up this bumper course has been tailor-made to incorporate the key information and skills that you need in order to improve your proficiency in each area of Microsoft.  The courses are run with training videos, allowing you to work in an interactive way, and at your own pace. Let's take a more detailed look at what each course offers you: WHAT YOU WILL LEARN The combined course covers the following courses in full: * Microsoft Excel for Beginners Certificate * Microsoft Excel Intermediate Certificate * Microsoft Excel Advanced Certificate * Microsoft Word Certificate * Microsoft PowerPoint Diploma * Microsoft Outlook Diploma. MICROSOFT EXCEL FOR BEGINNERS CERTIFICATE COURSE The first of our Microsoft Excel courses is perfect for those individuals who are new to this program or who need to brush up their basic skills with more practice. Completion of this course also offers the ideal foundation before moving on to the more advanced units. It offers simple and clear definitions of some of the key terminology within Excel, such as cells, rows and columns and how to input, edit and delete data. There is also an introductory section on how to create and work with basic formulas and pivot tables, which will be covered in more detail in the Intermediate and Advanced units. The course also covers how to work with worksheets and tabs in Excel, such as renaming, deleting, hiding, moving and copying. MICROSOFT EXCEL INTERMEDIATE CERTIFICATE COURSE This unit builds upon the progress that you have made in the Beginners unit to look at more complex functions within Excel such as averages, medians, modes and roundings and the best methods to manipulate such functions to help you to get the information that you want out of the program. In addition, formatting methods within Excel are covered, including changing texts and backgrounds, adding special characters and using AutoFill options. MICROSOFT EXCEL ADVANCED CERTIFICATE COURSE This unit is the most comprehensive and detailed of the three and aims to prepare you for jobs or situations where you require a thorough and proficient level of Excel. This unit really gets into the detail of the analytical functions of Excel, including more complex formulas such as MATCH, INDEX and VLOOKUP and, crucially, how to decide upon the most appropriate formula for a particular calculation. After completing this unit, you should feel confident to use and manipulate the largest range of Excel formulas and be able to use Excel to its full functionality. MICROSOFT WORD CERTIFICATE COURSE The ability to use Microsoft Word effectively is a crucial requirement of many office based roles. This course on Microsoft Word is an all-encompassing source of information which offers you the opportunity to enhance your skills in this widely-used program. You will learn a wide range of skills here, from the basics of entering text into a Word document, to how to use some of the editing and formatting tools available, including using the toolbars and various design features such as headers and hyperlinks, and many other aspects. MICROSOFT POWERPOINT DIPLOMA COURSE PowerPoint is a very useful program for those who are responsible for creating and delivering presentations in the workplace. By completing this course, you are taking a big step towards ensuring that your slideshows are professional and polished. The course starts from the beginning, assuming no prior knowledge of the area, and covers the creation of a PowerPoint presentation and the addition and editing of slides within it. You will also learn how to insert and format text, tables, images and graphics into your slides and how to effectively use SmartArt to give your presentations an extra special edge. You will learn effective methods to use linking and annotation features, as well as how to insert notes, comments and handout tools for your presentation. MICROSOFT OUTLOOK DIPLOMA COURSE Microsoft Outlook is very widely used as an email and organisation program in both professional and personal contexts and a solid familiarisation with its functionality will help you to really get the best out of using it. Our course will help you to get to grips with composing and responding to emails, including adding attachments and automatic signatures and creating out of office messages. It will help you to set up lists of contacts and create advanced rules to help Outlook work seamlessly for you. You will also learn all about the calendar functionalities, including how to set up meetings, navigating calendars and assigning tasks to others. THE BENEFITS OF OUR MICROSOFT OFFICE COURSE Studying with us to achieve success in our Microsoft Office combined course can offer you many benefits; not least the confidence and ability to professionally and effectively work with some of the most frequently used administration and workplace systems in the world. Here are some of the other benefits that you can enjoy by undertaking this course: * The course is intuitive and easy to follow, allowing you to work at your own pace and revisit key concepts or areas of difficulty as you need * You can study at home, in your free time and on any compatible electronic device, making access simpler than ever * The courses come complete with video training, helping you to solidify your learning * We offer full online support from our specialists as you progress through the course * There are no entry requirements - simply a willingness to learn * You will receive an industry recognised certification upon successful completion of the course.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment, you will gain access to Level 2 Microsoft Office Essentials including an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included with this Level 2 Microsoft Office Essentials: * Course 01: Level 2 Microsoft Office Essentials * Course 02: Data Analysis in Excel Level 3 Course * Course 03: Personal Assistant & Skill Development Training * Course 04: Legal Secretaries Advanced Diploma * Course 05: Financial Modeling Using Excel * Course 06: Data Protection and Data Security Level 2 * Course 07: Team Management * Course 08: Microsoft Teams * Course 09: Negotiation Essential Skills - Level 3 * Course 10: Minute Taking Essentials Level 2 * Course 11: Time Management - 2 CPD Points Become a valuable and skilled member of any organisation's administration team by learning to master the most popular Microsoft Office tools. This course provides full and comprehensive tutorials for each one of Microsoft's essential products and will boost your capabilities with them all. The course provides up-to-date training for Excel, PowerPoint, and Word. You will be given expert tuition and interactive exercises in the online modules, enabling you to attain the abilities to boost your administrative career prospects for employers. On completion of the final assessment, you will be able to present, write, or calculate efficiently for any critical assignment. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. This bundle will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. This bundle has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Level 2 Microsoft Office Essentials is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Level 2 Microsoft Office Essentials: * One payment, but lifetime access to 11 CPD courses * Certificates, student ID for the title course included in a one-time fee * Full tutor support available from Monday to Friday * Free up your time - don't waste time and money travelling for classes * Accessible, informative modules taught by expert instructors * Learn at your ease - anytime, from anywhere * Study the course from your computer, tablet or mobile device * CPD accredited course - improve the chance of gaining professional skills * Gain valuable knowledge without leaving your home Course Curriculum Level 2 Microsoft Office Essentials **Excel 2016** Getting Started with Microsoft Office Excel 2016 * Navigate the Excel User Interface * Use Excel Commands * Create and Save a Basic Workbook * Enter Cell Data * Use Excel Help Performing Calculations * Create Worksheet Formulas * Insert Functions * Reuse Formulas and Functions Modifying a Worksheet * Insert, Delete, and Adjust Cells, Columns, and Rows * Search for and Replace Data * Use Proofing and Research Tools Formatting a Worksheet * Apply Text Formats * Apply Number Format * Align Cell Contents * Apply Styles and Themes * Apply Basic Conditional Formatting * Create and Use Templates Printing Workbooks * Preview and Print a Workbook * Set Up the Page Layout * Configure Headers and Footers Managing Workbooks * Manage Worksheets * Manage Workbook and Worksheet Views * Manage Workbook Properties **Word 2016** * Getting Started with Word * Create and Save Word Documents * Manage Your Workspace * Edit Documents * Preview and Print Documents * Customize the Word Environment And Much More... Formatting Text and Paragraphs * Apply Character Formatting * Control Paragraph Layout * Align Text Using Tabs * Display Text in Bulleted or Numbered Lists * Apply Borders and Shading Working More Efficiently * Make Repetitive Edits * Apply Repetitive Formatting * Use Styles to Streamline Repetitive Formatting Tasks Managing Lists * Sort a List * Format a List Adding Tables * Insert a Table * Modify a Table * Format a Table * Convert Text to a Table Inserting Graphic Objects * Insert Symbols and Special Characters * Add Images to a Document Controlling Page Appearance * Apply a Page Border and Color * Add Headers and Footers * Control Page Layout * Add a Watermark Preparing to Publish a Document * Check Spelling Grammar and Readability * Use Research Tools * Check Accessibility * Save a Document to Other Formats Workbooks - Microsoft Word 2016 (Beginner) * Workbooks - Microsoft Word 2016 (Beginner) **PowerPoint 2016** PowerPoint Interface * Navigate the PowerPoint Environment * View and Navigate a Presentation * Create and Save a PowerPoint Presentation * Use PowerPoint Help Presentation Basics * Select a Presentation Type * Edit Text * Build a Presentation Formatting * Format Characters * Format Paragraphs * Format Text Boxes Inserting Options * Insert Images * Insert Shapes Working with Objects * Edit Objects * Format Objects * Group Objects * Arrange Objects * Animate Objects Table * Create a Table * Create a Table And Much More... Charts * Create a Chart * Format a Chart And Much More... Review and Presentatin * Review Your Presentation * Apply Transitions * Print Your Presentation * Deliver Your Presentation **Access 2016** Introduction to Access * Create a Simple Access Database And Much More... Modify Data * Modify Table Data * Sort and Filter Records Working with Queries * Create Basic Queries * Sort and Filter Data in a Query * Perform Calculations in a Query Access Forms * Create Basic Access Forms * Work with Data on Access Forms Working with Reports * Create a Report * Add Controls to a Report * Enhance the Appearance of a Report * Prepare a Report for Print * Organize Report Information * Format Reports 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 £10 * 11 = £110) * Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 125 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? There is no experience or previous qualifications required for enrolment on this bundle. It is available to all students, of all academic backgrounds. REQUIREMENTS Our bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. CAREER PATH Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included