3414 Office Skills & Productivity courses in Bradford delivered Online

Level 5 Diploma(FREE QLS Endorsed Certificate)| 11 CPD Courses+11 PDF Certificates| 145 CPD Points|CPD & CiQ Accredited

This Diploma in Office Admin and Legal Secretary Skills course is especially suitable for Secretaries and Administrators enthusiastic to work within a legal environment. Throughout the course, you will be introduced to the techniques of becoming a good and efficient Legal Secretary. The course teaches you the fundamentals of the legal system including general duties of a legal secretary, managing meetings, keeping records with a different filing system, developing research skills, managing transcription for judges, etc. You will also learn tips for customer service and how to organize work using Microsoft Word. Finally, the course shows you how the legal system works the courts of the UK including Scotland and Northern Ireland. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Diploma in Office Admin and Legal Secretary Skills has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Diploma in Office Admin and Legal Secretary Skills is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at any time. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification 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. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £22,100. The sky really is the limit. Course Curriculum Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Training for Administrator - Activities 00:00:00 Legal Secretary Introduction to Legal Secretary 00:15:00 Role of Legal Secretaries 00:15:00 General Duties and Day-to-Day Operations of a Legal Secretary 00:30:00 Record Keeping 00:30:00 Legal Writing Skills & Proofreading 00:15:00 Research Skills You Need to Know 00:30:00 Transcription, Editing & Correspondence to Judges 00:30:00 Legal System of UK 00:15:00 UK Court System 00:30:00 Meeting Management & Minute Taking Skills Meeting Management 00:15:00 The Role of a Minute-Taker 00:15:00 The Skills of a Minute-Taker 00:30:00 Meeting Agreements 00:15:00 Minute Styles 00:30:00 What Do I Record? 00:30:00 Techniques for Preparing Minutes 00:30:00 The Minute Book 00:15:00 What to include/what to ignore 00:30:00 Motions and Resolutions 00:15:00 Method of recording minutes 00:30:00 Reasons for Meeting 00:30:00 What is a decision? 00:15:00 Minute Taking tips 00:30:00 **Customer Service Role and Telephone Etiquette** Understanding Customer Service Understanding Customer Service 00:17:00 Identifying Customer Expectations 00:06:00 Providing Excellent Customer Service 00:07:00 Focusing on the Customer Focusing on the Customer 00:08:00 Customer Service and the Telephone Customer Service and the Telephone 00:08:00 Handling Complaints Handling Complaints 00:12:00 Enduring Stress Enduring Stress 00:13:00 Business Communication Identifying Basic Communication Techniques 00:09:00 Formal and Informal Communication 00:02:00 Verbal and Non-verbal Communication Describing Verbal and Non-verbal Communication 00:04:00 Understanding Body Language 00:05:00 Making Effective Presentations 00:10:00 Fundamentals of Productive Meetings 00:08:00 Written Communication Written Communication 00:13:00 Electronic Communication Electronic Communication 00:19:00 Communicating with Graphics Creating Graphics for Business Communication 00:04:00 Communicating Static Information 00:03:00 Communicating Dynamic Information 00:03:00 Effectively Working for Your Boss Representing Your Boss 00:06:00 Communicating Your Boss's Decisions 00:03:00 Supporting Your Boss and Colleagues 00:04:00 Building a Partnership with Your Boss 00:13:00 Identifying Goals Identifying Goals 00:10:00 Effective Energy Distribution Energy Distribution 00:09:00 Time Logs 00:11:00 Working with Your Personal Style Personal World View 00:10:00 Strengths 00:09:00 Building Your Toolbox A Building Your Toolbox 00:10:00 Establishing Your Action Plan Establishing Your Action Plan 00:11:00 **Organizing Work Using MS Word** Getting Started with Microsoft Word Understanding the Word Interface 00:05:00 Using the Backstage View 00:07:00 Opening Documents 00:02:00 Navigating Documents 00:04:00 Viewing Documents 00:04:00 Creating Documents 00:03:00 Entering Text 00:02:00 Selecting Text 00:03:00 Saving Documents 00:03:00 Checking Document Compatability 00:02:00 Converting to Updated File Format 00:02:00 Saving As a Different File Format 00:02:00 Understanding Document Properties 00:03:00 Using Versions 00:04:00

