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

827 Microsoft 365 courses delivered On Demand

Microsoft SharePoint Training Course

By Study Plex

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 Course Overview Course Overview 00:01:00 The User Interface What is SharePoint. 00:02:00 Start SharePoint 00:04:00 User Interface 00:10:00 Team Sites Team Sites - Introduction 00:01:00 The Document Library Web Part - Basic Features 00:08:00 Advanced Features of the “Document Library” 00:05:00 The News Web Part 00:04:00 List Web Part 00:06:00 The Menu Item “Conversations” 00:04:00 The “Notebook” Menu Item 00:04:00 More Web Parts 00:03:00 Communication Sites Communication Sites 00:06:00 The Interaction With Other Applications Sync with File Explorer 00:13:00 The “Office Suite” applications 00:04:00 SharePoint and Microsoft Teams 00:06:00 SharePoint On Mobile Devices SharePoint on Mobile Devices 00:02:00 SharePoint-Administration SharePoint-Administration 00:07:00 Review Review 00:02: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

Microsoft SharePoint Training Course
Delivered Online On Demand
£19

Microsoft Excel For Business

By Study Plex

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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 Essential Formulas and Functions Mathematical Functions 00:06:00 Textual Functions 00:07:00 Logical Functions 00:11:00 Date-time (Temporal) Functions 00:07:00 Lookup Formulas Lookup Functions 00:08:00 Data Tools Data Tools 00:19:00 Formatting data and tables Formatting data and tables 00:18:00 Pivot Tables Pivot Tables 00:08:00 Charts Charts-Part 1 00:10:00 Charts-Part 2 00:12:00 Named Ranges Named Ranges 00:10:00 Indirect Functions 00:05:00 Excel Shortcuts Excel Shortcuts 00:12:00 Analytics in Excel Analytics in Excel 00:15:00 Macros Macros 00:10:00 Excel Uses Cases: Engaging Visualizations Infographics 1: Cool charts 00:14:00 Infographics 2: Cool charts 00:06:00 Waterfall chart 00:12:00 Excel Uses Cases: Modeling Customer Lifetime value Concept of Net Present Value and Customer Value 00:09:00 Finding Net Present Value in Excel 00:11:00 Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Assessment Assessment - Microsoft Excel For Business 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Microsoft Excel For Business
Delivered Online On Demand
£19

Microsoft Excel Online Training

By Study Plex

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 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 excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft 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 Excel Online Training Course Master the skills you need to propel your career forward in Microsoft 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 Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel 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 excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft 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 excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel 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 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 Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel 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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Microsoft Excel Online Training
Delivered Online On Demand
£19

Microsoft Outlook Mastering Program

