1299 Microsoft Office courses delivered Online

Description: If you already have the basic skills and knowledge of Microsoft Word 2010 and you are able to create, edit, and print word documents on Windows then this [course_tite] is designed for you. This series builds on the skills and concepts taught in Word 2010 Basic. You will learn advanced formatting, use Word's drawing tools, create and manage tables, and work with column layouts. Here, you will work with styles, sections, and columns and will use the Navigation pane to work with outlines. By this course, you will learn to use Word's advanced editing tools, work with images, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation an layout, how to work with columns and with page and section breaks, and more. This intermediate level will pull up your basic knowledge and skills so don't delay to try this. 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 2010 Word Intermediate - 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 2010 Word Intermediate - 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. Styles and Outlines Examining Formatting FREE 00:07:00 Creating Styles 00:17:00 Modifying Styles 00:11:00 Working with Outlines 00:13:00 Sections and Columns Creating and Formatting Sections 00:13:00 Working with Columns 00:08:00 Formatting Tables Table Formatting Basics 00:09:00 Borders and Shading 00:06:00 Table Data 00:10:00 Table Styles 00:09:00 Printing Labels and Envelopes Labels 00:06:00 Envelopes 00:05:00 Templates and Building Blocks Template Basics 00:11:00 Building Blocks 00:02:00 Document Properties 00:14:00 Graphics Creating Diagrams 00:02:00 Using the Drawing Tools 00:13:00 Formatting Text Graphically 00:06:00 Managing Document Revisions Tracking Changes 00:21:00 Working with Comments 00:02:00 Web Features Web Pages 00:03:00 Hyperlinks 00:10:00 Mock Exam Mock Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2010 Outlook Intermediate - Complete Video Course is intended for novice information workers who want to learn the intermediate level Outlook 2010 skills. This series will provide you with more advanced skills for managing e-mail, schedules, and contacts. This series builds on the skills and concepts taught in Outlook 2010 Basic. You will be learning how to customize Outlook and work with address books, how to search and filter mail folders, and apply and customize categories. Finally you will be able to work with conversation view, arrange message in different ways, quickly locate message, print message, configure time zone, work with multiple calendars, print a calendar, create contact group, create and format business graphics, import and export contact records, personal, public, offline folders, set rules, and more. Before you taking this course you should have a firm grasp of the basics. This intermediate level will pull up your basic knowledge. 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 2010 Outlook Intermediate - 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 2010 Outlook Intermediate - 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. Customizing Outlook The Outlook Environment FREE 00:16:00 General Options 00:07:00 Language and Keyboard Options 00:07:00 Quick Steps 00:06:00 The Navigation Pane 00:07:00 Working with Contacts Address Books 00:12:00 Contact Groups 00:08:00 Customizing Messages Message Appearance 00:17:00 Signatures 00:13:00 Voting Buttons 00:07:00 Out-of-Office Messages 00:14:00 Organizing Items Folders 00:03:00 Searching 00:11:00 Filters 00:06:00 Categories 00:20:00 Organizing Mail Organizing the Inbox Folder 00:26:00 Setting Rules 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Complete Course for Beginners is one of our best selling and most popular course. The Microsoft Office 2016 Complete Course for Beginners is organised into 5 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 78 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.

Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Intermediate - 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. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Nowadays almost every job in the business world involves office products. Whether you're an administrative assistant, office manager, sales professional or business manager, utilizing all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. The Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is designed to provide you all the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access. 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 Access Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Access - Beginner Orientation to Microsoft Access FREE 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Microsoft Access - Intermediate Relational Database Design FREE 00:16:00 Create a Table 00:09:00 Create Table Relationships 00:09:00 Create Query Joins 00:14:00 Relate Data Within a Table.avi 00:04:00 Work with Subdatasheets from 00:05:00 Use Field Validation 00:16:00 Use Form and Record Validation 00:14:00 Create Parameter Queries 00:12:00 Summarize Data 00:06:00 Create Subqueries 00:07:00 Create Action Queries 00:05:00 Create Unmatched and Duplicate Queries 00:06:00 Data Normalization 00:10:00 Create a Junction Table 00:04:00 Improve Table Structure 00:06:00 Include Control Formatting in a Report 00:04:00 Add a Calculated Field to a Report 00:05:00 Add a Subreport to an Existing Report 00:07:00 Microsoft Access - Advanced Add Controls to Forms FREE 00:11:00 Enhance Navigation and Organization of Forms 00:14:00 Apply Conditional Formatting 00:04:00 Import Data into Access 00:08:00 Export Access Data 00:06:00 Link Tables to External Data Sources 00:05:00 Create a Mail Merge 00:02:00 Create a Macro 00:08:00 Restrict Records by Using a Condition 00:04:00 Validate Data by Using a Macro 00:05:00 Automate Data Entry by Using a Macro 00:04:00 Manage a Database 00:08:00 Determine Object Dependency 00:04:00 Manage a Database 00:07:00 Determine Object Dependency 00:04:00 Document a Database 00:04:00 Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:03:00 Convert an Access Database to an ACCDE File 00:04:00 Package a Database with a Digital Signature 00:01:00 Create a Database Switchboard 00:05:00 Modify a Database Switchboard 00:02:00 Set Start up Options 00:04:00 Mock Exam Mock Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Master Microsoft Office 2021 with our comprehensive course. From Excel to PowerPoint and Word, learn essential tools and techniques for enhanced productivity and efficiency.

