• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1300 Microsoft Office courses delivered Online

MS Access 2016 Introduction

4.3(43)

By John Academy

Description As a beginner, do you want to learn about MS Access? Are you interested to know its various function and use? Do you want to be an expert in this field? If so, take a look at our MS Access 2016 Introduction course. It will assist you in understanding all you need to learn about this course. The course designs for the fresher who have a little or no basic knowledge of MS Access. It teaches you how to create, open, and save an Access database. It will acquaint you with the basic equipment such as ribbons and toolbar so that you can get access it flexibly to create a table, and store date smoothly. It introduces you to numeric and index field with a plenty of practical exercises so that you can learn the basic of MS Access 2016 effectively. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Access 2016 Introduction is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Access 2016 Introduction is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Getting Started What is a Database? 00:03:00 Understanding Database terminology 00:05:00 Navigating the Access Interface 00:06:00 What is a flat file database 00:04:00 What is a relational database 00:09:00 Relating Tables 00:06:00 Reviewing the Access Ribbon 00:04:00 Working with Data Working with Tables 00:04:00 Navigating Tables 00:02:00 Editing Data 00:03:00 Adding New Records 00:02:00 Using Subdatasheets 00:04:00 Creating Databases and Objects Understanding Database and Table Design Principles 00:10:00 Using Table Data Sheet View 00:04:00 Working with Field Data Types 00:04:00 Using Table Design View 00:04:00 Using Calculated Fields 00:04:00 Calculating Numbers 00:03:00 Calculating Dates 00:01:00 Calculating Strings 00:02:00 Using the Lookup Wizard 00:05:00 Editing Lookups 00:04:00 Using Indexes 00:02:00 Working with Queries What are Queries 00:03:00 Creating Simple Queries 00:05:00 Understanding the Dynaset 00:02:00 Entering Criteria: Exact Match and Range Operators 00:04:00 Understanding AND versus OR 00:03:00 Using Wild Cards 00:02:00 Using Keywords 00:03:00 Sorting and Hiding Fields 00:02:00 Creating Multi-Table Queries 00:03:00 Additional Tips 00:03:00 Working with Reports What are Reports 00:03:00 Understanding Report Types 00:03:00 Building Effective Reports 00:02:00 Using AutoReport 00:04:00 Understanding the Report Wizard 00:04:00 Using the Report Design View 00:08:00 Creating Labels 00:02:00 Working with Forms What are Forms 00:04:00 Understanding Form Types 00:02:00 Creating Forms 00:02:00 Navigating Forms 00:02:00 Editing Data in Forms 00:03:00 Understanding the Form Wizard 00:03:00 Using the Form Design View 00:04:00 Working with Controls 00:03:00 Using Form Layout View 00:02:00 Additional Tips 00:03:00 Conclusion Course Recap 00:01:00 Resources Resources - MS Access 2016 Introduction 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

MS Access 2016 Introduction
Delivered Online On Demand3 hours 1 minutes
£18

MS Access 2016 Advanced

4.3(43)

By John Academy

Description Access 2016 is a software development and graphical user interface tool that assist you to collect, report, and analyze information for the reference. To become better at MS Access take a look at our well designed MS Access 2016 Advanced course. It will help you in understanding all you need to know about the MS Access. The course aims at the students' efficiency to improve their skill in the functions of an Access database. It teaches the learners how to form joint table and use table analyzer wizard effectively. The course incorporates the fundamental issues of MS Access such as automation process with the help of VBA, creation, and modification of switchboards, and function of table events. It enables the students to configure security and access for different environments providing knowledge with the multiple uses of tools and backup system. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Access 2016 Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Access 2016 Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Improving the Structure of a Database Using the Table Analyzer Wizard 00:05:00 Append Querying to Normalize a Table 00:08:00 Creating a Junction Table 00:06:00 Maintaining a Database Backing Up a Database 00:02:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:02:00 Using the Database Documenter Too 00:02:00 Using the Performance Analyzer Tool 00:02:00 Working with Access Switchboards Understanding the Access Switchboard 00:03:00 Using The Switchboard Manager 00:09:00 Modifying a Switchboard 00:05:00 Setting the Startup Options 00:04:00 Configuring Access for Multiple Users Using the database Splitter 00:04:00 Configuring Trusted Locations 00:02:00 Password Protecting a Database 00:03:00 Password Protecting Modules 00:01:00 Converting a Database to an ACCDE file 00:01:00 Automating Processes with VBA Understanding VBA Basics 00:06:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:06:00 Converting a Macro to VBA 00:02:00 Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:04:00 Using the After Change Event Command 00:04:00 Conclusion Course Recap 00:04:00 Resources Resources - MS Access 2016 Advanced 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

