1333 Courses

Microsoft Office 2016 Essentials is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Microsoft Office and looks at skills needed to improve in relevant industry or Microsoft Office. By taking this course you will gain the necessary skills to perform effectively in this field. The Microsoft Office 2016 Essentials is organised into 97 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 16 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 Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Course Content Excel 2016 Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports 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 Assignment Assignment - Microsoft Office 2016 Essentials 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description: This Microsoft Office 2007 Excel Intermediate - Complete Video Course will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. 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 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 2007 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. Using Multiple Worksheets and Workbooks Using Multiple Workbooks FREE 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:08:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 5 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Office Excel Understand the core competencies and principles of Microsoft Office Excel Explore the various areas of Microsoft Office Excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Office Excel 2016: Part 1 Beginner Level Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel beginner level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel beginner level course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel beginner level course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive excel beginner level course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel beginner level course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This excel beginner level course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This excel beginner level course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Getting Started With Excel 2016 Navigate the Excel User Interface - Introduction 00:01:00 Navigate the Excel User Interface 00:06:00 Use Excel Commands - Introduction 00:01:00 Use Excel Commands - Introduction 00:01:00 Create and Save a Basic Workbook - Introduction 00:05:00 Create and Save a Basic Workbook 00:05:00 Enter Cell Data - Introduction 00:01:00 Enter Cell Data 00:05:00 Flash Fill and Auto Fill 00:04:00 Use Excel Help - Introduction 00:01:00 Use Excel Help 00:03:00 Performing Calculations Create Worksheet Formulas - Introduction 00:01:00 Create Worksheet Formulas 00:06:00 Insert Functions - Introduction 00:01:00 Insert Functions 00:05:00 Reuse Formulas and Functions - Introduction 00:01:00 Reuse Formulas and Functions 00:05:00 Modifying a Worksheet Insert, Delete and Adjust Cells, Columns and Rows 00:04:00 Search for and Replace Data 00:06:00 Insert, Delete and Adjust Cells, Columns and Rows - Introduction 00:01:00 Use Proofing and Research Tools 00:01:00 Check the Spelling in a Worksheet 00:03:00 Search for and Replace Data - Introduction 00:01:00 Insights Task Pane 00:03:00 Formatting a Worksheet Apply Text Formats - Introduction 00:01:00 Apply Text Formats 00:06:00 Apply Number Formats - Introduction 00:02:00 Apply Number Formats 00:03:00 Align Cell Contents - Introduction 00:01:00 Align Cell Contents 00:03:00 Apply Cell Styles and Themes 00:06:00 Apply Cell Styles and Themes - Introduction 00:01:00 Create and Use Templates - Introduction 00:01:00 Apply Basic Conditional Formatting - Introduction 00:01:00 Apply Basic Conditional Formatting 00:03:00 Create and Use Templates 00:04:00 Printing Workbooks Preview and Print a Workbook 00:01:00 Configure and Preview a Print Job 00:03:00 Set Up the Page Layout - Introduction 00:01:00 Set Up the Page Layout 00:04:00 Configure Headers and Footers - Introduction 00:01:00 Configure Headers and Footers 00:02:00 Managing Workbooks Manage Worksheets - Introduction 00:01:00 Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views - Introduction 00:01:00 Manage Workbook and Worksheet Views 00:01:00 Manage Workbook Properties - Introduction 00:01:00 Manage Workbook Properties 00:03:00 Final Assessment Assessment - Microsoft Office Excel 2016: Part 1 Beginner Level 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Learn Microsoft Excel to create and format spreadsheets, analyse and share information to make knowledgeable resolutions. This Microsoft Office 2016 Excel Beginners is intended to teach you creating high-level workbooks and worksheets. Upon completion, you will have the ability to explain massive amounts of data and present that information to increase your understanding of the organisational account. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam - Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Excel Beginners 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description: This Microsoft Office 2007 Access Advanced - Complete Video Course builds on knowledge gained in the introduction and intermediate levels. This advanced series will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. You will also learn to automate functions by creating simple and then very advanced macros, advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects and the fundamentals of database management. Finally, you will be taught how to protect your valuable data sources. Before getting this course you must have the basic and intermediate skills of Microsoft Office 2007. This level will give you an advanced knowledge you need to know about Microsoft Office 2007. By taking this course you will have a complete understanding of the higher functions of 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 2007 Access 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 2007 Access 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. Querying with SQL SQL and Access FREE 00:02:00 Examining an SQL Statement in Access 00:02:00 Writing SQL Statements 00:03:00 Writing an SQL SELECT Statement 00:04:00 Using the WHERE Clause 00:02:00 Creating Aliases 00:04:00 Displaying Matching Records from Related Tabs 00:03:00 Finding Unmatched Records 00:03:00 Getting Context-Sensitive Help in SQL 00:01:00 Attaching SQL Queries to Controls 00:02:00 Assigning a SQL-Specific Query to Controls 00:04:00 Advanced Queries Creating Crosstab Queries 00:01:00 Viewing a Crosstab Query 00:02:00 Using the Crosstab Query Wizard 00:02:00 Creating Parameter Queries 00:01:00 Creating a Query with Multiple Parameters 00:03:00 Creating a Single Criterion Parameter Query 00:03:00 Using a Wildcard in a Parameter Query 00:02:00 Using Action Queries 00:02:00 Adding Records to a Table with an Append Query 00:03:00 Deleting Records with a Delete Query 00:04:00 Modifying Records with an Update Query 00:04:00 Creating a Make Table Query 00:01:00 Macros Running, and Modifying Macros 00:02:00 Creating and Running a Macro 00:02:00 Modifying a Macro 00:02:00 Attaching Macros to the Events of Database Objects 00:01:00 Attaching a Macro to the Open Event Form 00:02:00 Attaching a Macro to a Command 00:00:00 Advanced Macros Creating Macros to Provide User Interaction 00:02:00 Creating a Data Validation Macro 00:05:00 Creating a Data-Entry Macro 00:06:00 Creating Macros that Require User Input 00:03:00 Creating a Macro that Runs a Para 00:02:00 Creating the AutoKeys and AutoExec Macros 00:01:00 Creating an AutoKeys Macro 00:02:00 Creating an AutoExec Macro 00:01:00 Creating Macros for Data Transfer 00:01:00 Importing a Database Object 00:02:00 Importing, Exporting, and Linking Importing Objects 00:04:00 Importing Multiple Objects 2 days ago 00:02:00 Importing an Object from Excel 00:04:00 Using a Saved Import Specification 00:02:00 Importing a CSV File 00:03:00 Exporting Objects 00:01:00 Exporting an Object 00:03:00 Using a Saved Export Specification 00:01:00 Interacting with the XML Documents 00:02:00 Exporting and Import 00:04:00 Exporting to an XML 00:04:00 Linking Access Objects 00:02:00 Linking to an Access Table 00:03:00 Updating the Links 00:02:00 Linking to an Excel Workbook 00:02:00 Working with Windows SharePoint Services 00:02:00 Database Management Optimizing Resources 00:04:00 Converting a Database to a Prior Version 00:01:00 Analyzing Performance 00:03:00 Splitting a Database 00:04:00 Using the Compact and Repair Database Utility 00:01:00 Backing Up a Database 00:01:00 Protecting Databases 00:01:00 Encrypting a Database with a Password 00:01:00 Removing a Password and Encryption 00:01:00 Setting Options and Properties 00:02:00 Internet Integration Topic A Hyperlink Fields 00:02:00 Creating a Hyperlink Field 00:02:00 Inserting Data in a Hyperlink Field 00:01:00 Modifying Data in a Hyperlink Field 00:01:00 Working with Outlook 2007 00:01:00 Mock Mock Exam- Microsoft Office 2007 Access Advanced - Complete Video Course 00:20:00 Final Final Exam- Microsoft Office 2007 Access Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