Description: This Microsoft Office 2010 Outlook Beginners - Complete Video Course is intended for novice information workers who want to learn beginning level Outlook 2010 skills. It will provide you with an overview of the features and functions of Microsoft Outlook 2010. Here, you will learn the basic functions and features of Outlook 2010. After an introduction to Outlook's windows components and the Help system, you will be able to read and end email messages using several techniques. Then you will learn how to manage email messages and attachments, configure message options, and use search folders, and how to manage contacts and use the People Pane, works with tasks, and create appointments. Finally you will learn to send and respond meeting requests. If you are interested to learn all the basics of Microsoft Outlook 2010, then you should join this immediately 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 2010 Outlook Beginners - 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 2010 Outlook Beginners - 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. Getting Started The Program Window FREE 00:12:00 Outlook Today 00:04:00 Getting Help 00:03:00 Email Reading Email Messages 00:05:00 Creating and Sending Email Messages 00:05:00 Working with Messages 00:10:00 Attachments 00:05:00 Email Management Message Options 00:15:00 Junk Email 00:06:00 Search Folders 00:04:00 Printing Messages 00:03:00 Contact Management Working with Contacts 00:12:00 Contact Groups 00:05:00 The People Pane 00:06:00 Tasks Working with Contacts 00:12:00 Managing Tasks 00:13:00 Appointments and Events Creating and Sending Appointments 00:09:00 Modifying Appointments 00:08:00 Events 00:05:00 Calendar Views 00:11:00 Meeting Requests and Responses Meetings 00:13:00 Managing Meetings 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Access Beginners - Complete Video Course will allow you to get started quickly with prebuilt applications that can modify or adapt to changing business needs. Collect information through form in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Sharing information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permission, and back up your information at regular intervals. This series will provide you an overview of the features and functions of Microsoft Office Access 2007. If you are interested to learn all the basics of Microsoft Access 2007, then you should join this course now. So, if you want to learn beginning level Access 2007 Skills. 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 2007 Access Beginners - 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 2007 Access Beginners - 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. Getting Started Database Concepts FREE 00:05:00 Indentifying Database Components 00:04:00 Exploring the Access Environment 00:03:00 Starting Access and Examining the Access Window 00:06:00 Opening a Database 00:04:00 Getting Help 00:01:00 Using Help 00:03:00 Databases and Tables Planning and Designing Databases 00:05:00 Creating a Database from a Template 00:01:00 Creating a Blank Database 00:01:00 Exploring Table 00:01:00 Navigating in a Table in Datasheet View 00:05:00 Examining a Table in Design View 00:04:00 Creating Tables 00:05:00 Creating a Table by Using the Table Templates 00:06:00 Creating a Table in Design View 00:02:00 Adding Fields and Descriptions to a Table 00:05:00 Setting the Primary Key 00:01:00 Saving the Table 00:01:00 dding a Record 00:02:00 Copying, Modifying, and Deleting a Table 00:03:00 Creating a Composite Key 00:03:00 Fields and Records Changing the Design of a Table 00:05:00 Modifying Field Names 00:01:00 Deleting and Inserting Fields 00:02:00 Moving a Field 00:01:00 Using the Attachment Data Type 00:04:00 Adding a Total Row 00:03:00 Finding and Editing Records 00:02:00 Finding and Replacing a Value 00:03:00 Undoing Changes 00:01:00 Organizing Records 00:04:00 Sorting Records by a Single Field 00:01:00 Sorting Records by Multiple Fields 00:02:00 Using Filter by Selection 00:02:00 Using Filter by Form 00:02:00 Using Filter Excluding Selection 00:01:00 Using Advanced FilterSort 00:02:00 Deleting a Record 00:02:00 Data Entry Rules Setting Field Properties 00:04:00 Setting the Required Property 00:04:00 Using the Allow Zero Length Property 00:03:00 Setting the Field Size Property 00:02:00 Setting the Append Only Property 00:03:00 Working with Input Masks 00:02:00 Creating an Input Mask 00:03:00 Working with the Input Mask Wizard 00:03:00 Setting Validation Rules 00:01:00 Creating Validation Rules 00:03:00 Setting Validation Text 00:02:00 Basic Queries Creating and Using Queries 00:05:00 Using the Query Wizard 00:04:00 Creating a Query in Design View 00:02:00 Saving and Running the Query 00:01:00 Sorting Query Results 00:01:00 Filtering a Query by Adding Criteria 00:01:00 Creating a Query from a Filter 00:03:00 Modifying Query Results and Queries 00:02:00 Editing Query Results 00:02:00 Adding Fields to a Query 00:01:00 Finding Records with Empty Fields 00:01:00 Performing Operations in Queries 00:04:00 Using Comparison Operators 00:01:00 Using the OR Condition 00:01:00 Using the AND Condition 00:01:00 Using the Wildcard 00:01:00 Using Calculations in a Query 00:03:00 Totaling a Group of Records 00:02:00 Using the Avg and Count Functions 00:01:00 Using Forms Creating Forms 00:05:00 Examining a Form 00:03:00 Creating a Basic Form 00:01:00 Creating a Form Using the Form Wizard 00:02:00 Using Design View 00:04:00 Creating a Form in Design View 00:01:00 Addings Controls 00:03:00 DModifying Properties 00:06:00 Applying Conditional Formatting 00:03:00 Sorting and Filtering Records 00:01:00 Using a Form to Sort Records 00:01:00 Using a Form to Filter Records 00:01:00 Working with Reports Reports 00:03:00 Examining a Report 00:01:00 Creating a Basic Report 00:01:00 Creating a Report Using the Report Wizard 00:02:00 Creating a Report Using Design View 00:04:00 Modifying and Printing Reports 00:05:00 Modifying Reports in Design View 00:03:00 Modifying Reports in Layout View 00:03:00 Grouping, Sorting, and Filtering a Report 00:02:00 Adding Summary Fields Using the Report Wizard 00:02:00 Modifying the Layout and Style of a Report 00:01:00 Mock Exam Mock Exam- Microsoft Office 2007 Access Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Access Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents. Overview In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents. You will: Organize content using tables and charts. Customize formats using styles and themes. Insert content using Quick Parts. Use templates to automate document formatting. Control the flow of a document. Simplify and manage long documents. Use mail merge to create letters, envelopes, and labels. After you master the basics of creating, editing, and printing Microsoft© Word documents, you're ready to move on to tackling the more advanced features. In this course, you will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers. Creating professional-looking documents can give you and your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings can help reduce expenses. Mastering these techniques will make you a valued employee in your organization. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications. Organizing Content Using Tables and Charts Topic A: Sort Table Data Topic B: Control Cell Layout Topic C: Perform Calculations in a Table Topic D: Create a Chart Topic E: Add an Excel Table to a Word Document (Optional) Customizing Formats Using Styles and Themes Topic A: Create and Modify Text Styles Topic B: Create Custom List or Table Styles Topic C: Apply Document Themes Inserting Content Using Quick Parts Topic A: Insert Building Blocks Topic B: Create and Modify Building Blocks Topic C: Insert Fields Using Quick Parts Using Templates to Automate Document Formatting Topic A: Create a Document Using a Template Topic B: Create and Modify a Template Topic C: Manage Templates with the Template Organizer Controlling the Flow of a Document Topic A: Control Paragraph Flow Topic B: Insert Section Breaks Topic C: Insert Columns Topic D: Link Text Boxes to Control Text Flow Simplifying and Managing Long Documents Topic A: Insert Blank and Cover Pages Topic B: Insert an Index Topic C: Insert a Table of Contents Topic D: Insert an Ancillary Table Topic E: Manage Outlines Topic F: Create a Master Document Using Mail Merge to Create Letters, Envelopes, and Labels Topic A: Use Mail Merge Topic B: Merge Envelopes and Labels Additional course details: Nexus Humans Microsoft Office Word 2021: Part 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Office Word 2021: Part 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.