1082 Microsoft 365 courses

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 OneDrive The Complete Microsoft OneDrive Course - Mastering OneDrive Promo 00:01:00 Quick Reminder - You Can Ask Me Anytime 00:01:00 Another Quick Reminder: You Facebook Group 00:01:00 Quick Win - Create a Folder and Rename It 00:01:00 Another Quick Quick Win - Share and Collaborate 00:01:00 What_Is OneDrive 00:03:00 OneDrive Free and Paid Plans 00:04:00 OneDrive Sign up 00:05:00 OneDrive Personal Vault 00:02:00 OneDrive PC folder Backup 00:02:00 OneDrive Desktop App Download and Installation 00:02:00 OneDrive Mobile App Download and Installation 00:04:00 Quick Win - Change The View Of Displayed Files And Folder 00:01:00 Another Quick Win Create a New Album 00:01:00 On Drive function And Interface Complete OneDrive Environment 00:06:00 Upload And Download In OneDrive 00:03:00 Creating New File And Folder In OneDrive 00:02:00 Selecting Files and Folder in OneDrive 00:01:00 Sharing And Collaborating Files And Folder In OneDrive 00:04:00 Other Options In Top Bar Of The Files And Folder 00:04:00 Other Options In Top Bar Of The Files And Folder Part 2 00:08:00 Picture options in OneDrive 00:03:00 Right Click options in OneDrive 00:01:00 Personals Valid in OneDrive 00:02:00 Personals Valid Options in OneDrive 00:03:00 Shared Folder in OneDrive 00:02:00 OneDrive Settings - Storage Management 00:03:00 OneDrive Settings (cont.) 00:04:00 Microsoft OneDrive Mobile Version 00:07:00 Microsoft Word OnDrive Complete Microsoft Word Environment 00:05:00 Ribbon Guide 00:01:00 Menu and Groups Guide 00:02:00 Learn Functions and Options Then Projects 00:01:00 Microsoft Word Home Menu Tools 00:17:00 Microsoft Word Home Reviewing and Viewing Mode 00:02:00 Microsoft Word File Menu 00:05:00 Microsoft Word Insert Menu - Page Break and Table 00:08:00 Microsoft Word Insert Picture Menu 00:05:00 Microsoft Word Word Inserting Header and Footer, Symbol And Emoji 00:05:00 Microsoft Word Layout Menu 00:02:00 Microsoft OneDrive References Menu 00:04:00 Microsoft Word Review Menu 00:05:00 Microsoft Word View and Help 00:02:00 Microsoft Word Project And Tables Practice Timetable Making in Microsoft Word 00:06:00 Bill System in Microsoft Word 00:06:00 Microsoft Excel OneDrive Microsoft Excel In OneDrive Environment 00:03:00 Microsoft Excel Home (Part 1) 00:11:00 Microsoft Excel Number Formats 00:03:00 Microsoft Excel Conditional Format 00:03:00 Microsoft Excel Formatting a Table 00:07:00 Microsoft One Drive Insert 00:06:00 Microsoft Data, Review and View 00:04:00 Microsoft Excel Practice Salary Table in Microsoft Excel 00:06:00 Salary Table In Microsoft Excel (Cont.) 00:07:00 Microsoft PowerPoint OneDrive Microsoft PowerPoint Environment 00:02:00 Microsoft PowerPoint Home and Insert Menu 00:06:00 Microsoft PowerPoint Insert and Design Menu 00:04:00 Microsoft Power Point Animation and Transition and More 00:04:00 Microsoft PowerPoint Practice Projects of PowerPoint 00:12:00 Other Apps in OneDrive and Setting OneNote in OneDrive 00:04:00 Forms Survey in OneDrive 00:03:00 Plain Text in OneDrive 00:01:00 OneDrive Profile Management 00:05:00 Account OneDrive Settings 00:03:00 Create Powerful Password For Your Account Quick Win - Create Unknown Password 00:01:00 Security Is Everything 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 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 Last-Pass & Authy Mobile App 00:02:00 Security Is Everything, Keep Secured Your Devices 00:07:00 Security on Your Data and Privacy 00:08:00 Conclusion Congratulations - You Are Now a Master of OneDrive 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

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 Excel Basics Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Formats 00:08:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Essential Formulas Basic Formula Operations 00:13:00 Mathematical Functions 00:19:00 Textual Functions 00:17:00 Logical Functions 00:11:00 Date-Time Functions 00:07:00 Lookup Functions ( V Lookup, Hlookup, Index-Match ) 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 Excel Charts Excel Charts - Categories of messages that can be conveyed 00:04:00 Elements of charts 00:05:00 The Easy way of creating charts 00:03:00 Bar and column charts 00:12:00 Formating charts 00:15:00 Line Charts 00:09:00 Area Charts 00:06:00 Pie and Doughnut Charts 00:13:00 Why we should avoid Pie charts 00:04:00 Scatter plot or XY chart 00:16:00 Frequency Distribution and Histograms 00:13:00 Waterfall Charts 00:12:00 Sparklines 00:05:00 Pivot Charts Pivot Charts 00:07:00 Named Ranges Named Ranges 00:10:00 Indirect Function 00:05:00 Excel Shortcuts Shortcuts 00:12:00 Macros Macros 00:10:00 Advanced Excel Advanced Excel: Analytics in Excel 00:15:00 Final Assessment Assessment - Microsoft Excel For Beginners 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

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 Microsoft Yammer - Social Networking in Companies and Organizations What is Yammer And When Should You Use It. 00:03:00 First Steps In Yammer 00:09:00 Communicate Effectively With Yammer 00:14:00 How Does Yammer Work With Other Apps. 00:03:00 Yammer On Mobile Devices 00:02:00 Conclusions 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

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 Course Overview Video - Course Overview 00:03:00 Microsoft Word 2016 Basics Video - Overview of the Microsoft Word 2016 Ribbon 00:04:00 Video - Open and Save a New Microsoft Word Document 00:03:00 Video - Save or Covert a word document as a PDF in Word 2016 00:02:00 Video - Edit a PDF Document Using Microsoft Word 00:04:00 Video - Making Business Cards With Microsoft Word 00:03:00 Video - Create double space lines in Microsoft Word 00:03:00 Video - Add or Remove Page Numbers in Microsoft Word 00:03:00 Video - Add or Remove Page Numbers in Microsoft Word 00:03:00 Video - Delete Blank Pages in Microsoft Word 00:02:00 Video - Create a page break in Microsoft Word 00:01:00 Video - Create a Document Using a Microsoft Word Template 00:03:00 Video - Inspecting and Protecting Word Documents 00:03:00 Video - Encrypting and De-encrypting a Microsoft Word Document 00:02:00 Inserting Objects in Microsoft Word Video - Insert a Chart in Microsoft Word 00:05:00 Video - Insert and Movie or Picture in Microsoft Word 00:04:00 Video - Insert an Online image in Microsoft Word 00:02:00 Video - Insert a Hyperlink in Microsoft Word 00:02:00 Video - Insert/embed an Excel Spreadsheet in Microsoft Word 00:06:00 Video - Insert, Resize and Format a Table in Microsoft Word 00:04:00 Video - How to Use Bookmarks in Microsoft Word 00:03:00 Video - Insert Text Boxes in Microsoft Word 00:05:00 Video - Insert a Video or Audio File in Word 2016 00:04:00 Video - Installing Free Fonts for Microsoft Word 00:02:00 Microsoft Word for Students Video - Using the APA template in Microsoft Word 00:05:00 Video - Adding Grammarly to Your Microsoft Word Program 00:04:00 Video - Create an Automatic Table of Contents in Microsoft Word 00:03:00 Video - Create a cover page in Microsoft Word 00:03:00 Video - Add Recently Viewed Word Documents to Pin List 00:02:00 Video - Using Search & Replace in Microsoft Word 00:05:00 Video - Add Comments in Microsoft Word 00:03:00 Video - Using the New Undo feature in Microsoft Word 00:02:00 Video - Set the Default Font in Microsoft Word 00:02:00 Video - Using SmartArt for Graphic Design in Microsoft Word 00:03:00 Advanced Microsoft Word Features Video - Reshaping Images in Microsoft Word 00:04:00 Video - Remove the background of an image using Microsoft Word 00:03:00 Video - Perform Calculations in Microsoft Microsoft Word 00:03:00 Video - Write Equations in Microsoft Word 00:03:00 Video - Using Smart Lookup in Microsoft Word 00:02:00 Video - Using Microsoft's Random Text Generator 00:03:00 Video - Enable Text to Speech in Microsoft Word 00:02:00 Video - Using the Clipboard and Multi-Paste Feature 00:02:00 Video - Add page Numbers to an Existing Header or Footer 00:02:00 Video - Tips & Tricks for Microsoft Word 00:08:00 Mail Merge Video - Create a Directory in M$ Word Using Mail Merge 00:10:00 Troubleshooting's Microsoft Word Video - Using the File Open and Repair Feature 00:01:00 Video - Repair or Reinstall the Microsoft Word 00:03:00 Video - Word Experienced an Error Trying to Open the file 00:05:00 Video - Reset Microsoft Office Word to Default Settings 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

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

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

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

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