Highlights of the Course Course Type: Online Learning Duration: 2 hours 1 minute 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 touch typing Understand the core competencies and principles of touch typing Explore the various areas of touch typing Know how to apply the skills you acquired from this course in a real-life context Become a confident and touch typist Touch Typing Training Masterclass Program Course Master the skills you need to propel your career forward in touch typing. This course will equip you with the essential knowledge and skillset that will make you a confident touch typist and take your career to the next level. This comprehensive touch typing training masterclass program course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this touch typing training masterclass program 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 touch typing practice and equip you with the essential skills, confidence and competence to assist you in the touch typing industry. You'll gain a solid understanding of the core competencies required to drive a successful career in touch typing. 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 touch typist or for people who are aspiring to specialise in touch typing. Enrol in this touch typing training masterclass program 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 touch typing training masterclass program 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 touch typing 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 touch typing training masterclass program 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 touch typing training masterclass program 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 touch typing training masterclass program 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 Introduction Master Touch Typing Promo 00:01:00 Reminder! This Is a Real Course with Real Instructor Ready to Answer Questions 00:22:00 Your Facebook Support Community 00:01:00 Master at Touch Typing Quick Win - Focus on Accuracy to Get Speed 00:01:00 Another Quick - Have Straight Arm and Hand 00:01:00 Touch Typing Cycles Rules, Speed Improvement and Maintenance 00:02:00 Understand Your WPM Now and Type in Q&A 00:01:00 Reasons You Learn Touch Typing 00:02:00 One Language at A Time for Learning Touch Typing 00:02:00 Understand Your Whys of Touch Typing 00:02:00 You Have to Look the Text Not Keyboard 00:02:00 Have Proper Posture While Typing 00:02:00 Pick up The Correct Fingers 00:01:00 Correct Backspacing 00:01:00 Tap on The Keys 00:01:00 More Accuracy More Speed 00:02:00 Big Challenge - Listen and Type 00:02:00 Summary of All Touch Typing Tips 00:11:00 Learn Which Fingers Go Where In Touch Typing (With Google Classroom Practice) Welcome to Touch Typing Journey 00:01:00 Guides You How To Place Your Hands 00:01:00 Place Your Hands Better on Keyboard and Avoid 00:02:00 Typing of 1QAZ 00:04:00 Spacebar Guide 00:01:00 Typing of 2WSX 00:02:00 Typing of 3EDC 00:01:00 Typing of 4RFV 00:01:00 Typing of 5TGB 00:01:00 Typing of YHN 00:02:00 Typing of UJM 00:01:00 Typing of 8IK, 00:01:00 Typing of 9OL. 00:01:00 Typing of 0p; 00:01:00 Important Remainder of Keyboard View 00:01:00 Reasons of Having Two Shift, Alt, and Ctrl Button 00:01:00 How You Can Join Your Google Classroom 00:03:00 Applications That Can Help You To Become Master At Touch Typing Rapid Typing Installation 00:03:00 Rapid Typing Configuration 00:02:00 Rapid Typing Part 1 00:06:00 Rapid Typing Part 2 00:04:00 Typing of The Dead 00:09:00 Mavis Beacon Teaches Typing 00:04:00 KeyBlaze Touch Typing Software 00:05:00 Typing Master 00:06:00 Online Touch Typing 00:05:00 Important Things You Need to Know About Touch Typing 00:03:00 Important Things You Need to Know About Touch Typing Same Rules Are Applied for Phone Touch Typing! 00:09:00 Conclusion You Are Now Master of Touch Typing 00:01:00 Supplementary Resources Supplementary Resources - The Complete Touch Typing Masterclass: Master Touch Typing 00:00: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

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now! Why is Microsoft important in the workplace? From project management to office coordination, having a stronger command of Microsoft Word, Excel, PowerPoint, Teams, Power BI, OneDrive, and other programmes will benefit your organisation and your work. Also, Microsoft skills can make your work life so much easier that you can complete your tasks in minutes that would take others hours. So enhance your skills and become that go-to guy everyone envies. Industry experts have developed this bundle, which has already helped many learners like you. So, If you want to learn how to use the most popular Microsoft tools, you don't need to look any further than this bundle. This bundle is the only thing you need to go from a complete novice to a skilled Microsoft user. So, enrol in this all-in-one bundle and start learning today. Along with this course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This 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: New Functions in Microsoft Excel 2021 Course 08: Complete Microsoft Power BI 2021 Course 09: Microsoft Teams Course 10: Outlook Tips and tricks Course 11: Touch Typing Essentials How will I get my Certificate? After successfully completing the Course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our course is suitable for all. Requirements This course has no prior requirements. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Office Administrator PA Secretary Office Worker Manager And much more... Certificates Certificate of completion Digital certificate - Included