By Study Plex

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 You Can Master Microsoft Outlook You Can Master Microsoft Outlook Promo 00:02:00 You Can Ask Me Anytime 00:01:00 Your Facebook Support Group 00:01:00 Quick Win - How To Send an Email in Outlook 00:01:00 Quick Win - How To Print an Email in Outlook 00:01:00 Another Quick Win - You Can Work Offline With Outlook 00:01:00 Getting Started With Outlook Outlook Environment 00:03:00 Outlook Opening 00:02:00 Outlook Interface Options 00:04:00 Sending and Receiving Email in Outlook 00:03:00 Sending and Receiving Email in Outlook with Attachments 00:02:00 File Menu Account Settings in Outlook 00:06:00 Automatic Replies in Outlook 00:04:00 Mail Box Settings in Outlook 00:02:00 Rules and Alerts Settings in Outlook 00:04:00 Exporting and Importing Rules and Alerts in Outlook 00:01:00 Opening Options in File Outlook 00:04:00 Home - New Email in Outlook Quick Win - How To Create Folder in Outlook 00:01:00 Quick Win - How To Change Outlook Style 00:01:00 Quick Win - How To Use Quick Access Toolbar 00:01:00 New Email Options in Outlook 00:03:00 Clipboard in New Email 00:05:00 Basic Text in New Email 00:07:00 Name, Include and Tags in New Email 00:03:00 Inserting Table Into New Email 00:10:00 Inserting Images Into New Email 00:10:00 Inserting Shapes Into New Email 00:06:00 Inserting SmartArt Into New Email 00:04:00 Inserting New Chart Into New Email 00:05:00 Taking Screenshot Into New Email 00:02:00 Links, Text and Symbol 00:03:00 Themes, Show Fields, Encrypt, Tracking and More Options in New Email 00:03:00 Formatting Text in New Emails 00:03:00 Text Style in New Email 00:04:00 Reviewing Menu in New Email 00:03:00 Home - New Appointment New Appointment at Home Menu 00:06:00 Home - New Meeting New Meeting at Home Menu 00:01:00 Home - New Contact New Contact in Home Menu 00:05:00 Home - New Task Create New Task 00:03:00 Other New Item in Home 00:02:00 Home - Other Functions Email Deletion in Outlook 00:02:00 Responding to A Email in Outlook 00:02:00 Quick Steps, Tag and Other Functions 00:03:00 Send and Receive Complete Guide of Send and Receive 00:03:00 Home - Folder Complete Folder Guide 00:05:00 Review and Outlook View and Help in Outlook 00:04:00 Options Options Intro 00:03:00 General Options in Outlook 00:05:00 Mail Options in Outlook 00:06:00 Calendar Options in Outlook 00:03:00 Contact Options in Outlook 00:01:00 Task Options in Outlook 00:01:00 Search Options in Outlook 00:02:00 Language Options in Outlook 00:02:00 Ease of Access Options in Outlook 00:02:00 Advanced Option in Outlook 00:04:00 Ribbon and Quick Access Toolbar Customization 00:02:00 Security Is Everything Quick Win - Create Unknown Password 00:01:00 Security Is Everthing 00:01:00 Quick Win - Insecurity Is Coming from You And Others 00:01:00 Understand Security Type or Category 00:02:00 Life Savers - You Should Know These 00:04:00 Have Proper Password - Start Securing You Now 00:03:00 Don't Use the Same Password Anymore 00:02:00 Should You Use Longer Password or Complicated! 00:03:00 Last-Pass & Authy Mobile App 00:02:00 The Best and Only Solution to Make and Keep Password Un-Crack-Able 00:08:00 Lastpass Setup and Configure 00:10:00 Last-Pass Options Part 1 00:03:00 Last-Pass Options Part 2 00:04:00 Last-Pass Option Part 3 00:04:00 2FA Makes You Even Stronger in Password 00:05:00 Security Is Everything, Keep Secured Your Devices 00:07:00 Security on Your Data and Privacy 00:08:00 Conclusion Congratulations 00:01:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Microsoft Outlook Mastering Program
Delivered Online On Demand
£19

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 Outlook 2016 for Beginners

4.3(43)

By John Academy