MS Access 2016 Advanced
Delivered Online On Demand1 hour 41 minutes
£18

Microsoft Access 2016 for Beginners

4.3(43)

By John Academy

Description: This Microsoft Access 2016 for Beginners will provide you the knowledge of how to Access is constructed and how to use the major objects within it. It allows you to create and manage database for all sorts of different purposes. It will help all novice computer users get up to speed quickly. It will also help more experienced users who have little to no experience with Microsoft Access and databases general. If you have the general knowledge of working with windows and want to improve your knowledge more you are welcome to join this course. Learning Outcomes: Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records, and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format 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 Access 2016 for Beginners 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 Access 2016 for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Access Orientation to Microsoft Access 01:00:00 Create a Simple Access Database 01:00:00 Get Help in Microsoft Access 00:30:00 Working with Table Data Modify Table Data 00:30:00 Work with Records 01:00:00 Sort and Filter Records 00:30:00 Create Lookups 01:00:00 Querying a Database Join Data from Different Tables in a Query 01:00:00 Sort and Filter Data in a Query 01:00:00 Perform Calculations in a Query 00:30:00 Creating Advanced Queries Create Parameter Queries 00:30:00 Create Action Queries 00:30:00 Create Find Duplicate and Find Unmatched Queries 00:30:00 Summarize Data 00:30:00 Generating Reports Create a Report 01:00:00 Add Controls to a Report 00:30:00 Enhance the Appearance of a Report 00:30:00 Prepare a Report for Print 00:30:00 Customizing the Access Environment The Access Options Dialog Box 01:00:00 Designing a Relational Database Relational Database Design 00:30:00 Create a Table 01:00:00 Modify a Table and Fields 00:30:00 Create Table Relationships 00:30:00 Joining Tables Create Query Joins 00:30:00 Join Tables That Have No Common Fields 00:30:00 Relate Data within a Table 00:30:00 Work with Subdatasheets 00:30:00 Create Subqueries 00:30:00 Organizing a Database for Efficiency Data Normalization 01:00:00 Create a Junction Table 00:30:00 Sharing Data Across Applications Import Data into Access 00:30:00 Export Data to Text File Formats 00:30:00 Export Access Data to Excel 00:30:00 Create a Mail Merge 00:30:00 Advanced Reporting Organize Report Information 00:30:00 Format Reports 00:30:00 Include Charts in a Report 00:30:00 Add a Calculated Field to a Report 00:30:00 Add a Subreport to an Existing Report 00:30:00 Additional Reporting Options Create a Mailing Label Report 00:30:00 Publish a Report as PDF 00:30:00 Activities Activities - Microsoft Access 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Access 2016 for Beginners 00:20:00 Final Exam Final Exam- Microsoft Access 2016 for Beginners 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Access 2016 for Beginners
Delivered Online On Demand26 hours
£18

Microsoft Excel 2010 Intermediate Level

By iStudy UK

You will hardly find a company or business who doesn't use Microsoft Excel. It is one of the most popular spreadsheet tools that is used to store, organize and analyse data. You can also manipulate the data to create useful visuals to understand trends and calculations. Having a professional Microsoft Excel degree can become an asset for you. Whether you are planning to start your career or want a promotion, our Microsoft Excel 2010 Intermediate Level will help you greatly. Please note that this course is for intermediate level. If you haven't completed the beginners course, then it will be a bit difficult for you to cope up with the intermediate features. But, if you are a quick learner and can adapt with changes, then you can enrol to this course without any doubt and master Microsoft Excel easily. It will help you to stand out in the crowd with your advanced MS Excel skills to that you can stay ahead in the workplace. Course Highlights Microsoft Excel 2010 Intermediate Level 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 Microsoft Excel 2010 Intermediate Level into 13 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 10 hours, 40 minutes 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 Excel 2010 Intermediate Level 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? Microsoft Excel 2010 Intermediate Level 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 Microsoft Excel 2010 Intermediate Level 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 Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Intermediate level 00:20:00