Let's give you three situations: Firstly, you need to write down a formal letter Then, your boss asks for annual employment records Finally, you have to make a presentation for the next conference How do you complete these tasks? Do you start making posters for your presentation or start calculating the records on hand? You can not imagine doing that this way. Right? Because it's time-consuming. You probably want to use software where you can complete your work efficiently. One of these software is Microsoft Office which most companies use. So, acquire your knowledge and expertise in Microsoft Office and flourish in your career. Apex Learning is offering you a comprehensive Microsoft Training course, where you can learn from the basics to advanced levels to learning about Microsoft Word, Microsoft PowerPoint, Microsoft Excel and many more. So, join this course for further learning! We included the latest knowledge about Microsoft to make you an exceptional candidate and well fit for the position. So, go through our learning material and acquire how to add, delete, and attach data, tables and pictures. Moreover, learn how to calculate data in Excel, how to create slides on PowerPoint and how to write documents in Word from this course. So, if you are keen to advance your skills in Microsoft Office, enrol in our Microsoft Training course now. Furthermore, to help you showcase your expertise in Microsoft, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Microsoft Training Bundle Consists of the following Premium courses: Course 01: Microsoft SQL Server Development for Everyone Course 02: MS Word Diploma Course 03: Advanced Diploma in MS Excel Course 04: PowerPoint Diploma Course 05: The Complete Microsoft OneDrive Course Course 06: The Complete Microsoft Outlook Masterclass Course 07: Course 08: Complete Microsoft Power BI 2021 Course 09: Microsoft Teams Course 10: Course 11: Touch Typing Essentials Course 12: GDPR Data Protection Level 5 Course 13: Functional Skills IT Course 14: Time Management Learning outcomes: After completing this Microsoft Training course, learners will be able to: Learn about the fundamentals of Microsoft from this course Acquire how to work in Microsoft Word, Microsoft Excel and Microsoft PowerPoint Know more about attaching, adding, editing and deleting data in excel Deepen your understanding of managing various work in Microsoft Office Equip yourself with the knowledge of Microsoft office and advance your career in the future So, what are you waiting for? Enrol in the Microsoft Training course and start your learning journey now! The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Trainingexpertise and essential knowledge, which will assist you in reaching your goal. Enrol now in Microsoft Training to advance your career, and use the premium study materials from Apex Learning. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Training course is designed for everyone. More suitable for Students Recent Graduate A beginner who wants to learn about Microsoft Office An expert who wants to improve their skills in Microsoft Office Anyone with a knack for learning about Microsoft Office Requirements You don't need any specific skills or qualifications to enrol in this Microsoft Training course. Career path The expertise and knowledge you will gain after the completion of this Microsoft Training course will help you grab various opportunities, such as; Office Administrator Data Analyst Microsoft Security Specialist IT Support Analyst Software Tester The annual salary of these positions is between£25,000 - £50,000 per annum in the UK. Certificates Certificate of completion Digital certificate - Included

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