Description: Get started with Microsoft Outlook 2016. This Microsoft Outlook 2016 for Beginners will help new users set up and use Outlook on Windows. It guides you through Microsoft Outlook and looks into the practical application of its numerous functionalities. And it will help you to get comfortable with the Outlook 2016 interface, creating and sending messages, managing contacts, using the calendar, managing tasks, and working with notes. If you are looking forward to get skilled on Microsoft Office Outlook, you can start a step with this course. Learning Outcomes: Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses Customize reading options, work with attachments and manage message responses Managing and organization of messages with the help of tags, flags, other commands and folders Using calendar options to manage appointments and meetings Using People workspace to create, update, view and organise contacts Managing tasks and notes Creating and managing Quick Steps, and customizing the interface according to needs 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 Outlook 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 Outlook 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 Outlook 2016 Navigate the Outlook Interface 00:15:00 ACTIVITY - NAVIGATING THE OUTLOOK INTERFACE 00:05:00 Perform Basic E-mail Functions 00:30:00 ACTIVITY - PERFORMING BASIC E-MAIL FUNCTIONS 00:05:00 Use Outlook Help 00:15:00 ACTIVITY - GETTING HELP IN MICROSOFT OUTLOOK 2016 00:05:00 Composing Messages Create an E-mail Message 00:15:00 ACTIVITY - CREATING AN E-MAIL MESSAGE 00:05:00 Check Spelling and Grammar 00:15:00 ACTIVITY - CHECK SPELLING AND GRAMMAR 00:05:00 Format Message Content 00:15:00 ACTIVITY - FORMAT MESSAGE CONTENT 00:05:00 Attach Files and Items 00:15:00 ACTIVITY - ATTACHING A FILE TO A MESSAGE 00:05:00 Enhance an E-mail Message 00:30:00 ACTIVITY - ENHANCING AN E-MAIL MESSAGE 00:05:00 Manage Automatic Message Content 00:15:00 ACTIVITY - MANAGING AUTOMATIC MESSAGE CONTENT 00:05:00 Reading and Responding to Messages Customize Reading Options 00:15:00 ACTIVITY - CUSTOMIZING READING OPTIONS 00:05:00 Work with Attachments 00:15:00 ACTIVITY - WORKING WITH ATTACHMENTS 00:05:00 Manage Your Message Responses 00:15:00 ACTIVITY - MANAGING YOUR MESSAGE RESPONSES 00:05:00 Managing Your Messages Manage Messages Using Tags, Flags, and Other Commands 00:15:00 ACTIVITY - MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS 00:05:00 Organize Messages Using Folders 00:15:00 ACTIVITY - ORGANIZING MESSAGES USING FOLDERS 00:04:00 Managing Your Calendar View the Calendar 00:15:00 ACTIVITY - CUSTOMIZING YOUR CALENDAR VIEW 00:05:00 Manage Appointments 00:15:00 ACTIVITY - MANAGING APPOINTMENTS 00:05:00 Manage Meetings 00:30:00 ACTIVITY - CREATING AND MANAGING MEETINGS 00:05:00 Print Your Calendar 00:15:00 ACTIVITY - PRINTING YOUR CALENDAR 00:05:00 Managing Your Contacts Create and Update Contacts 00:15:00 ACTIVITY - CREATING AND UPDATING CONTACTS 00:05:00 View and Organize Contacts 00:15:00 ACTIVITY - VIEW AND ORGANIZE CONTACTS 00:05:00 Working with Tasks and Notes Create Tasks 00:15:00 ACTIVITY - CREATING TASKS 00:05:00 Manage Tasks 00:15:00 ACTIVITY - MANAGING TASKS 00:05:00 Manage Notes 00:15:00 ACTIVITY - CREATING AND MANAGING NOTES 00:05:00 Customizing the Outlook Environment Customize the Outlook Interface 00:30:00 ACTIVITY - CUSTOMIZING THE OUTLOOK INTERFACE 00:05:00 Create and Manage Quick Steps 00:15:00 ACTIVITY - CREATING AND MANAGING QUICK STEPS 00:05:00 Activities Activities - Microsoft Outlook 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Outlook 2016 for Beginners 00:20:00 Final Exam Final Exam- Microsoft Outlook 2016 for Beginners 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Outlook 2016 for Beginners
Delivered Online On Demand9 hours 59 minutes
£18

Microsoft Windows 10 Pro Masterclass

4.3(43)

By John Academy