Microsoft Excel 2010 Intermediate Level
Delivered Online On Demand10 hours 40 minutes
£25

Microsoft Excel - Advanced Level

4.3(43)

By John Academy

Description: The Microsoft Excel program was designed to help people in their worksheets and spreadsheets. This course will teach you how to use SmartArt, pictures, text boxes and shapes to enhance your ability. You will learn to utilize many objects which have contextual tool tabs that appear when you select an object. Learn how to solve formula errors before they happen by using named ranges instead of cell references. Who is the course for? Professionals who want to learn about the Microsoft Excel 2013 advanced features. People who have an interest in knowing all the functions of Microsoft Excel 2013. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel Advanced course is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. 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 Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel - Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel - Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel - Advanced Level
Delivered Online On Demand13 hours 40 minutes
£21

Microsoft Excel 2007 for Beginners

4.3(43)

By John Academy

Description: This course was created to help anyone learn about Microsoft Excel 2007 for beginners. Through this course, you will learn the importance of planning and organise your thoughts when creating a worksheet. This will help you maximise the capability of the Excel program. You will learn the basic functions and formula that are commonly used in Microsoft Excel. You will also know the importance of saving, editing and creating new worksheets in an effective manner. This course will help you practice what you've learned and learn how to apply what you've learned in your career. Who is the course for? Professionals who want to learn about Microsoft Excel 2007 features People who have an interest in knowing all the essentials in Microsoft Excel 2007 Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel 2007 for Beginners is a useful qualification to possess and would be beneficial for any for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2007 for Beginners 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2007 for Beginners
Delivered Online On Demand11 hours 30 minutes
£21

Microsoft 365

By Compete High

Course Overview: Microsoft 365 Mastery Welcome to Microsoft 365 Mastery, a comprehensive course designed to empower individuals with the skills and knowledge needed to leverage the full potential of Microsoft 365 and its suite of applications. In this course, you will explore the diverse functionalities of Microsoft 365, covering its key components and applications through a structured series of modules. Module 1: Overview of Microsoft 365 and Its Applications Gain a comprehensive understanding of Microsoft 365, including its core components and applications. Explore how Microsoft 365 enhances productivity and collaboration in modern workplaces. Module 2: OneDrive and SharePoint Online Delve into OneDrive and SharePoint Online, powerful cloud-based storage and collaboration platforms. Learn how to efficiently manage files, collaborate on documents, and organize content using these tools. Module 3: Microsoft Teams and Outlook Discover the collaborative power of Microsoft Teams and the productivity features of Outlook. Explore how Teams facilitates seamless communication and collaboration, while Outlook helps manage emails, calendars, and tasks effectively. Module 4: Microsoft Planner and Forms Master Microsoft Planner for task management and project coordination, and learn to create surveys and quizzes using Microsoft Forms. Explore how these tools streamline workflow and gather valuable insights. Module 5: Power Automate and 365 Security Features Unlock the potential of automation with Power Automate, and explore essential security features within Microsoft 365. Learn to automate repetitive tasks and safeguard sensitive data effectively. Module 6: Admin Center and Accessibility Navigate the Microsoft 365 Admin Center and understand its role in managing user accounts, licenses, and security settings. Learn about accessibility features to ensure inclusivity and compliance within your organization. Module 7: Collaborative Editing and Integration with Other Tools Explore collaborative editing features across Microsoft 365 applications and discover how they enhance teamwork and productivity. Learn about integration possibilities with third-party tools to extend the capabilities of Microsoft 365. Module 8: Best Practices and Migration Strategies Acquire best practices for deploying and managing Microsoft 365 within your organization. Understand migration strategies to seamlessly transition from legacy systems to Microsoft 365 while minimizing disruptions.   Throughout the course, you will engage in hands-on exercises, case studies, and practical demonstrations to reinforce your learning and develop valuable skills applicable to real-world scenarios. By the end of this course, you will emerge as a proficient Microsoft 365 user equipped to drive productivity, collaboration, and innovation within your organization. Join us on this journey to Microsoft 365 mastery! Course Curriculum Module 1_ Overview of Microsoft 365 and Its Applications Overview of Microsoft 365 and Its Applications 00:00 Module 2_ OneDrive and SharePoint Online OneDrive and SharePoint Online 00:00 Module 3_ Microsoft Teams and Outlook Microsoft Teams and Outlook 00:00 Module 4_ Microsoft Planner and Forms Microsoft Planner and Forms 00:00 Module 5_ Power Automate and 365 Security Features Power Automate and 365 Security Features 00:00 Module 6_ Admin Center and Accessibility Admin Center and Accessibility 00:00 Module 7_ Collaborative Editing and Integration with Other Tools Collaborative Editing and Integration with Other Tools 00:00 Module 8_ Best Practices and Migration Strategies Best Practices and Migration Strategies 00:00

