6092 Productivity 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 Organizing Content Using Tables and Charts Work with Tables - Introduction 00:01:00 Sort Table Data 00:04:00 Control Cell Layout 00:05:00 Perform Calculations in a Table 00:06:00 Add an Excel Table to a Word Document 00:05:00 Work with Charts - Introduction 00:01:00 Create a Chart 00:06:00 Customizing Formats Using Styles and Themes Create and Modify Text Styles - Introduction 00:01:00 Create and Modify Text Styles 00:07:00 Create Custom Lists or Table Styles - Introduction 00:01:00 Create Custom Lists or Table Styles 00:04:00 Apply Document Themes - Introduction 00:01:00 Apply Document Themes 00:03:00 Inserting Content Using Quick Parts Automate Adding Text with Building Blocks - Introduction 00:01:00 Insert Building Blocks 00:06:00 Create and Modify Building Blocks 00:06:00 Inserts Fields Using Quick Parts - Introduction 00:01:00 Insert Fields Using Quick Parts 00:05:00 Using Templates to Automate Document Formatting Using Templates to Automate Document Formatting - Introduction 00:01:00 Create a Document Using a Template 00:04:00 Create a Template 00:04:00 Modify a Template 00:03:00 Manage Templates with the Template Organizer 00:03:00 Controlling the Flow of a Document Control the Flow of a Document - Introduction 00:01:00 Control Paragraph Flow 00:03:00 Insert Section Breaks 00:04:00 Insert Columns 00:03:00 Link Text Boxes to Control Text Flow 00:05:00 Simplifying and Managing Long Documents Simplify and Manage Long Documents - Introduction 00:01:00 Insert Blank and Cover Pages 00:03:00 Insert an Index 00:05:00 Insert a Table of Contents 00:04:00 Insert a Table of Figures 00:03:00 Work with Table of Authorities 00:04:00 Manage Outlines - Introductions 00:01:00 Manage Outlines 00:07:00 Create a Master Document - Introduction 00:01:00 Working with Master Documents 00:05:00 Using Mail Merge to Create Letters, Envelopes and Label Mail Merge - Introduction 00:01:00 Prepare for a Mail Merge 00:05:00 Perform a Mail Merge 00:07:00 Bonus Lecture 00:01: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

Highlights of the Course Course Type: Online Learning Duration: 3 Hours 5 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Word Understand the core competencies and principles of Microsoft Word Explore the various areas of Microsoft Word Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Office Word 2016: Part 3 (Advanced) Training Course Master the skills you need to propel your career forward in Microsoft Word. 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 Office Word advanced course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Office Word advanced 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 Word practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Word industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Word. 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 Word. Enrol in this Microsoft Office Word advanced 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 Office Word advanced 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 Word 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 Office Word advanced 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 Office Word advanced 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 Office Word advanced course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Manipulating Images Manipulate Images - Introduction 00:01:00 Integrate Pictures and Text 00:08:00 Adjust Image Appearance 00:06:00 Compress Pictures 00:03:00 Insert Other Media Elements - Introduction 00:01:00 Insert Other Media Elements 00:06:00 Using Custom Graphic Elements Use Custom Graphic Elements - Introduction 00:00:00 Create Text Boxes and Pull Quotes 00:05:00 Add WordArt and Other Text Effects 00:07:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt - Introduction 00:01:00 Create Complex Illustrations with SmartArt 00:05:00 Collaborating on Documents Collaborate on Documents - Introduction 00:02:00 Prepare a Document for Collaboration - Part 1 00:06:00 Prepare a Document for Collaboration - Part 2 00:07:00 Mark Up a Document Part 1 00:04:00 Mark Up a Document - Part 2 00:06:00 Merge Changes from Other Documents - Introduction 00:01:00 Merge Changes from Other Documents 00:05:00 Adding Document References and Links Add Document References and Links - Introduction 00:01:00 Add Captions 00:04:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:04:00 Insert Footnotes and Endnotes 00:06:00 Add Citations 00:09:00 Add a Bibliography 00:04:00 Securing a Document Secure a Document - Introduction 00:01:00 Suppress Sensitive Information 00:06:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:04:00 Add a Digital Signature to a Document - Introduction 00:01:00 Add a Digital Signature to a Document 00:08:00 Using Forms to Manage Content Use Forms to Manage Content - Introduction 00:01:00 Create Forms 00:08:00 Automating Repetitive Tasks with Macros Automate Repetitive Tasks with Macros - Introduction 00:01:00 Automate Tasks by Using Macros 00:04:00 Identify Word Macro Uses and Concerns - Introduction 00:01:00 Identify Word Macro Uses and Concerns 00:04:00 Create a Macro - Introduction 00:01:00 View the Code for an Existing Macro 00:06:00 Record a Macro 00:05:00 Add Custom Code to a Recorded Macro 00:10:00 Course Follow-Up 00:01: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