Give a compliment to your career and take it to the next level. This Master Microsoft Office Beginner to Advanced will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Master Microsoft Office Beginner to Advancedbundle will help you stay ahead of the pack. Throughout the Master Microsoft Office Beginner to Advanced programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Master Microsoft Office Beginner to Advanced course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Master Microsoft Office Beginner to Advanced Bundle Consists of the following Premium courses: Course 01: Level 2 Microsoft Office Essentials Course 02: MS Word Diploma Course 03: Advanced Diploma in MS Excel Course 04: 50 Tips to Upgrade your Excel Skill Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Data Analysis in Microsoft Excel Complete Training Course 09: The Complete Microsoft Outlook Masterclass Course 10: Complete Microsoft Power BI 2021 Course 11: Microsoft Teams Enrol now in Master Microsoft Office Beginner to Advanced bundle to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Master Microsoft Office Beginner to Advanced expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Master Microsoft Office Beginner to Advanced bundle. Requirements This Master Microsoft Office Beginner to Advanced course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 2 Microsoft Office Essentials) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now! Microsoft Office is the most widely used tool for sharing/presenting professional information by a considerable number of companies in the world. Microsoft Office's benefits to business productivity are so crucial that all professionals today are required to be experts in it. Also, Microsoft Office skills can make your work life so much easier that you can complete your tasks in minutes that would take others hours. So enhance your skills and become that go-to guy that everyone envies with our comprehensive Microsoft Office Specialist (MOS) bundle. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Microsoft Office Specialist (MOS) bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand course that will enhance your skills and prepare you for the competitive Microsoft Office Specialist (MOS) job market. Also, our experts are available for answering your queries on Microsoft Office Specialist (MOS) and help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office Specialist (MOS) courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in MOS, 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 Office Specialist (MOS) Bundle Consists of the following Premium courses: Course 01: Advanced Diploma in MS Excel Course 02: MS Word Diploma Course 03: PowerPoint Diploma Course 04: 50 Tips to Upgrade your Excel Skill Course 05: New Functions in Microsoft Excel 2021 Course 06: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Excel Sheet Comparison with VBA Course 08: Master Power Query in 120 Minutes! Course 09: Data Analysis in Excel Complete Training Course 10: The Complete Outlook Masterclass Course 11: Complete Power BI 2021 Course 12: Microsoft Teams Course 13: Windows 10 Pro Complete Training Course 14: GDPR Data Protection Level 5 Enrol now in Microsoft Office Specialist (MOS) to advance your career, and use the premium study materials from Apex Learning. Curriculum Course 01: Advanced Diploma in MS Excel Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Excel VBA Data Management How will I get my Certificate? After successfully completing the Microsoft Office Specialist (MOS) course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course ) Hard Copy Certificate: Free (For The Title Course) CPD 155 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is for all. Requirements This bundle has no requirements. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that 97% of UK businesses use Microsoft Office? Mastering Microsoft Word is a valuable skill for almost any job role. Do you struggle with formatting documents, creating professional layouts, or using mail merge? This comprehensive Complete Microsoft Word bundle can help! This complete Microsoft Word bundle offers a variety of courses designed to take you from beginner to expert. Learn the fundamentals of creating, editing, and formatting documents. Discover advanced features like tables, mail merge, macros, and more. Beyond Word, the bundle includes additional courses on Excel, PowerPoint, Microsoft Teams, and Outlook, giving you a well-rounded skillset for office productivity. Our Microsoft Office Bundle Course contains 10 of our popular courses for one discounted price: Course 01: Learn Microsoft Word, PowerPoint & Outlook Course 02: Complete Microsoft Word Course 03: Microsoft Excel Complete Course Course 04: PowerPoint Course 05: The Ultimate Microsoft Teams Complete Training Bundle (2020) Course 06: Microsoft Outlook Advanced Course Course 07: Excel Training: Depreciation Accounting Course 08: Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Learn from relevant industry professionals and quickly equip yourself with the specific knowledge and skills needed to excel in your chosen career through the Microsoft Office bundle training. Expand your expertise with high-quality training - study the Microsoft Office course and get an expertly designed training experience. Learning Outcomes of Complete Microsoft Word Create professional documents with effective formatting. Utilise tables, charts, and graphics to enhance communication. Automate tasks with formulas and macros (Excel). Collaborate seamlessly with colleagues using Microsoft Teams. Manage emails efficiently with advanced Outlook features. Develop presentations that engage and inform your audience (PowerPoint). You'll get a Free Student ID card by enrolling in this Bundle course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling on the Bundle will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Bundle Course. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Microsoft Word Get a free student ID card with Microsoft Word Training program (£10 postal charge will be applicable for international delivery) The Microsoft Word is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Microsoft Word course materials The Microsoft Word comes with 24/7 tutor support Start your learning journey straight away with this Bundle course and take a step toward a brighter future! ****Course Curriculum**** Course 01: Learn Microsoft Word, PowerPoint & Outlook Microsoft Word Essentials New Word Document and Templates Tabs, Ribbons and Groups Zoom and Rulers in Word Editing the Word Document Insert Pictures with Word Insert Shape and Text Box in Word Review Tab in Word Layout in Word File Options in Word Closing and Reopening in Word Course 02: Complete Microsoft Word Manipulating Images Integrate Pictures and Text Adjust Image Appearance Insert Other Media Elements Using Custom Graphic Elements Create Text Boxes and Pull Quotes Add WordArt and Other Text Effects Draw Shapes Create Complex Illustrations with SmartArt Collaborating on Documents Prepare a Document for Collaboration Mark Up a Document Review Markups Merge Changes from Other Documents Adding Document References and Links Add Captions Add Cross References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Securing a Document Suppress Information Set Formatting and Editing Restrictions Restrict Document Access Add a Digital Signature to a Document Using Forms to Manage Content Create Forms Modify Forms Automating Repetitive Tasks with Macros Automate Tasks by Using Macros Create a Macro Course 03: Microsoft Excel Complete Course Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Excel Templates Excel Templates =========>>>>> And 5 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*8 = £103) CPD Hard Copy Certificate: £29.99 CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Students Graduates Admin Staff Business Professionals Entrepreneurs Freelancers Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Office Manager Virtual Assistant Data Analyst Project Manager Marketing Specialist Business Analyst Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

