683 Courses

Microsoft Office 2016 Complete Course Over 80% of UK job listings require proficiency in Microsoft Office. Enhancing your skills in Office 2016 can increase your employability and pave the way for career advancement. Dive into the essentials of Microsoft Office 2016 with our comprehensive course designed for beginners. Whether you're new to Office or looking to refresh your skills, this course offers a deep dive into Word, Excel, PowerPoint, Outlook, and Access.  Structured in five detailed modules, each section of this Microsoft Office course is dedicated to maximising your proficiency in one of these critical Office components. Embark on a journey from the basics to more advanced features, with each module carefully crafted to build your skills step-by-step. Through 30-minute focused lessons and hands-on activities, you'll gain confidence in navigating interfaces, creating compelling documents, analysing data, and much more. Enhance your skillset, boost your productivity, and open doors to new career opportunities with our Microsoft Office 2016 Complete Course for Beginners. Enrol now and take the first step towards mastering Microsoft Office 2016! What Will You Learn? Navigating and customising the interface for each Office application. Creating, formatting, and managing documents in Word. Building spreadsheets, using formulas, and analysing data in Excel. Designing impactful presentations with PowerPoint. Managing emails effectively and organising your schedule in Outlook. Developing and managing databases in Access. Enhancing your productivity with Office 2016's comprehensive tools. Practical skills through guided activities and real-world scenarios. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

Microsoft Office 2016 Essentials is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Office 2016 Essentials and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 17 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel 2016 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: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 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09: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:06:00 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:05:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00