Description: Corel Quattro Pro X3 is a spreadsheet program; it is practically designed for storing, calculating and analyzing massive amount of data in an efficient way. In this {course_title] you will learn the basic concepts that revolves around this program. Spreadsheet applications are essential for running any office work. In this course, you will start off with an introduction in the basic functions and interactions with the program. After learning the basics, you will categorically move up through the hierarchy to advanced levels. This course will sharpen your skills and help you in the professional field. Learning Outcomes: Review common spreadsheet applications, opening and closing the spreadsheet application Creating a blank spreadsheet, entering, editing and deleting data Creating a spreadsheet from a template, saving it multiple times, changing default directory, opening and closing the program, and switching between open spreadsheets Utilizing the editing tools like select, undo, cut, copy, changing cell dimensions, sort and other related options Using zoom, showing and hiding toolbars, locking and unlocking rows and columns, changing basic options Inserting, naming, deleing, moving and copying worksheets Creating basic formulas, identifying errors, using cell referencing, advanced formulas and IF functions Formatting cells to include decimals, commas, date, currency, percentage; while also changing font size, type and adding effects More formatting options through quick format, text wrapping, aligning cell contents, centring titles, modifying cell orientation and applying borders and shading Creating a chart and changing its titles, background colour, and colour of other chart elements; also find out how to edit charts through the cut, copy, paste, resize, move and delete options Setting up worksheet by modifying margins, orientation, paper size and fitting the worksheet into a page How to prepare to print and carry out the printing job by creating header and footers and using print preview respectively, and explore many other related options 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? Corel Quattro Pro X3 Application 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 Corel Quattro Pro X3 Application 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. Spreadsheet Basics Getting Started 01:00:00 Creating a Spreadsheet 00:15:00 Working with Files 01:00:00 Editing Tools Part 1 00:15:00 Editing Tools, Part 2 01:00:00 Viewing Tools 00:30:00 Working With Spreadsheets Working with Worksheets 00:15:00 Working With Formulas 00:30:00 Formatting Cells 00:15:00 Advanced Formatting 00:30:00 Advanced Spreadsheet Tasks Creating a Basic Chart 01:00:00 Editing Charts 00:15:00 Setting up the Worksheet 00:15:00 Preparing to Print 00:30:00 Printing the Worksheet 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Welcome to the Microsoft Outlook 2010 Expert Workshop. Prepare yourself to put your communication tools into high gear. The Microsoft Outlook 2010 Expert Workshop will help you customise the Outlook interface so that it works best for you. It includes how to use the tools to organise your data and allow for smaller backup files. Understand how to control your messages which are being sent, forwarded, and stored. Through this course, you will learn how to use styles, themes, and formatted graphics to enhance your messages. Who is the course for? Professionals who want to learn about Microsoft functions and features. People who have an interest in knowing advanced Microsoft Outlook features. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy 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 recognised 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: The Microsoft Outlook 2010 Intermediate Level will be very beneficial and helpful, especially to the following professionals: Business IT Admin Secretary Project Management Microsoft Outlook 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with the Outlook Environment 01:00:00 Module Three - Printing 01:00:00 Module Four - Working with Quick Steps 01:00:00 Module Five - Working with Messages 01:00:00 Module Six - Manipulating Message Properties and Options 01:00:00 Module Seven - Formatting Messages 01:00:00 Module Eight - Managing Automatic Content 01:00:00 Module Nine - Working with the Calendar, Appointments, and Meetings 01:00:00 Module Ten - Working with Contacts and Contact Groups 01:00:00 Module Eleven - Working with Tasks and the Journal 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Outlook 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Outlook 2010 Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Outlook 2010 Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