Microsoft 365
Delivered Online On Demand8 hours
£25

Level 3 Diploma in Microsoft Word 2016

4.3(43)

By John Academy

Description: Microsoft Word is a windows based application which lets you create and edit different types of documents that you can type. It is one of the most fundamental types of software that anyone learns for using a computer. Level 3 Diploma in Microsoft Word 2016 is a complete course on all the aspects of this program. In this course, you will learn about MS word interface, how to create and edit a document, backups, etc. As you move up the hierarchy of modules, you will know about different formatting tools available in MS Word. These tools will allow you to add styles, borders, tables, graphics objects, and other customization. In the end, these skillsets will be very helpful. Learning Outcomes: Word 2016 user interface, creating basic documents and utilizing help Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists Understanding the commands on the home tab and mini toolbar Paragraph layout tool, borders, shading, styles and formatting management techniques Maximizing your ability to utilize tables within Word 2016 Inserting symbols and special characters along with techniques for adding them Managing your page's appearance with colours, borders, watermarks, headers, footers and page setup dialogue box Reviewing documents through spell check, research pane and thesaurus Document accessibility options Customizing the user interface, modifying save options and managing other file types Sorting data, controlling cell layout, performing calculations, and creating and modifying charts for tables Creating and modifying text, list and table styles along with applying and customizing document themes Modifying images, integrating them with texts, adding screenshots and videos to documents Discussion on text boxes, shapes, WordArt and SmartArt Inserting building blocks, specially Quick Parts and fields Controlling text flow through setting paragraph options, using section breaks, formatting text as columns, and linking text boxes Utilizing templates to the best of your abilities Ways to merge mail along with creating data source and merging envelopes and labels Best ways to use Macros in order to automate tasks Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions 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? Level 3 Diploma in Microsoft Word 2016 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 Level 3 Diploma in Microsoft Word 2016 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. Module : 1 Identify the Components of the Word Interface 00:30:00 Create a Word Document 00:30:00 Help 00:30:00 Navigate and Select Text 00:30:00 Modify Text 00:30:00 Find and Replace Text 00:30:00 Apply Character Formatting 00:30:00 Align Text Using Tabs 00:30:00 Display Text as List Items 00:30:00 Control Paragraph Layout 00:30:00 Apply Borders and Shading 00:30:00 Apply Styles 00:30:00 Manage Formatting 00:30:00 Insert a Table 00:30:00 Modify a Table 00:30:00 Format a Table 00:30:00 Convert Text to a Table 00:30:00 Sort a List 00:30:00 Renumber a List 00:30:00 Customize a List 00:30:00 Insert Symbols and Special Characters 00:30:00 Add Images to a Document 00:30:00 Apply a Page Border and Color 00:30:00 Add a Watermark 00:30:00 Add Headers and Footers 00:30:00 Control Page Layout 00:30:00 Check Spelling and Grammar 00:30:00 Other Proofing Tools 00:30:00 Check Accessibility 00:30:00 Customize the Word Interface 00:30:00 Additional Save Options 00:30:00 Manage Additional File Types 00:30:00 Module : 2 Sort Table Data 00:30:00 Control Cell Layout 00:30:00 Perform Calculations in a Table 00:30:00 Create a Chart 00:30:00 Create and Modify Text Styles 00:30:00 Create Custom List or Table Styles 00:30:00 Apply and Customize Document Themes 00:30:00 Resize an Image 00:30:00 Adjust Image Appearance 00:30:00 Integrate Pictures and Text 00:30:00 Insert and Format Screenshots 00:30:00 Insert Video 00:30:00 Create Text Boxes and Pull Quotes 00:30:00 Draw Shapes 00:30:00 Add WordArt and Other Text Effects 00:30:00 Create Complex Illustrations with SmartArt 00:30:00 Insert Building Blocks 00:30:00 Insert Fields Using Quick Parts 00:30:00 Control Paragraph Flow 00:30:00 Insert Section Breaks 00:30:00 Insert Columns 00:30:00 Link Text Boxes to Control Text Flow 00:30:00 Create a Document Using a Template 00:30:00 The Mail Merge Features 00:30:00 Merge Envelopes and Labels 00:30:00 Create a Data Source Using Word 00:30:00 Automate Tasks Using Macros 00:30:00 Create a Macro 00:30:00 Module : 3 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 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 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Word 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Word 2016 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Microsoft Word 2016
Delivered Online On Demand40 hours
£19

