515 Computer Skills courses in Nottingham delivered On Demand

Overview This comprehensive course on Basic Adobe Photoshop will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Basic Adobe Photoshop comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Basic Adobe Photoshop. It is available to all students, of all academic backgrounds. Requirements Our Basic Adobe Photoshop is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 28 lectures • 01:33:00 total length •Introduction: 00:01:00 •Hot keys, Other Functions: 00:02:00 •Brush Properties: 00:06:00 •Cropping: 00:02:00 •Make the horizon horizontal: 00:01:00 •Organize highlights in groups: 00:02:00 •Hidden details in the shadows: 00:02:00 •Make corrections in the perspective: 00:01:00 •Work with layers: 00:05:00 •Organize layers in groups: 00:04:00 •Merging, rasterizing and flattening layer: 00:04:00 •Gradient layer mask: 00:03:00 •Combine recordings with layer masks: 00:03:00 •Eliminate irregularities: 00:06:00 •Make skin smoother: 00:02:00 •Whiten teeth: 00:02:00 •Clear eyes: 00:05:00 •Update body contours: 00:03:00 •Make irregularities less conspicuous: 00:03:00 •Place a transparent logo or watermark: 00:02:00 •Change color: 00:02:00 •Cut out figures and release them from the background: 00:13:00 •Add text to a photo: 00:05:00 •Place text blocks in an image: 00:01:00 •Let text follow a path: 00:02:00 •Display photos in letters: 00:03:00 •Text warp and twist: 00:03:00 •Character Styles and Paragraph Styles: 00:05:00

Overview Embark on a transformative journey with the Office Skills and Administration Management Diploma, a comprehensive course designed to equip learners with essential skills for thriving in today's dynamic office environments. This course offers a deep dive into the core competencies required for excellence in administrative roles, addressing the increasing demand for skilled professionals in this sector. Participants will explore various topics, from the fundamentals of administrative management to advanced skills in business writing and digital proficiency. The curriculum is meticulously crafted to ensure a thorough understanding of both theoretical and applied aspects of office administration. This includes developing exceptional organisational skills, mastering effective communication, and honing expertise in essential software like Excel and PowerPoint. By completing this course, learners will be well-equipped to navigate and excel in the ever-evolving landscape of office administration. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Office Skills and Administration Management Diploma. It is available to all students, of all academic backgrounds. Requirements Our Office Skills and Administration Management Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 53 lectures • 19:18:00 total length •Personal Assistant: 01:23:00 •Admin Support: 01:54:00 •Administrative Management: 01:00:00 •Organisational Skills: 01:16:00 •Telephone Etiquette: 01:07:00 •Business Writing: 01:24:00 •Time Management: 01:09:00 •Body Language and Effective Communication: 01:23:00 •Meeting Management: 01:24:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:07:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Customize the User Interface: 00:19:00 •Set PowerPoint 2016 Options: 00:07:00 •Modify Slide Masters and Slide Layouts: 00:16:00 •Add Headers and Footers: 00:05:00 •Modify the Notes Master and the Handout Master: 00:04:00 •Create SmartArt: 00:09:00 •Modify SmartArt: 00:05:00 •Write Math Equations: 00:07:00 •Add Audio to a Presentation: 00:09:00 •Add Video to a Presentation: 00:10:00 •Customize Animations and Transitions: 00:14:00 •Review a Presentation: 00:15:00 •Store and Share Presentations on the Web: 00:06:00 •Annotate a Presentation: 00:07:00 •Set Up a Slide Show: 00:08:00 •Create a Custom Slide Show: 00:03:00 •Add Hyperlinks and Action Buttons: 00:07:00 •Record a Presentation: 00:05:00 •Secure a Presentation: 00:11:00 •Broadcast a Slide Show: 00:07:00 •Create a Video or a CD: 00:08:00