4 in 1 Receptionist: Reception Bundle Improve your knowledge and enhance your skills to succeed with this Receptionist: Reception bundle. This Receptionist: Reception bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This Receptionist: Reception Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Hotel Receptionist Course Course 02: Hotel Management with Hotel Receptionist and Hospitality Management Course 03: Professional Telephone Receptionist Course Course 04: Office Admin and Receptionist Skills All the courses under this Receptionist: Reception bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the Receptionist: Reception bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive Receptionist: Reception bundle, you can achieve your dreams and train for your ideal career. This Receptionist: Reception bundle covers essential aspects in order to progress in your chosen career. Why Prefer Us? All-in-one package of 4 premium courses' Receptionist: Reception bundle Earn a certificate accredited by Get a free student ID card! (£10 postal charge will be applicable for international delivery) Globally Accepted Standard Lesson Planning Free Assessments 24/7 Tutor Support. Start your learning journey straightaway! ****Course Curriculum**** Course 01: Hotel Receptionist Course Module 1: Introduction to Reception and Receptionist Module 02: An Overview of Hotel Industry Module 03: The Process of Selection and Recruitment in Hospitality Industry Module 04: Management of Front Office Operations Module 05: Business Telephone Skills Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Time Management Module 09: Record Keeping and Filing Systems Module 10: Communication Skills Module 11: Marketing in Travel and Tourism Business Module 12: Customer Satisfaction Module 13: E-Hospitality and Technology Assessment Process Once you have completed all the modules in this Bundle course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 45 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Receptionist : Reception bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Receptionist : Reception bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard Copy certificate for each of the courses inside this bundle as proof. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Enhance your receptionist skills with this comprehensive diploma course. Delve into various modules covering essential aspects of reception and office management. Learn business telephone etiquette, travel arrangement skills, time management, and effective communication. Acquire advanced MS Excel proficiency for data management. From customer service to business writing, this course equips you with the knowledge and skills needed to excel as a receptionist. Learning Outcomes: Master essential receptionist duties and etiquette. Develop effective business telephone skills. Learn to represent your employer and company professionally. Gain proficiency in mail services, shipping, and travel arrangements. Enhance time management and organizational skills. Strengthen communication and customer service abilities. Acquire proficiency in Microsoft Excel, from text and mathematical formulas to advanced functions. Learn Power Query and Excel keyboard shortcuts for efficient data management. Why buy this Receptionist Diploma?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Receptionist Diploma you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Receptionist Diploma course is ideal for Aspiring receptionists seeking comprehensive training. Office professionals looking to enhance their skills. Individuals aiming to excel in administrative roles. Those interested in improving their Microsoft Excel proficiency. Prerequisites This Receptionist Diploma was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Receptionist - Average Salary: £18,000 - £25,000 per year. Administrative Assistant - Average Salary: £18,000 - £25,000 per year. Office Coordinator - Average Salary: £20,000 - £28,000 per year. Customer Service Representative - Average Salary: £18,000 - £25,000 per year. Data Entry Clerk - Average Salary: £18,000 - £25,000 per year. Course Curriculum Receptionist Diploma Module 1: Introduction to Reception and Receptionist 00:11:00 Module 2: Business Telephone Skills 00:19:00 Module 3: Representing Your Boss and Company 00:34:00 Module 4: Mail Services and Shipping 00:25:00 Module 5: Travel Arrangements 00:24:00 Module 6: Organising Meeting and Conferences 00:25:00 Module 7: Time Management 00:35:00 Module 8: Record Keeping and Filing Systems 00:28:00 Module 9: Business Writing Skills 00:40:00 Module 10: Organisational Skills 00:25:00 Module 11: Communication Skills 00:25:00 Module 12: Customer Service 00:16:00 Module 13: Effective Planning and Scheduling 00:46:00 Module 14: Invoicing/Petty Cash 00:27:00 Module 15: Business Environment 00:19:00 Advanced MS Excel How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:08:00 Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Office Admin and Reception 00:20:00 Final Exam Final Exam - Office Admin and Reception 00:20:00