The Office 365 Collaborating in Office 365 course focuses on giving you the relevant knowledge on how to collaborate with others in Office 365. You'll learn how to make a plan in Planner, and an app in Office 365. In addition to that, learn how to create and share a document, as well as create a SharePoint library. Explore the idea to use the Office 365 apps on a mobile device, and how to co-author documents. The course also instructs you to manage an Outlook group, following with OneNote, Skype, and Delve to locate documents. Last but not the least, improve the efficiency to collaborate using Yammer and Teams. The knowledge acquired from the course makes sure you've got the skills required to succeed in today's rapidly developing workplace. What Will I Learn? Use the various apps of Office 365 to collaborate with others. Requirements Familiarity with Microsoft Office Applications and using the Internet. Introduction Introduction FREE 00:02:00 Using Office 365 for Collaboration Overview FREE 00:03:00 Creating a Plan 00:07:00 Creating and Sharing a Document 00:05:00 Creating a Library 00:08:00 Using Office 365 on a Mobile Device 00:05:00 Co-Authoring in Office 00:05:00 Using an Outlook Group to Get Feedback 00:08:00 Meeting and Collaborating in Skype and OneNote 00:08:00 Using Delve 00:05:00 Getting Feedback Through Yammer 00:07:00 Using Teams 00:06:00 Conclusion Course Recap 00:02:00 Course Certification

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Description Learn the advanced features of Google G Suit with the Google G Suite Connect and Access course. Google G Suite is the productivity and collaboration tool that is comprised of Google Drive, Google Docs, Slides, Sheets, Gmail, Calendar, Forms, Google Hangouts, Google Plus, and more. The course is split into five sections that show you how to use the five applications of Google G Suit such as Gmail, Google Calendar, Google Forms, Google Hangouts, and Google Plus. At first, you will master how to receive, send and manage the email service of Google. Then, the course shows you how to manage your schedule on Google Calendar. Next, you will know how to create and manage forms by using Google Forms. After that, the course teaches you how to communicate effectively by using Google Hangouts. Finally, the course illustrates the techniques of using the social media platform of Google and helps you to manage your social presence with Google Plus. 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? Google G Suite Connect and Access 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 Google G Suite Connect and Access 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. Lesson 1: Google Gmail TOPIC A Getting Started with Gmail 00:15:00 TOPIC B Sending, Reading, and Replying to Messages 00:15:00 TOPIC C Organizing and Searching Mail 00:15:00 TOPIC D Managing Your Contacts 00:15:00 Lesson 2: Google Calendar TOPIC A Getting Started with Google Calendar 00:15:00 TOPIC B Create and Manage Events 00:15:00 TOPIC C Create Additional Calendars 00:15:00 TOPIC D Sharing Your Calendar 00:15:00 Lesson 3: Google Forms TOPIC A Getting Started with Google Forms 00:15:00 TOPIC B Build Forms 00:15:00 TOPIC C Work with Responses 00:15:00 Lesson 4: Google Hangouts TOPIC A Overview 00:15:00 TOPIC B Messaging and Text Hangouts 00:15:00 TOPIC C Video and Phone Hangouts 00:15:00 TOPIC D Hangouts Chat 00:15:00 Lesson 5: Google Plus TOPIC A Getting Started with Google Plus 00:15:00 TOPIC B Create and Optimize Your Profile 00:15:00 TOPIC C Creating Posts 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00