607 Courses

Learn Microsoft Excel to create and format spreadsheets, analyse and share information to make knowledgeable resolutions. This Microsoft Office 2016 Excel Beginners is intended to teach you creating high-level workbooks and worksheets. Upon completion, you will have the ability to explain massive amounts of data and present that information to increase your understanding of the organisational account. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam - Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Excel Beginners 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Level-7 QLS Endorsed | 22-in-1 Diploma Bundle| Free CPD PDF+ Transcript Certificate| Lifetime Access| Learner Support

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Level 2 Microsoft Office Essentials

Give a compliment to your career and take it to the next level. This Project Management: Project Manager bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop Project Management : Project Manager skills for your next job or elevate your skills for your next promotion, this Project Manager bundle will help you stay ahead of the pack. Throughout the Project Manager 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 Project Management: Project Manager course, you will get 19 premium courses, an original hardcopy, 20 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Project Management : Project Manager Bundle Consists of the following Premium courses: Course 01: Project Management Course 02: Project Manager Training Course Course 03: Operations Management Course 04: Business Law Course 05: Strategic Business Management Course 06: People Management Skills Level 3 Course 07: Construction Project Management Level 4 Course 08: Construction Cost Estimation Diploma Course 09: Business Intelligence Analyst Course Course 10: Capital Budgeting & Investment Decision Rules Course 11: Level 3 Tax Accounting Course 12: Corporate Risk And Crisis Management Course 13: Financial Modeling Using Excel Course 14: Risk Management Course 15: Office Skills and Administration Management Diploma Course 16: Business Performance Management Course 17: Crisis Management Course Course 18: Raise Money and Valuation for Business Course 19: Excel Must know Formulas and Functions Course 20: Workplace Health and Safety Diploma Enrol now in Project Management: Project Manager to advance your career and use the premium study materials from Apex Learning. The Project Management: Project Manager bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Project Management: Project Manager expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Project Management: Project Manager from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Project Management: Previously it was £10) CPD 205 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Project Management: Project Manager bundle. Requirements This Project Management: Project Manager 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 Project Management 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.

20-in-1 Cyber Security Bundle Give a compliment to your career and take it to the next level. This Cyber Security bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop Cyber Security skills for your next job or elevate your skills for your next promotion, this Cyber Security bundle will help you stay ahead of the pack. Throughout the Cyber Security 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 Cyber Security course, you will get 19 premium courses, an original hardcopy, 20 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Cyber Security Bundle Consists of the following Premium courses: Course 01: Cyber Security Incident Handling and Incident Response Course 02: Computer Networks Security Course 03: Cyber Security Law Online Course Course 04: Cyber Intelligence Officer Course 05: CompTIA Security+ (SY0-401) New 2020 Course 06: CompTIA CySA+ Cybersecurity Analyst (CS0-002) Course 07: Computer Hacking Forensic Investigator Course 08: Security Management Advanced Diploma Course 09: IT Administration and Networking Course 10: GDPR Training Course 11: Master JavaScript with Data Visualization Course 12: Computer Science With Python Course 13: R Programming for Data Science Course 14: WordPress Security Mastery Course 15: Mile2 Certified Network Forensics Examiner (CNFE) Course 16: Complete Web Application Penetration Testing & Security Course 17: Linux Security and Hardening Course 18: Excel Must know Formulas and Functions Course 19: Certified Information Systems Security Professional (CISSP) Course 20: Excel Spreadsheet for Beginner Enrol now in Cyber Security to advance your career, and use the premium study materials from Apex Learning. The Cyber Security bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Cyber Security expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Cyber Security from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*20 = £120) Hard Copy Certificate: Free (For The Cyber Security Incident Handling and Incident Response Course: Previously it was £10) CPD 285 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Cyber Security bundle. Requirements This Cyber Security 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 Cyber Security Incident Handling and Incident Response 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.

This Microsoft Office 2007 Excel Intermediate will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. Who is this Course for? Microsoft Office 2007 Excel Intermediate is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Course Curriculum Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Creating A Body Of Work 00:03:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Level 4 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Financial Intelligence and Financial Risk Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Financial Intelligence and Financial Risk Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Financial Intelligence and Financial Risk Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Financial Intelligence and Financial Risk Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Improve your Financial Intelligence Course 02:Finance Principles Course 03:Accounting Basics Course 04:Financial Wellness: Managing Personal Cash Flow Course 05:Debt Management - Online Course Course 06:Raising Money & Valuations Course 07:Excel Data Analysis Course 08:Microsoft Office 2016 Advanced Course 09:Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10:Minute Taking Executive Training Course 11:Personal Productivity Course Course 12:Corporate & Strategic Communication Skills for Managers Course 13:Tax Accounting Course 14:Introduction to VAT Course 15:Anti-Money Laundering (AML) Training Course 16:Stakeholder Management Course 17:Risk Assessment & Management Course 18:Commercial Law Course 19:Document Control Course 20:Cost Control & Project Scheduling Course 21:Dealing With Uncertainity: Make Budgets and Forecasts Course 22:QuickBooks Online Bookkeeping Diploma Course 23:Sage 50 Accounting Course 24:Stock Trading & Investing Course 25:Making Budget & Forecast Course 26:Financial Analysis : Finance Reports Course 27:Learn to Read, Analyse and Understand Annual Reports Course 28:Develop Your Career in Finance: Blue Ocean Strategy Course 29:Accounting Basics Course 30:Fundamentals of Zero Based Budgeting 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made Financial Intelligence and Financial Risk Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Financial Intelligence and Financial Risk Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Financial Intelligence and Financial Risk Management bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Financial Intelligence and Financial Risk Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.