***Don't Spend More; Spend Smart*** Life Just Got Better This Summer! Save Up To £5,206 and get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Employability Skills and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Employability Skills bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Employability Skills course that will enhance your skills and prepare you for the competitive job market. Also, our Employability Skills experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these 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 Employability Skills, 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 Employability Skills Bundle Consists of the following Premium courses: Course 01: Diploma in Becoming Career Smart Course 02: Interpersonal Skills in Management Course 03: Leadership and Management Training Course Course 04: Assertiveness and Self Confidence Development Course 05: Personal and Networking Skills Course 06: Cross-Cultural Awareness Training Course 07: Business English Perfection Course Course 08: Level 2 Microsoft Office Essentials Course 09: Office Skills and Administration Management Diploma Course 10: Decision Making and Critical Thinking Course 11: People Management Skills Level 3 Course 12: Workplace Confidentiality Course 13: UK Employment Law and Employee Rights Diploma Course 14: Performance Management Benefits you'll get choosing Apex Learning for this Employability Skills: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills 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 (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Employability Skills Bundle Course 01: Diploma in Becoming Career Smart Understanding the Talk Getting Prepared to Make the Call Creative Openings Making Your Pitch Handling Objections Sealing the Deal Following Up Setting Goals Managing Your Data Using a Prospect Board Course 02: Interpersonal Skills in Management What are Soft Skills? Communication Teamwork Problem-Solving Time Management Attitude and Work Ethic Adaptability/Flexibility Self-Confidence (Owning It) Ability to Learn From Networking Employee Relations Motivation and Counselling Course 03: Personal Leadership and Influencing Skills Getting Started The Evolution of Leadership Situational Leadership A Personal Inventory Modelling the Way Inspiring a Shared Vision Challenging the Process Enabling Others to Act Encouraging the Heart Basic Influencing Skills Setting Goals Course 04: Assertiveness and Self Confidence Development Self Confidence Introduction Ways to Find Yourself Positive Mindset vs Negative Mindset Do it, Feel it and Achieve it Believe it and Achieve it ESTEEM SELF ANALYSIS STILL STRUGGLING TO FIND AND TO BE CONFIDENT Course 05: Personal and Networking Skills Why Is Networking Powerful? Networking Paradigm Shifts You've Got To GIVE To GET The Power Of 'Likeability' Making The Connection Great Places To Network The Power Of Mentors Course 06: Cross-Cultural Awareness Training Introduction to Cross-Cultural Awareness Cross-Cultural Communication Corporate Cross-Cultural Awareness Cross-Cultural Design Cross-Cultural Competency Cultural Values Working with and Managing a Culturally Diverse Team Course 07: Business English Perfection Course Introduction Greetings Management Speak Debate Applying for a Job Job Interviews Emails Recap Course 08: Level 2 Microsoft Office Essentials Excel 2016 Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Word 2016 Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Workbooks - Microsoft Word 2016 (Beginner) PowerPoint 2016 PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentatin Access 2016 Introduction to Access Modify Data Working with Queries Access Forms Working with Reports Course 09: Workplace Confidentiality Introduction to workplace confidentiality Business Etiquettes and Types of Confidentiality The Importance of Confidentiality Confidentiality with Co-workers Preventing Confidentiality Breach How Employers Can Protect Confidential Information Course 10: Decision Making and Critical Thinking Introduction to Critical Thinking Critical Thinking and the Judgment of Claims Benefits and Barriers of Critical Thinking Importance of Critical Thinking Recognising a Critical Thinker What Are the Critical Thinking Steps? Critical Thinking Strategies Problem-Solving Through Critical Thinking Decision Making with Critical Thinking Course 11: Creativity and Problem Solving Skills Getting Started The Problem Solving Method Information Gathering Problem Definition Preparing for Brainstorming Generating Solutions (I) Generating Solutions (II) Analyzing Solutions Selecting a Solution Planning Your Next Steps Recording Lessons Learned Course 12: Workplace Confidentiality Module 01: Introduction to workplace confidentiality Module 02: Business Etiquettes and Types of Confidentiality Module 03: The Importance of Confidentiality Module 04: Confidentiality with Co-workers Module 05: Preventing Confidentiality Breach Module 06: How Employers Can Protect Confidential Information Course 13: UK Employment Law and Employee Rights Diploma Basic of Employment Law Legal Recruitment Process Employment Contracts Employee Handbook Disciplinary Procedure National Minimum Wage & National Living Wage Parental Right, Sick Pay & Pension Scheme Discrimination in the Workplace Health & Safety at Work Dismissal, Grievances and Employment Tribunals Workplace Monitoring & Data Protection Course 14: Work Area Organisation for Increased Office Productivity Introduction Purge Redistributing Fences Software Create Work Spaces Proximity Label What You Can Move to Digital Clean Your Desk Off Multiple Inboxes Mailings Discard Dates Magazines File Weekly CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Employability Skills bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Employability Skills is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that 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 Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of Completion (e-Certificate) Digital certificate - Included You will get the PDF Certificate for the title course (Diploma in Becoming Career Smart) absolutely Free! Certificate of Completion (Hard Copy) Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Diploma in Becoming Career Smart) 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.

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 26 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 Fusion 360 graphic designing Understand the core competencies and principles of Fusion 360 graphic designing Explore the various areas of Fusion 360 graphic designing Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert graphic designer Microsoft Office Excel 2016: Part 2 (Intermediate Level) Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel 2016 intermediate level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel 2016 intermediate leve 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 Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel 2016 intermediate leve 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 excel 2016 intermediate leve 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 Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel 2016 intermediate leve 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 excel 2016 intermediate leve 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 excel 2016 intermediate leve 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 Course Overview Introduction and Course Overview 00:02:00 Working with Functions Working and Function - Introduction 00:01:00 Work with Ranges - Introduction 00:01:00 Name and Edit Ranges 00:05:00 Use Defined Names in a Formula 00:03:00 Locate and Use Specialized Functions 00:05:00 Work with Logical Functions - Introduction (02:13) 00:02:00 IF Function 00:04:00 AND, OR and NOT Function 00:05:00 Combine Functions 00:06:00 Functions Similar to the IF Function 00:05:00 Work with Date and Time Functions - Introduction 00:01:00 TODAY, NOW and DATE Functions 00:03:00 NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions 00:05:00 Work with Text Functions - Introduction 00:01:00 LEFT, RIGHT and MID Functions 00:02:00 FIND Function 00:03:00 Text to Columns Feature 00:03:00 CONCATENATE Function 00:03:00 UPPER, LOWER and PROPER Functions 00:02:00 Practice File Working with Functions Practice File Working with Functions 00:00:00 Working with Lists Sort Data - Introduction 00:01:00 Sort Data 00:03:00 Filter Data - Introduction 00:01:00 Filter Data 00:02:00 Query Data with Database Functions 00:01:00 Database Functions 00:03:00 Outline and Subtotal Data - Introduction 00:01:00 Use Subtotals to Summarize Data 00:03:00 Practice File Working with Lists Practice File Working with Lists 00:00:00 Assessment Mock 1 Assessment Mock 1 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Analyzing Data Create and Modify Tables - Introduction 00:01:00 Create and Modify Tables 00:06:00 Use Summary Functions in Tables 00:03:00 Apply Intermediate Conditional Formatting - Introduction 00:01:00 Apply Intermediate Conditional Formatting 00:02:00 Apply Advanced Conditional Formatting - Introduction 00:01:00 Use Logical Functions to Apply Conditional Formatting 00:03:00 Practice File Analyzing Data Practice File Analyzing Data 00:00:00 Visualizing Data with Charts Create Charts - Introductions 00:01:00 Create Charts 00:04:00 Modify and Format Charts - Introduction 00:01:00 Modify and Format Charts 00:05:00 Use Advanced Chart Features - Introduction 00:01:00 Create a Dual-Axis Chart 00:04:00 Create a Chart Template 00:03:00 Visualizing Data with Charts - Best Practice 00:04:00 Practice File Visualizing Data with Charts Practice File Visualizing Data with Charts 00:00:00 Using PivotTables and PivotCharts Create a PivotTable - Introductions 00:01:00 Create a PivotTable 00:04:00 Analyze PivotTable Data - Introduction 00:01:00 Analyze PivotTable Data 00:04:00 Present Data with PivotCharts - Introduction 00:01:00 Present Data with PivotCharts 00:05:00 Filter Data by Using Timelines and Slicers - Introduction 00:01:00 Filter Data by Using Slicers and Timelines 00:04:00 Bonus Lecture 00:01:00 Practice File Using PivotTables and PivotCharts Practice File Using PivotTables and PivotCharts 00:00:00 Assessment Mock 2 Assessment Mock 2 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Final Assessment Final Assessment - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10: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: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 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 Working with Functions Work with Ranges FREE 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 Working with Lists 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 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts 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 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data 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 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Nowadays almost every job in the business world involves office products. Whether you're an administrative assistant, office manager, sales professional or business manager, utilizing all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. The Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is designed to provide you all the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Access - Beginner Orientation to Microsoft Access FREE 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Microsoft Access - Intermediate Relational Database Design FREE 00:16:00 Create a Table 00:09:00 Create Table Relationships 00:09:00 Create Query Joins 00:14:00 Relate Data Within a Table.avi 00:04:00 Work with Subdatasheets from 00:05:00 Use Field Validation 00:16:00 Use Form and Record Validation 00:14:00 Create Parameter Queries 00:12:00 Summarize Data 00:06:00 Create Subqueries 00:07:00 Create Action Queries 00:05:00 Create Unmatched and Duplicate Queries 00:06:00 Data Normalization 00:10:00 Create a Junction Table 00:04:00 Improve Table Structure 00:06:00 Include Control Formatting in a Report 00:04:00 Add a Calculated Field to a Report 00:05:00 Add a Subreport to an Existing Report 00:07:00 Microsoft Access - Advanced Add Controls to Forms FREE 00:11:00 Enhance Navigation and Organization of Forms 00:14:00 Apply Conditional Formatting 00:04:00 Import Data into Access 00:08:00 Export Access Data 00:06:00 Link Tables to External Data Sources 00:05:00 Create a Mail Merge 00:02:00 Create a Macro 00:08:00 Restrict Records by Using a Condition 00:04:00 Validate Data by Using a Macro 00:05:00 Automate Data Entry by Using a Macro 00:04:00 Manage a Database 00:08:00 Determine Object Dependency 00:04:00 Manage a Database 00:07:00 Determine Object Dependency 00:04:00 Document a Database 00:04:00 Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:03:00 Convert an Access Database to an ACCDE File 00:04:00 Package a Database with a Digital Signature 00:01:00 Create a Database Switchboard 00:05:00 Modify a Database Switchboard 00:02:00 Set Start up Options 00:04:00 Mock Exam Mock Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Released by Microsoft, Microsoft Access 2016 is a data-based organization program created to help users analyze data and information. This application deals with managing related data being more efficient compared to other spreadsheet applications. It is impossible to become expert in using this application if you don't know how to use Access 2016 works which this Microsoft Office 2016 Access Advanced - Complete Video Course is all about. Dealing with large amount of data can be stressful if you don't know how to use this Office application in the first place. Using data validation, macros, and implementing advanced form design are some of the features of Access 2016 so take the opportunity to take this course will help you utilize these and more. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Access Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Access Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Add Controls to Forms FREE 00:11:00 Enhance Navigation and Organization of Forms 00:14:00 Apply Conditional Formatting 00:04:00 Module 02 Import Data into Access 00:08:00 Export Access Data 00:06:00 Link Tables to External Data Sources 00:05:00 Create a Mail Merge 00:02:00 Module 03 Create a Macro 00:08:00 Restrict Records by Using a Condition 00:04:00 Validate Data by Using a Macro 00:05:00 Automate Data Entry by Using a Macro 00:04:00 Module 04 Manage a Database 00:08:00 Determine Object Dependency 00:04:00 Module 05 Manage a Database 00:07:00 Determine Object Dependency 00:04:00 Document a Database 00:04:00 Module 06 Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:03:00 Convert an Access Database to an ACCDE File 00:04:00 Package a Database with a Digital Signature 00:01:00 Module 07 Create a Database Switchboard 00:05:00 Modify a Database Switchboard 00:02:00 Set Start up Options 00:04:00 Mock Exam Mock Exam- Microsoft Office 2016 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Access Advanced - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Tired of browsing and searching for a Purchasing & Procurement course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Purchasing & Procurement bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Purchasing & Procurement course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Purchasing & Procurement and help you along your learning journey. Advanced audio-visual learning modules of these Purchasing & Procurement 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 Purchasing & Procurement, 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 Purchasing & Procurement Bundle Consists of the following Premium courses: Course 1: Purchasing & Procurement Course - Level 3 Course 2: Logistic Management Course 3: Retail Operations Training Level 3 Course 4: Facilities Management Level 3 Course 5: Basic Product Management Course 6: Import/Export Processing Course 7: SAP Controlling (CO) - Product Costing S4HANA Course 8: Warehouse Course 9: Freight Consultant Training Course 10: Merchandising Course 11: Manual Handling Level 2 Course 12: Supply Chain Management Course 13: Level 2 Microsoft Office Essentials Course 14: Time Management Enrol now in Purchasing & Procurement to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Purchasing & Procurement expertise and essential knowledge, which will assist you in reaching your goal. Course Curriculum: Course 1: Purchasing & Procurement Course - Level 3 Module 01: Supply Chain Basics Module 02: Role of Procurement in an Organisation Module 03: The Purchasing Cycle Module 04: Purchasing Toolkits Module 05: Managing Competitive Bids Module 06: Quality Management Module 07: Supplier Relationship Management Module 08: Analysing and Reducing Risk in the Supply Chain Module 09: Improving Efficiency and Accuracy Module 10: Category Management Module 11: Inventory Management Module 12: E-Procurement ---------- Other Courses Are --------- Course 2: Logistic Management Course 3: Retail Operations Training Level 3 Course 4: Facilities Management Level 3 Course 5: Basic Product Management Course 6: Import/Export Processing Course 7: SAP Controlling (CO) - Product Costing S4HANA Course 8: Warehouse Course 9: Freight Consultant Training Course 10: Merchandising Course 11: Manual Handling Level 2 Course 12: Supply Chain Management Course 13: Level 2 Microsoft Office Essentials Course 14: Time Management 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Purchasing & Procurement bundle. Requirements Our Purchasing & Procurement course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Purchasing & Procurement 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 (Purchasing & Procurement Course - Level 3) 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.

So, you are struggling with your typing, then? Becoming nostalgic with the 'old-days-were-good- when people used pen and paper'? Getting lost finding 'k','w', or 't' on your keyboard. Hey! Typing, like any other skill, can be improved by knowing some tricks and practising. And we have good news for you! In this Touch Typing bundle, we will teach you tips and tricks that will enable you to type 3x faster! Touch typing is a method of typing quickly and accurately without looking at the keyboard. It is a skill that can be developed through practice and patience. Touch typing is a valuable skill to have in the modern world, as it can be used to type emails, documents, and other digital tasks quickly and efficiently. The process of touch typing involves memorising the location of each key on the keyboard. Once this is done, you can type quickly and accurately without looking at the keys. With the help of practice given in this course, you can learn to type without mistakes or typos. A faster typing speed is a valuable skill for most jobs these days. So, Enrol now and uplift your career to the next level! Learning Outcome After completing this Touch Typing bundle, you will be able to - Learn the fundamentals of typing Type characters quickly Know how to use punctuation keys Type numbers on a numeric keypad Avoid fatigue with proper Ergonomics Excel in Microsoft Office Learn the techniques and strategies for proper fact-checking Learn how speed reading "works" in practice Develop reading objectives and break negative reading habits This Touch Typing Training Bundle Consists of the following Premium courses: Course 01: Touch Typing Essentials Course 02: Level 2 Microsoft Office Essentials Course 03: Advanced Diploma in Copywriting Course 04: Business Writing Course 05: Email Writing Training Course 06: Minute Taking Essentials Level 2 Course 07: Document Control Course 08: Creative Writing Complete Course Course 09: Blogging Course 10: Content Management Course 11: Computer Science With Python Course 12: Functional Skills IT Course 13: Improve English Spelling, Punctuation, Grammar and Pronunciation Course 14: Time Management The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Touch Typing Training expertise and essential knowledge, which will assist you in reaching your goal. Enrol now in Touch Typing Training to advance your career, and use the premium study materials from Apex Learning. Course Curriculum of the Touch Typing Bundle Course 01: Touch Typing Essentials Introduction How to Set up Your Computer How to type the letters F and J How to type the letters D and K How to type the letters S and L How to type the letter A and ; (semicolon) How to type the letters E and I How to type the letters R and U How to type the letters T and O How to type CAPITAL letters How to type the letter C and , (Comma) How to type the letters G and H How to type the letters N and V How to type the letters W and M How to type the letters Q and P How to type the letters B and Y How to type the letters Z and X How to type Colon and Semicolon How to type Full Stop and Comma How to type Question Mark and Exclamation Mark How to type Dash, Parentheses and Quotation Marks And 14 more courses .... CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is designed for anyone who wants to explore touch typing fundamentals and particularly for: Office Assistant Personal Assistant Minute taker Secretary Writer Requirements Our Touch Typing Training course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path This Touch Typing bundle will open many career opportunities - Data entry clerk Audio typist Copy typist Secretary Admin Assistant Clerical Assistant Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Touch Typing Essentials) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Touch Typing 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.

Microsoft Office Bundle for Teachers is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Office Bundle for Teachers and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 18 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.