Course Overview Learn how you can install, upgrade and maintain your Microsoft Windows 10 like a pro from this Microsoft Windows 10 Pro Masterclass course and make your work smooth and fast. This course will help you to understand the functions of Windows 10, configuration, management, security and many other functions and help you get the best output from your device. The easily understandable and bite-sized lessons of this Microsoft Windows 10 Pro Masterclass course will help you to understand how Windows 10 functions. You will be able to familiarize yourself with the network configuration and server domain-based environment to utilize the functions of Internet and cloud services. Even if you don't know anything about Windows 10, this course will help you to grasp the ideas and functions and use them properly. Learning Outcomes Learn how to plan, install and upgrade to Windows 10 Be able to implement networking system and remote management Understand file management and resources for your Windows 10 Familiarize with maintenance and update options of Windows 10 Get a clear understanding of local storage Ensure network security for your device Be able to troubleshoot and recover Windows 10 Who is this course for? This course is ideal for anyone who wants to understand the functions of Windows 10 and how to maintain and update their browser. You will learn various security and networking options of Windows 10 from this course. 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 Microsoft Windows 10 Pro Masterclass is a useful qualification to possess and would be beneficial for any related profession or industry such as: Computer Operators Data Security Officers Troubleshooters Data Maintenance Officers IT Professionals Administrators Module 01: Course Overview Course Overview 00:05:00 Module 02: Building Your Virtual Lab Environment Easily download ISO Images 00:10:00 Lab - Creating a Virtual Install of Windows 10 Pro Using VirtualBox 00:16:00 Lab - Create Virtual Install of Server 2016 Full GUI Using VirtualBox 00:13:00 Taking a Snapshot of Your Current configuration 00:04:00 Module 03: Upgrading Windows 7, 8, or 8.1 to Windows 10 Perform a Windows 10 Upgrade for Free 00:09:00 Module 04: Building a Microsoft Server 2016 Domain Preparing Your Network for Active Directory 00:10:00 Lab - Prepare Server 2016 for Promotion to a Domain Controller 00:10:00 Lab - Promote Server 2016 to a Domain Controller 00:09:00 Lab - Join a Windows 10 Workstation to a Microsoft Domain 00:15:00 Module 05: Windows Deployment Services (WDS) Installing WDS on a Windows Server Using VirtualBox 00:18:00 Deploy a Windows 10 Client Using WDS 00:09:00 lab - Create an Unattended Install of Windows 10 Pro 00:17:00 Module 06: Windows 10 Firewall, Windows Defender and UAC Turn the Windows 10 Firewall Off or On 00:01:00 Allow an app through the Windows 10 firewall 00:05:00 Add a rule or port to a Windows 10 firewall 00:05:00 Allow PING for Windows 10 00:04:00 Disable the UAC User Account Control in Windows 10 00:02:00 Using netsh to Manage the Windows Firewall 00:05:00 Using Powershell to Gather Firewall Information 00:04:00 Module 07: Networking Change your IP address in Windows 10 00:05:00 Add a second IP address in Windows 10 00:09:00 Module 08: Troubleshooting Enable System Restore on Windows 10 00:03:00 Create a System Restore point on Windows 10 00:02:00 Recover using System Restore on Windows 10 00:04:00 Fix TCPIP Corruption in Windows 10 Using Netsh 00:02:00 Repair Windows 10 with System File Checker (SFC) 00:03:00 Repair Windows 10 System files offline Using SFC 00:04:00 Use ReadyBoost to Speed up Windows 10 00:05:00 Reset Your Network Adapter 00:06:00 Lab - Troubleshooting Internet Connectivity 00:16:00 NSLookup 00:05:00 Windows Reliability Monitor 00:04:00 Module 09: User Preferences Disable the Lock Screen on Windows 10 00:03:00 Disable Superfetch via Windows Services 00:03:00 Disable Screen Saver in Windows 10 using REGEDIT 00:02:00 Disable Windows 10 Automatic Logoff For Inactivity 00:02:00 Overview of the Windows 10 Shutdown and Restart buttons 00:01:00 Module 10: Maintenance Rename your Windows 10 computer 00:01:00 Change the date and time in Windows 10 00:03:00 Create a new local user in Windows 10 00:04:00 Rearm the 30-day evaluation Period for Windows 10 Pro 00:03:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Windows 10 Pro Masterclass
Delivered Online On Demand4 hours 21 minutes
£18

Microsoft Windows 10 Certificate Course

4.3(43)

By John Academy

Description: Windows 10 is the latest iteration of Microsoft's widely used Windows operating system. This new version of Windows incorporates hundreds of new features as well as improvements to existing ones. This Microsoft Windows 10 Certificate Course is designed to help both novice and experienced. By taking this course you will become familiar with the many changes that have been made to Windows. You will also be comfortable logging into Windows 10, completing basic actions using its user interface, customizing the user interface, understanding its security features, and using both Microsoft Edge and File Explorer. You can join this course to improve your skills. Learning Outcomes: Identify components of a personal computer, learn to sign into Windows 10, get familiarized with the user interface by exploring desktop and Start menu Multitask with apps, search computer, and view notifications Further your knowledge of Windows Store apps and Windows 10 navigation techniques Work with desktop windows, manage files and folders with File Explorer, and create files through desktop applications Browse the internet using Microsoft Edge, manage tabs and customize options Customize basic Windows settings, Lock screen, and desktop Configure passwords, use Windows Defender, and store and share files using OneDrive 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 Windows 10 Certificate 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 Windows 10 Certificate 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. Microsoft Windows 10 Certificate Course Identify Components of a Personal Computer 00:15:00 Sign Into Windows 10 00:15:00 Navigate the Desktop 00:30:00 Explore the Start Menu 00:30:00 Multitask with Apps 00:15:00 Search Your Computer 01:00:00 View Notifications 00:15:00 Windows 10 Navigation Summary 00:30:00 Manage Files and Folders with File Explorer 00:30:00 Create and Modify Files with Desktop Applications 00:30:00 Navigate Microsoft Edge 00:15:00 Use Microsoft Edge 00:30:00 Manage Tabs 00:15:00 Modify Microsoft Edge Options 00:30:00 Change Basic Windows Settings 00:30:00 Customize the Lock Screen 00:15:00 Customize the Desktop 00:15:00 Configure Passwords 00:15:00 Use Windows Defender 00:15:00 Store and Share Files with OneDrive 00:30:00 Mock Exam Mock Exam- Microsoft Windows 10 Certificate Course 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Certificate Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Windows 10 Certificate Course
Delivered Online On Demand8 hours 40 minutes
£18