Description: Nowadays Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel's uses cover a wide gamut - from simple data entry to complicated financial models and analysis. This Microsoft Office 2016 Excel Advanced - Complete Video Course is designed to help 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. You will learn Visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and more. So, if you have intermediate skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface. Then this advanced level will be very helpful for you. So, be an expert by joining us. 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 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 2016 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. Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Advanced - 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 intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010, 2013, or 2016 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve. Collaborate and work with colleagues using the Yammer and Planner apps. Use email and manage contacts with Outlook on the web. Collaborate using Teams. Configure Teams. This course introduces working with shared documents in the familiar Office 365 online apps?Word, PowerPoint©, and Excel©?as an alternative to installing the Microsoft© Office desktop applications. This course also introduces several productivity apps including Yammer?, Planner, and Delve© that can be used in combination by teams for communication and collaboration. Getting Started with Office 365 Topic A: Sign In to Office 365 Topic B: Navigate the Office 365 Environment Collaborating with Shared Files Topic A: Work with Shared Documents in SharePoint Topic B: Edit Documents in Office Online Topic C: Collaborate on the SharePoint Site Topic D: Work with OneDrive for Business Topic E: Find Shared Resources Using Productivity Apps Topic A: Work with Productivity Apps in Combination Topic B: Broadcast Messages with Yammer Using Outlook on the Web Topic A: Send and Receive Email Topic B: Manage Contacts Topic C: Schedule Appointments Topic D: Personalize Outlook on the Web Collaborating with Teams Topic A: Overview of Microsoft Teams Topic B: Converse and Share in Teams Topic C: Call and Meet in Teams Topic D: Collaborate with Microsoft 365 Apps and Teams Configuring Teams Topic A: Configure Teams Topic B: Configure Channels Topic C: Configure Tabs Additional course details: Nexus Humans Microsoft 365 Office for the Web (with Teams) 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 365 Office for the Web (with Teams) 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.

Description: This Microsoft Office 2016 Excel Intermediate - Complete Video Course will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles. So, why are you thinking? Come and be a part of this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 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 2016 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. Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course is a great opportunity for you to learn new skills or enhance your existing ones in Microsoft Office skills with admin support. You will also gain valuable insights into secretarial and PA roles. Whether you want to advance your career or start a new one in office administration or support roles. This course will equip you with the knowledge and skills you need to succeed. Don't miss this chance to enrol today!