Overview This comprehensive course on Master JavaScript with Data Visualization will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Master JavaScript with Data Visualization comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Master JavaScript with Data Visualization. It is available to all students, of all academic backgrounds. Requirements Our Master JavaScript with Data Visualization is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 76 lectures • 06:21:00 total length •Introduction to Getting Started: 00:02:00 •Course Curriculum: 00:05:00 •How to Get Pre-Requisites: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:01:00 •How to ask a Great Questions: 00:02:00 •FAQ's: 00:01:00 •What is JavaScript: 00:09:00 •Choosing Code Editor: 00:03:00 •Installing Code Editor (Sublime Text): 00:04:00 •Installing Code Editor(Visual Studio Code): 00:07:00 •Hello World Program: 00:14:00 •Getting Output: 00:11:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Internal JavaScript: 00:13:00 •External JavaScript: 00:09:00 •Inline JavaScript: 00:04:00 •Async and defer: 00:06:00 •Variables: 00:13:00 •Data Types: 00:10:00 •Numbers: 00:06:00 •Boolean: 00:04:00 •Arrays(): 00:12:00 •Objects: 00:06:00 •Comments: 00:05:00 •Summary: 00:01:00 •Introduction: 00:02:00 •Strings: 00:06:00 •String Formatting: 00:05:00 •String Methods: 00:12:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Arithmetic operators: 00:07:00 •Assignment operators: 00:03:00 •Comparison operators: 00:06:00 •Logical operators: 00:08:00 •Summary: 00:02:00 •Introduction: 00:02:00 •If statement: 00:04:00 •If-else statement: 00:05:00 •If-else-if statement: 00:04:00 •Switch-case statement: 00:09:00 •Summary: 00:01:00 •Introduction: 00:02:00 •While loop: 00:09:00 •Do-while loop: 00:03:00 •For loop: 00:08:00 •Break: 00:02:00 •Continue: 00:03:00 •Coding Exercise: 00:02:00 •Solution for Coding Exercise: 00:02:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Creating a Function: 00:07:00 •Function Call(): 00:07:00 •Function with parameters: 00:05:00 •Function Bind(): 00:06:00 •Summary: 00:01:00 •Introduction: 00:01:00 •How to Use Google chart script: 00:04:00 •Line Graph chart: 00:14:00 •Scatter plots chart: 00:02:00 •Bar chart: 00:04:00 •Pie chart: 00:02:00 •3D Pie chart: 00:02:00 •Summary: 00:01:00 •Introduction: 00:01:00 •Try-catch: 00:05:00 •Try-catch-finally: 00:17:00 •Summary: 00:01:00 •Introduction: 00:01:00 •On Submit Validation: 00:09:00 •Input Numeric Validation: 00:12:00 •Login Form Validation: 00:05:00 •Password Strength Check Validation: 00:04:00 •Summary: 00:01:00