Microsoft Visio 2016 for Beginners

4.3(43)

By John Academy

Description: Microsoft Visio is a diagramming and vector graphics application. The Microsoft Visio 2016 for Beginners provides the basic information about the diagramming software. In the course, you will learn the essential features of the latest version of Microsoft Visio. The course will teach you how to start with the software and how to create workflow diagram, how to create the organisational diagram, etc. Throughout the course, you will also know the procedures of making a flood plan, creating a cross-functional diagram, and styling the diagram. The Microsoft Visio 2016 for Beginners provides you with the adequate knowledge about Microsoft Visio so that you can convert the complex information into simple, easy-to-understand diagrams. Learning Outcomes: Navigation throughout Visio interface, creating basic drawing and using the help system Drawing components, modifying drawings and work with callouts and groups Organization charts creation, modifying their layouts, positioning and spacing Create and integrate organization chart copies and compare them Making a basic floor plan and custom room shapes, utilizing the program as a modelling tool and modelling room layouts Creating cross-functional flowcharts and related features like - swimlanes and separators Altering orientation and direction, changing margins and choosing styles for flowcharts Creating network diagrams, and utilizing shape data and layers Other network diagram relevant topics such as network shapes, shape data, adding layers, activating, colouring and more Working with shape, connector styles, themes, variants and containers 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 Visio 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 Visio 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 Visio 2016 Navigate the Visio Environment 00:15:00 Create a Basic Drawing 00:30:00 Use the Help System 00:15:00 Creating a Workflow Diagram Use Drawing Components 00:30:00 Modify a Drawing 00:15:00 Work with Callouts and Groups 00:15:00 Creating an Organization Chart Create a Basic Organization Chart 00:30:00 Do More with Organization Charts 00:15:00 Making a Floor Plan Make a Basic Floor Plan 00:30:00 Model a Room Layout 00:15:00 Creating a Cross-Functional Flowchart Create a Cross-Functional Flowchart 00:30:00 Modify a Cross-functional Flowchart 00:15:00 Creating a Network Diagram Create Network Diagrams 00:15:00 Use Shape Data 00:15:00 Use Layers 00:30:00 Styling a Diagram Work with Shape and Connector Styles 00:15:00 Work with Themes and Variants 00:15:00 Work with Containers 00:15:00 Activities Activities - Microsoft Visio 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Visio 2016 for Beginners 00:20:00 Final Exam Final Exam- Microsoft Visio 2016 for Beginners 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Visio 2016 for Beginners
Delivered Online On Demand6 hours 40 minutes
£18

Microsoft Sway Online Training

4.3(43)

By John Academy

Description Learn to create a Sway from start to finish with the Microsoft Sway Online Training course. Microsoft Sway is an easy-to-use digital storytelling app for creating and sharing interactive reports, newsletters, presentations, personal stories and more. Throughout the course, you will learn how to use Microsoft Sway to create newsletters, presentations, documentation, or for doing communication. The course teaches you where to access, and how to start building your own Sways such as presentations, tutorials, newsletters, stories, and more. Sway's design engine allows you to bring your content together nicely and helps you to finish it. You will learn how to share any Sway or co-edited it with a simple URL. In short, the course illustrates the techniques of using the program to create interactive reports, newsletters, presentations, etc. You will also know how to use Sway to collaborate on projects and share them with others. Certification: After completing 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 Sway Online Training 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 Sway Online Training 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: 01 TOPIC A: Launch Sway 00:30:00 TOPIC B: Create a New Sway Project 00:45:00 TOPIC C: Create Cards 00:30:00 TOPIC D: Manage Cards 00:30:00 TOPIC E: Manage Sway Projects 00:30:00 Module: 02 TOPIC A: Format Text 00:30:00 TOPIC B: Add Media 00:45:00 Module: 03 TOPIC A: Work with Images 00:45:00 TOPIC B: Customize Image Display 00:45:00 TOPIC C: Set Design Options 00:30:00 Module: 04 TOPIC A: Edit Sway Projects 00:30:00 TOPIC B: Share a Sway Project 00:45:00 TOPIC C: Set Sway Project Options 00:30:00 Order Your Certificate Order Your Certificate 00:00:00

Microsoft Sway Online Training
Delivered Online On Demand7 hours 45 minutes
£18