Office Admin and Customer Service Diploma

4.7(160)

By Janets

The Office Admin and Customer Service Diploma is designed to prepare you for an exciting career in office administration by increasing your skill level in computer applications, public speaking, interpersonal relations, and information management. In addition to skill development, employment preparation is also covered, including resume and cover letter writing, mock interviews, and job shadowing. You will also be able to learn the structures and objectives involved in conducting of admin assistant and customer service. 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. Who is this course for? Office Admin and Customer Service Diploma is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject. Career path Training offered by the Office Admin and Customer Service Diploma could potentially benefit a range of roles, but would particularly enhance careers in Office Administration Sales Customer Service Receptionist and Secretarial Work Business Management Marketing Other professional admin roles

Office Admin and Customer Service Diploma
Delivered Online On Demand4 days
£9.99

Office Management and Administration - CPD Certified

5.0(3)

By School Of Health Care

Office Management: Office Management Course Online The Office Management: Office Management Course is ideal for those who want to work as office managers or programme managers. The Office Management: Office Management Course will place a strong emphasis on project management, business administration, and information and knowledge management methods. This Office Management: Office Management Course is for both aspiring beginners and experienced professionals who want to gain a detailed understanding of important business management topics. Pursue your goals by enrolling in our Office Management: Office Management Course now and gain the knowledge, skills, and information you need to advance your career. This Office Management: Office Management Course will help you empower yourself with the skills you need to get your ideal job. Why choose this Office Management: Office Management Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Office Management: Office Management Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Office Management: Office Management Course. [ Note: Free PDF certificate will provide as soon as completing the Office Management : Office Management Online Course] Office Management: Office Management Course Online Course Curriculum of Office Management: Office Management Course Module 01: Fundamentals of Office Administration Module 02: Qualities of an Effective Administrator Module 03: Information regarding shipping and mail services Module 04: Ways to create effective plans and schedule. Module 05: Outline setting up conferences and meetings. Module 06: Business Writing Techniques Module 07: Management of time Module 08: An Overview of Stress Management Module 09: Telephone Business Proficiency Module 10: Communication Techniques Module 11: Strategies to manage conflicts. Module 12: Business etiquette guidelines Module 13: Basics of Microsoft Office Skills Certification of Office Management: Office Management Course After completing the Office Management: Office Management Online course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Assessment Method of Office Management: Office Management Course After completing Office Management: Office Management Online Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Office Management: Office Management Course Online Learners can take this Office Management: Office Management Course without any prior knowledge of this topic, and there are no age restrictions. As a result, anyone interested in Office Management and Administration can enrol in the course. Requirements Office Management: Office Management Course Online To enrol in this Office Management: Office Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Office Management: Office Management Course. Be energetic and self-motivated to complete our Office Management: Office Management Course. Basic computer Skill is required to complete our Office Management: Office Management Course. If you want to enrol in our Office Management: Office Management Course, you must be at least 15 years old. Career path Office Management: Office Management Course Online After completing the Office Management : Office Management course/training, you will be able to confidently grasp specific knowledge and skills in order to improve yourself and enhance your skills for a career in the relevant employment sector.

Office Management and Administration - CPD Certified
Delivered Online On Demand8 hours
£12