Mastering the art of typing isn’t just about speed—it's about precision, efficiency, and consistency. Our Advanced Typing Techniques Course is designed to help individuals refine their typing skills and unlock the full potential of their keyboard. Whether you’re an office worker, student, or professional looking to streamline your workflow, this course offers a structured approach to perfecting your technique. By focusing on advanced typing methods, you will improve your accuracy, reduce strain, and type faster, giving you more time to focus on what really matters. Throughout the course, you’ll explore key concepts such as ergonomic practices, optimal hand placement, and specific strategies to increase typing speed without sacrificing quality. Each module is crafted to provide you with the tools needed to break through any typing plateau you may have encountered. Say goodbye to errors and hello to seamless, efficient typing. It’s time to invest in yourself and take your typing skills to the next level, one keystroke at a time. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to Advanced Typing Module 02 : Advanced Typing Techniques Module 03 : Speed Building Strategies Module 04 : Error Reduction and Proofreading Module 05 : Specialised Typing Tasks Module 06 : Typing Software and Tools Module 07 : Typing Speed and Accuracy Assessment Learning Outcomes: Improve typing speed and precision for efficient work. Reduce typing errors and enhance document quality. Develop strategies to build typing speed effectively. Handle specialised typing tasks with confidence. Utilise essential typing software and tools proficiently. Assess typing speed and accuracy for continuous improvement. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Office professionals Data entry specialists Administrative assistants Content writers Transcriptionists Students Anyone seeking keyboard mastery Job seekers looking to enhance their skills Career path Data Entry Clerk Administrative Assistant Content Writer Transcriptionist Secretarial Roles Customer Service Representative Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Overview This comprehensive course on Touch Typing Essentials will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Touch Typing Essentials comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Touch Typing Essentials. It is available to all students, of all academic backgrounds. Requirements Our Touch Typing Essentials is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 26 lectures • 02:01:00 total length •Promo: 00:04:00 •Course Overview: 00:12:00 •Resource - Touch Typing Essentials: 00:00:00 •Understanding the Keyboard Layout: 00:03:00 •How to set up input languages - for Mac: 00:09:00 •How to set up input langauges - for Windows: 00:12:00 •How to correctly place your fingers on the keyboard: 00:07:00 •How to type the letters F and J: 00:04:00 •How to type the letters D and K: 00:04:00 •How to type the letters S and L: 00:03:00 •How to type the letter A and semicolon: 00:04:00 •How to type the letters E and I: 00:04:00 •How to type the letters R and U: 00:04:00 •How to type the letters T and O: 00:04:00 •How to type CAPITAL letters: 00:05:00 •How to type the letter C and , (Comma): 00:04:00 •How to type the letters G and H: 00:03:00 •How to type the letters N and V: 00:03:00 •How to type the letters W and M: 00:04:00 •How to type the letters Q and P: 00:04:00 •How to type the letters B and Y: 00:03:00 •How to type the letters Z and X: 00:04:00 •How to type Colon and Semicolon: 00:03:00 •How to type Full Stop and Comma: 00:03:00 •How to type Question Mark and Exclamation Mark: 00:04:00 •How to type Dash, Parentheses and Quotation Marks: 00:07:00

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Microsoft office is used for documentation, writing, and many other activities. It brings a new dimension to this technology-based competitive world. It has vivid functions and much more use. If you want to learn all its advanced functions, look at our Microsoft Office 2016 Advanced course. This course introduces to the function of ribbon that incorporates many tabs such as Insert, design, animation, slides, show, review, and home. It also guides you step by step how to insert a picture, change design lay order, add a hyperlink, watch video from youtube, create CV, cash memo, payment sleep, many more things. Overall the course teaches you all the efficient use of Microsoft Office to be expert in it. Who is this Course for? Microsoft Office 2016 Advanced is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Mock Exam Mock Exam - Microsoft Office 2016 Advanced 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Advanced 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Most of the standard white-collar jobs nowadays depend on the fastest skills and that most importantly includes the typing speed skill ranging from 35-200 words per minute. So, if you're facing problems with your typing speed and your job is highly dependent on that, we have the right solution for you in this Touch Typing Masterclass course. This Certificate in Touch Typing Masterclass course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 40 CPD points) to make your skill development & career progression more accessible than ever! Typing the wrong letters can be frustrating, especially when you're in a hurry. With the help of this touch typing course, you will be able to memorise the location of letters, numbers, and other characters on the keyboard. As a result, you will be able to type faster and more accurately. This touch typing course creates the ability for you to understand typing rules and how you should be placing your finger on the keyboard. Upon completing this touch typing course, you will develop the perception of proficiency in touch typing the alphabet, and how to type sentences of any length using signs, dash, and parenthesis. Moreover, you will be able to learn about keyboard shortcuts and many secrets for accelerating your typing speed. What will I learn from this Touching Typing Masterclass? Learn to touch-type in the most efficient way Correct placement of the hand on the keyboard How to type faster spelling accuracy Best way to practice capital letters Typing with all the fingers Typing without continuously referring to your keyboard This touch typing masterclass certificate will also help you to create an impression of self-reliance and dedication that will surely attract prospective employers to give priority to your job application. Enrol in this touch typing masterclass course today to open and build enchanting career opportunities ahead. Take a step toward a brighter future! Why Prefer this Touch Typing Masterclass Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPDQS Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. *** Course Curriculum *** Here is the curriculum breakdown of this course: *** Touch Typing Masterclass - Updated Version *** Module 1: Introduction Module 2: How to Set up Your Computer Module 3: How to type the letters F and J Module 4: How to type the letters D and K Module 5: How to type the letters S and L Module 6: How to type the letter A and ; (semicolon) Module 7: How to type the letters E and I Module 8: How to type the letters R and U Module 9: How to type the letters T and O Module 10: How to type CAPITAL letters Module 11: How to type the letter C and, (Comma) Module 12: How to type the letters G and H Module 13: How to type the letters N and V Module 14: How to type the letters W and M Module 15: How to type the letters Q and P Module 16: How to type the letters B and Y Module 17: How to type the letters Z and X Module 18: How to type Colon and Semicolon Module 19: How to type Full Stop and Comma Module 20: How to type Question Mark and Exclamation Mark Module 21: How to type Dash, Parentheses and Quotation Marks *** Touch Typing Masterclass - Old Version *** Module 1: Getting Started Module 2: DRILL 1 the home keys Module 3: DRILL 2 e and i, g and h Module 4: DRILL 3 o and n, shift keys and t Module 5: DRILL 4 extra practice . and y Module 6: DRILL 5, and w Module 7: DRILL 6 m and u Module 8: DRILL 7 v and x Module 9: DRILL 8-sentence drills Module 10: DRILL 9 figures Module 11: DRILL 10 alphabetical paragraphs Module 12: Recap Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Certificate in Touch Typing Masterclass exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? In the present era, typing is an essential skill for anyone who sees themselves working with a computer. Besides, this touch typing masterclass course is preferable for students, programmers, content writers, bloggers, researchers, and data entry operators. The touch typing masterclass course doesn't require any academic background and is open to everyone. HOW TO USE RESOURCES: To use the resources, just download them and open them using a browser. You can use Google Chrome to open them, but Safari or any other browser can also be used. Just make sure to enable javascript in the browsers for the automatic correction/ highlights. Requirements You will not need any prior background or expertise to enrol in this course. Career path Enroling on this Touch Typing Masterclass can lead to the following career paths: Data Entry Operator Customer Service Executives Email Marketing Executives Personal Assistant Administrative Executive And many more office job roles requiring you to type fast! Certificates CPDQS Accredited Certificate Digital certificate - £10 Certificate in Touch Typing Masterclass at QLS Level 1 Hard copy certificate - £59 Show off Your New Skills with a Certification of Completion After successfully completing the Certificate in Touch Typing Masterclass at QLS Level 1, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 59 GBP inside the UK 69 GBP (including postal fees) for international delivery CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)