Description: InfoPath is a powerful program created for collecting data from users on a variety of platforms. In this course, you will learn the advanced skills, knowledge, and information about the advanced functions and features of Microsoft InfoPath 2007. Explore how different types of controls are used to achieve your desired effect. Appreciate plenty of programming options for extending the uses and features of InfoPath that you can learn. Who is the course for? Professionals who want to learn about the Microsoft InfoPath 2007 People who have an interest in the advanced features of Microsoft InfoPath 2007 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 recognised 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: The Microsoft InfoPath 2007 Advanced course is a useful qualification to possess and would be beneficial for any type of professions or career from any type of industry you are in such as: Administrative Assistant Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Senior Manager. Microsoft InfoPath 2007 Advanced Module One - Getting Started 00:30:00 Module Two - Types of Controls 01:00:00 Module Three - Repeating and Optional Controls 01:00:00 Module Four - Actions 01:00:00 Module Five - Importing Form Designs 01:00:00 Module Six - Advanced Topics 01:00:00 Module Seven - Custom Task Panes 01:00:00 Module Eight - Understanding Code 01:00:00 Module Nine - Publishing Forms 01:00:00 Module Ten - SharePoint Integration 01:00:00 Module Eleven - Publishing Forms for Use with SharePoint 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft InfoPath 2007 Advanced 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Outlook is helpful software to professionals since it has all the tools and functionality you need for your career. Outlook is created with new and improved features as compared to its previous versions. Through this course, you will learn how to use the new functions and features of Outlook. Learn about professional emails, calendar, contacts, and task management effectively. These features will help you communicate faster and easier to your colleagues, clients or anyone you need to communicate with professionally.In this course you will learn the necessary skills, knowledge and information of Microsoft Outlook. Who is the course for? Professionals or experts who want to learn more about Outlook new features. People who have an interest in knowing Microsoft Outlook new functions and tools. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 recognised 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: The Microsoft Outlook Intermediate Level course is a useful qualification to possess and would be beneficial for any professions or career industry you are in. Microsoft Outlook Intermediate Level Module One - Getting Started 01:00:00 Module Two - Working with the Outlook Environment 01:00:00 Module Three - Working with Quick Steps 01:00:00 Module Four - Working with Rules 01:00:00 Module Five - Working with Messages 01:00:00 Module Six - Manipulating Message Properties and Options 01:00:00 Module Seven - Formatting Messages 01:00:00 Module Eight - Managing Automatic Content 01:00:00 Module Nine - Working with the Calendar, Appointments, and Meetings 01:00:00 Module Ten - Working with Contacts and Contact Groups 01:00:00 Module Eleven - Working with Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Outlook Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Outlook Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Outlook Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview of Office 365 End User Join our Office 365 End User course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Office 365 End User course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Office 365 End User course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This Office 365 End User Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Office 365 End User. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Office 365 End User course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Office 365 End User is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Office 365 End User course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Office 365 End User Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Office 365 End User Module 01: Introduction to Office 365 00:57:00 Module 02: Email, Contacts & Calendar 00:55:00 Module 03: Teams- OneDrive 01:10:00