607 Courses

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. Therefore after completing this 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 different 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 Beginners - 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 Excel Beginners - 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. 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 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Highlights: This qualification is equivalent to GCSE grade C or 4 Take the Exam from Home – Guaranteed Fast Track Results Exam Booking within 2 Working Days of Enrolment Remote Exam Online or Paper based both option available Course Duration: 55 hours Unlimited Access to Course Materials Get Free Mock Tests & Free Past Papers Extra 25% Time for people with Learning Difficulties NCFE, Pearson Edexcel & Open Awards all are OFQUAL-regulated and nationally recognised Exam slots are available 24*7 from Monday to Sunday. If you are in a rush and would like to book your exam sooner, then you can book your remote online exam within 3 working days for Open Awards, 2 working days of enrolment for NCFE and within 7 working days for Pearson Edexcel. Please note the exam price advertised on the website for the Open Awards remote invigilation exam is applicable for weekdays (Monday to Friday between 9 am to 5 pm). If you would like to book the Open Awards remote invigilation exam at the weekend then there is an additional £25+Vat applicable. The new assessment and result dates by NCFE is: (Only applicable if you are attending the exam in between the following assessment date). Delivery mode: On-screen and RI Assessment date to and from: 16/09/2024 – 25/10/2024 Results release: 01/11/2024 The new assessment and result dates by Open Awards is: (Only applicable if you are attending the exam in between the following assessment date). Delivery mode: Remote Assessment date to and from: 02/09/2024 – 13/09/2024 Results release: 11/10/2024 Assessment date to and from: 04/11/2024 – 15/11/2024 Results release: 13/12/2024 (Note that this only applies to the mentioned exam type and if you book the exam during the dates mentioned above. Also, this will not affect the schedule of the other exam types and results.) Why is this course right for you? Our expert designed Functional Skills Maths Level 1 Course has smart learning options that provide the necessary numeracy knowledge and skills to excel in Functional Skills Maths. Our course is tailored to meet your specific needs and help you achieve your academic and career goals from the comfort of your home. You also get the opportunity to book Live 1:1 tutor support via Zoom. With interactive lessons, FREE mock test, personalised feedback and remote exams, our Maths Level 1 Course ensures a comprehensive and engaging learning experience. EXAM Booking & Results Details You can decide the exam date and place according to your convenience.  Awarding Body Paper-Based Exam in Centre On-Screen Exam in Centre Remote Online Exam - From Home Results Edexcel Book within 15 days Book within 24 Hours Book within 7 working days Get results in 20 working days NCFE Book within 10 working days Book within 24 Hours Book within 2 working days Get results in only 7 days Open Awards N/A N/A Book within 2 working days Get results in only 16 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information. Difference between NCFE and Pearson Edexcel and Open Awards NCFE, Pearson Edexcel and Open Awards are OFQUAL-regulated and nationally recognised; however, the only difference lies in the exam booking and result turn-around time. You can book your remote online exam within 2 working days of enrolment for NCFE, within 7 working days for Pearson Edexcel and within 3 working days for Open Awards. You can get your NCFE results in 7 days, your Edexcel results in 20 working days and your Open Awards results within 16 working days. All of the awarding bodies are accepted by universities and apprenticeships. This distinction allows learners to choose the awarding body that aligns best with their educational and career goals. How This Course Will Work? This Level 1 Functional Skills Maths course will help you build a solid foundation in mathematics. Throughout the course, it will provide you with various learning materials and activities to enhance your understanding of these subjects. Initial Assessment: To identify the current level of a student's abilities and recommend the appropriate course to enrol in upon completion. Diagnostic Assessment: Identifies skill gaps and produces an individual learning plan Learning Resources: Comprehensive video tutorials, practice quizzes & topic-based tests Progress Tracker: To record your progress in the course Free Mock Test: Access our free mock test facility for professional feedback and to prepare for the final exam. Entry Requirement This level 1 maths qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. However, you will require a laptop/desktop computer and a good internet connection. Exam Structure The Functional Skills NCFE, Pearson Edexcel and Open Awards Qualification in Mathematics Level 1 consist of one externally assessed assessment that comprises two sections- a non-calculator section (calculator prohibited) and a calculator section (calculator permitted). The assessments are available as paper-based and onscreen, on-demand assessments.  Section A (Non-calculator) Awarding Body Exam Duration Total Marks Questions Cover Edexcel 25 minutes 16 25% NCFE / Open Awards 30 minutes 15 25%   Section B (Calculator) Awarding Body Exam Duration Total Marks Questions Cover Edexcel 1 hour 30 minutes 48 75% NCFE / Open Awards 1 hour 30 minutes 45 75% Pass Mark (NCFE): Learners are required to achieve an overall (from sections A and B) (57% – 62%) mark to pass the exam. Please note, that the marks varies for individual exam papers so for all the exam papers the pass marks is not fixed for the NCFE exam.  Pass Mark (Open Awards): Pass Marks for Level 1 Maths assessments vary per assessment version and are set following standardisation and awarding activities.  Each Maths assessment is designed to enable a minimally competent learner to achieve a pass mark of 36 out of 60. However, the awarding process will determine specifically where the pass mark sits for each assessment version. Therefore, the pass mark may vary between assessments. Recognised Accreditation This Functional Skills Maths Level 2 has been independently accredited by Pearson Edexcel, NCFE and Open Awards also regulated by Ofqual. The Office of Qualifications and Examinations Regulation (Ofqual) is responsible for regulating qualifications, assessments, and examinations in England. Pearson Edexcel is the most prestigious awarding body, for an academic and vocational qualifications. Pearson Edexcel qualifications are regulated by Ofqual and recognised by universities and employers across the world. NCFE is a charity and awarding organisation that provides qualifications in England, Wales, and Northern Ireland. It is regulated by Ofqual in England and recognised in Wales and Northern Ireland. Open Awards is an awarding organisation that offers a wide range of qualifications across various sectors, including education, health and social care, and business. Their qualifications are regulated by Ofqual and are designed to meet the needs of learners and employers. Open Awards also works closely with educational institutions and employers to ensure their qualifications are relevant and up-to-date. Additional Features  Access to On-Demand Classes Opportunity to Book 1:1 Live Tutor Support via Zoom Enrol in Our Course and Prepare for the Exam from Home Get a Free Mock Test with Professional Feedback Course Curriculum Unit 1: Number Lesson 1.1: Numbers and the Number System The number system gives you a general insight into the mathematical operations regarding the given numbers. You will acquire skills in division, multiplication, addition and subtraction, which require steps in real-life contexts. Lesson 1.2: Fractions and Decimals You will be learning many types of fractions, including improper fractions, proper fractions, equivalent fractions and more. Along with this, you will learn Ordering Decimal Numbers, Subtracting Decimals, multiplying and dividing decimals and more, which enables you to apply real-world problem-solving. Lesson 1.3: Percentages You will learn to calculate the Percentage and how to express a Number as a Percentage of Another. Interpreting the Original Value, Calculating Percent Increase and Decrease, and so on. This learning you can easily apply in real-life counting issues along with increasing your rational thinking. Lesson 1.4: Ratio and Proportion You will be learning to calculate the Total Amounts using Ratios, direct Proportion, Inverse Proportion and many more things, which help you in doing comparisons, learning science and engineering, and more. Lesson 1.5: Formula You will learn the definition of formulas Formula Using Words, Multi-Step Formulas, Formula Using Letters and so on. Learning formulas has a large impact on real life as these formulas are used extensively in measuring, building infrastructure and more. Unit 2: Measures, Shapes and Space Lesson 2.1: Money Math You will be mastering Solving Money Related Questions, including percentage-based discounts, discounts Related to Fractions, Profit and Percentage, etc. This money math learning will help you to understand money-earning and saving-related issues that you face in daily activities. Lesson 2.2: Units You will learn units and Types of Units, Units of Weight, Units of Length, Units of Capacity, etc. Also, you will gain knowledge about steps to convert between Metric Units, Imperial to Imperial Conversions, and Other Unit Conversions will help pursue a higher university degree. Lesson 2.3: Speed and Density You will be clearing the concept of speed, calculations to find out distance and time, density, Relation between Density, Weight and Volume. Lesson 2.4: Perimeter You will learn to find perimeter and area, Circle, perimeter of triangle etc. which require in measurement, design and planning and so on. Lesson 2.5: Area and Shapes You will gain skills in formulas for calculating area, finding areas of complex shapes, applying area calculations in complex questions, different Types of 3D Shapes, surface area, finding the surface area of complex 3D Shapes, using nets, plans and elevations, etc. learning about area and shapes will certainly help you in building your dream home and more. Lesson 2.6: Volume In the volume classes, you will learn Formulas for calculating volume, Questions based on volumes of different 3D Shapes, finding the Scale in a Diagram, Making Scale Drawings, which are required in building critical thinking skills and more. Lesson 2.7: Coordinates & Angles You will be learning necessary things about the coordinate Grid, How to Read Coordinates on a Grid? Plotting Points on a Grid and more which extensively requires in making video games, medical imaging, physics and more. Unit 3: Handling Data and Information Lesson 3.1: Median and Mode You will be learning about median and mode, which is one of the most interesting mathematical chapters. As you will know how to find the median and mode from the sets of numbers, you can easily implement such learning in household work and other places as well. Lesson 3.2: Mean and Range You will be able to find the mean, median and mode. Knowing how to find these is highly important in all aspects of life. Lesson 3.3: Probability You will learn Probability: Definition and Meaning, Calculating Probabilities, Probability of Something Happening and Something Not Happening, etc. Once you know how to find probability, you can easily detect business profit loss and implement other parts of your life. FAQs The Functional Maths level 1 Course is equivalent to? The Level 1 course is a fundamental level of proficiency in English, Maths, and ICT that is equivalent to a GCSE grade 1 to 3 (formerly G to D grades). It is a nationally recognised qualification in the UK that provides an alternative to GCSEs for individuals who still need to pass these subjects during their secondary education. Why should I take the Functional Skills Maths instead of the GCSE Maths? The functional maths course is comparatively easier than the GCSE math and additionally the value of it is also more than the GCSE math course. However, you should select the course that suits your needs, as both courses provide different values at different places. Which one is more difficult between Functional and GCSE Maths courses? The functional skills Maths course is more flexible than the GCSE math course since you have to sit for the official exam in the GCSE courses. What is the Difference between Functional Skills and GCSE? A Functional skills course develops for the one who wants to learn Math, English and ICT for individual achievement in daily work place and on the other hand, GCSE focuses on theories and tests your academic ability. How will I access the functional skills Maths level 1 course after payment? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with Lead Academy. Will I get access to the Course if my location is outside the UK? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol in our courses. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realize the benefit of having an accredited certificate once you face the corporate world. As employees, job places, and more value the accredited certificate, you must own this certificate by doing the course with us. What are the system requirements for remote exam? For Pearson Edexcel and NCFE: To sit your assessment, you’ll need: A laptop/desktop with webcam and microphone; you can’t sit the assessment on a tablet or smartphone a good Wi-Fi connection – recommended minimum 1Mbit/s Upload, minimum 10Mbit/s Download. You MUST use google chrome browser for the exam, as this is recommended by the awarding body. A smartphone or tablet (Apple iOS 8.0 / Android 4.1 or higher) - this will be used to record you taking the assessment. A suitable environment - quiet room with no distractions The link for the assessment sent to your email; remember to check your spam/junk folder. You must activate Airplane mode on your smartphone however you need to be connected to Wi-Fi, so turn on Airplane mode then reactivate your Wi-Fi. Please familiarise yourself with the potential violations as these can potentially lead to the assessment being voided. Ensure ALL equipment is plugged in (including phone for the recording of sessions). Loss of power at any point could lead to the assessment being voided. You must brief other members of your household/workplace that you’re sitting an assessment, and they must not enter the room at any point. There is a 24-hour live chat function within the assessment software for technical support should you need it at any time. For Open Awards: In order to take your exam, you need to have the following equipment: A good quality laptop or PC with a minimum screen size of approx. 14” and minimum resolution of 1024 x 768. A stable internet connection with at least 3mbps. An integrated (i.e., fixed) webcam on your PC/ laptop or a portable webcam. If using a PC/ laptop with an integrated webcam, a reflective surface (e.g., a mirror) must be available. This will be used to show the invigilator the space immediately surrounding your screen and keyboard. A basic (non-scientific) calculator for maths assessments. You will have access to an on-screen calculator but may feel more comfortable using a separate calculator. Please note that all workings need to be added to the assessment platform if you use a separate calculator so that your workings can be marked. Plain paper. You will need to show this to your invigilator at the beginning of the exam to assure them that you do not have access to notes. A dictionary (where allowed). Supported Browsers Chrome: 34.0.1847 or above Microsoft Edge: Version 88.0.705.81 or newer Firefox: 31.0 or above Safari: 6.2 or above Safe Exam Browser 2.0.2 or above Please note: Chromebooks are not compatible with the Safe Exam Browser Browser settings Popups must be allowed. Guidance on how to do this below: Chrome Edge Firefox Safari

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. 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 2007 Excel 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 2007 Excel 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. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Gain advanced administrative, secretarial, and PA skills with our Level 5 course. Enhance your professional capabilities and excel in a dynamic work environment.

Overview We live in an era where data, data and data surround us. You need to share something one way or another to use most of the services around you; just name it. Whether it is about reading a blog post, visiting a website, surveying for a service, seeing any social media post, or looking for offers, you must share some data, if not anything, and your email, at least.But do you ever realise why, in all these situations, you need to share your data? Because your data is oxygen in this world. Companies want to know what you are thinking or what you are about to do before you even think or are about to do it. Sounds crazy, right? Don't be.It is a new branch of knowledge and profession. A data analyst gathers, cleans, and evaluates data sets to find an explanation or resolve an issue. The most common tool for doing these is Microsoft Excel. Our Data Analysis in Microsoft Excel Complete Training course will prepare you to use Microsft Excel in data analysis. What Can You Expect To Achieve By Completing This Course? Proficiency in modifying and organising data within Excel worksheets. Skills in working with lists and effectively analysing data. Ability to create visual representations of data using charts and graphs. Competence in using PivotTables and PivotCharts for data summarisation and analysis. Command in managing multiple worksheets, workbooks, and advanced Excel functions for data manipulation and forecasting. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Data Analysis in Microsoft Excel Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis in Microsoft Excel Complete Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 31 lectures • 04:46:00 total length •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 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:10:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:05:00 •Watch and Evaluate Formulas: 00:10:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

Data Analysis In Excel for School Administrators 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 Data Analysis In Excel for School Administrators 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 5 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. 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 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 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09: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:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:06:00

[vc_row][vc_column][vc_column_text] Description: In this course, you will be able to identify the elements of the Microsoft Excel interface. You will learn how to create a basic worksheet and to get comfortable with the parts of the screen. This Microsoft Office 2013 Excel Beginners - Complete Video Course covers the basic functions and features of Excel 2013. You will learn about calculations and how to modify and format a worksheet. You will also learn how to customize the Excel environment and how to manage and print workbooks. In this course, you will take your knowledge up a notch as you get acquainted with Microsoft Excel 2013's most sophisticated features. If you think you know Excel 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Excel tips and tricks out there. 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 2013 Excel Beginners - 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 2013 Excel Beginners - 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.[/vc_column_text][/vc_column][/vc_row] Getting Started with Microsoft Excel 2013 Identify the Elements of the Excel Interface FREE 00:14:00 Create a Basic Worksheet 00:16:00 Use the Help System 00:04:00 Performing Calculations Create Formulas in a Worksheet 00:15:00 Insert Functions in a Worksheet 00:13:00 Reuse Formulas 00:15:00 Modifying a Worksheet Manipulate Data 00:13:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:08:00 Search for and Replace Data 00:12:00 Spell Check a Worksheet 00:06:00 Formatting a Worksheet Modify Fonts 00:11:00 Add Borders and Color to Cells 00:10:00 Apply Number Formats 00:10:00 Align Cell Contents 00:10:00 Apply Cell Styles 00:08:00 Printing Workbook Contents Define the Basic Page Layout for a Workbook 00:16:00 Refine the Page Layout and Apply Print Options 00:13:00 Managing Large Workbooks Format Worksheet Tabs 00:03:00 Manage Worksheets 00:09:00 Manage the View of Worksheets and Workbooks 00:10:00 Customizing the Excel Environment Customize General and Language Options 00:08:00 Customize Formula Options 00:04:00 Customize Proofing and Save Options 00:04:00 Customize the Ribbon and Quick Access Toolbar 00:04:00 Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 Excel Basics Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Formats 00:08:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Essential Formulas Basic Formula Operations 00:13:00 Mathematical Functions 00:19:00 Textual Functions 00:17:00 Logical Functions 00:11:00 Date-Time Functions 00:07:00 Lookup Functions ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools Data Tools 00:19:00 Formatting data and tables Formatting data and tables 00:18:00 Pivot Tables Pivot Tables 00:08:00 Excel Charts Excel Charts - Categories of messages that can be conveyed 00:04:00 Elements of charts 00:05:00 The Easy way of creating charts 00:03:00 Bar and column charts 00:12:00 Formating charts 00:15:00 Line Charts 00:09:00 Area Charts 00:06:00 Pie and Doughnut Charts 00:13:00 Why we should avoid Pie charts 00:04:00 Scatter plot or XY chart 00:16:00 Frequency Distribution and Histograms 00:13:00 Waterfall Charts 00:12:00 Sparklines 00:05:00 Pivot Charts Pivot Charts 00:07:00 Named Ranges Named Ranges 00:10:00 Indirect Function 00:05:00 Excel Shortcuts Shortcuts 00:12:00 Macros Macros 00:10:00 Advanced Excel Advanced Excel: Analytics in Excel 00:15:00 Final Assessment Assessment - Microsoft Excel For Beginners 00:10: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

Our expert-designed Functional Skills Maths Level 2 Course has smart learning options that provide the necessary Level 2 numeracy knowledge and skills to excel in Functional Skills Maths. Level 2 Maths Course Highlights: This qualification is equivalent to GCSE grade C or 4 Take the Exam from Home – Guaranteed Fast Track Results Exam Booking within 2 Working Days of Enrolment Remote Exam Online or Paper based both options available Course Duration: 55 hours Unlimited Access to Course Materials Get Free Mock Tests & Free Past Papers Extra 25% Time for people with Learning Difficulties NCFE, Pearson Edexcel & Open Awards are all OFQUAL-regulated and nationally recognised Exam slots are available 24*7 from Monday to Sunday. If you are in a rush and would like to book your exam sooner, then you can book your remote online exam within 3 working days for Open Awards, 1 working day of enrolment for NCFE and within 7 working days for Pearson Edexcel. Please note the exam price advertised on the website for the Open Awards remote invigilation exam is applicable for weekdays (Monday to Friday between 9 am to 5 pm). If you would like to book the Open Awards remote invigilation exam at the weekend then there is an additional £25+Vat applicable. The new assessment and result dates by NCFE are: (Only applicable if you are attending the exam in between the following assessment date). Delivery mode: On-screen and RI Assessment date to and from: 16/09/2024 – 25/10/2024 Results release: 01/11/2024 The new assessment and result dates by Open Awards is: (Only applicable if you are attending the exam in between the following assessment date). Delivery mode: Remote Assessment date to and from: 02/09/2024 – 13/09/2024 Results release: 11/10/2024 Delivery mode: Remote Assessment date to and from: 04/11/2024 – 15/11/2024 Results release: 13/12/2024 (Note that this only applies to the mentioned exam type and if you book the exam during the dates mentioned above. Also, this will not affect the schedule of the other exam types and results.) Why is this course right for you? Our course is tailored to meet your specific needs and help you achieve your academic and career goals from the comfort of your home. You also get the opportunity to book Live 1:1 tutor support via Zoom. With interactive lessons, FREE mock test, personalised feedback and remote exams, our Maths Level 2 Course ensures a comprehensive and engaging learning experience.   EXAM Booking & Results Details You can decide the exam date and place according to your convenience.  Awarding Body Paper-Based Exam in Centre On-Screen Exam in Centre Remote Online Exam - From Home Results Edexcel Book within 15 days Book within 24 Hours Book within 7 working days Get results in 20 working days NCFE Book within 10 working days Book within 24 Hours Book within 2 working days Get results in only 7 days Open Awards N/A N/A Book within 2 working days Get results in only 16 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information. Difference between NCFE and Pearson Edexcel and Open Awards NCFE, Pearson Edexcel and Open Awards are OFQUAL-regulated and nationally recognised; however, the only difference lies in the exam booking and result turn-around time. You can book your remote online exam within 2 working days of enrolment for NCFE, within 7 working days for Pearson Edexcel and within 3 working days for Open Awards. You can get your NCFE results in 7 days, your Edexcel results in 20 working days and your Open Awards results within 16 working days. All of the awarding bodies are accepted by universities and apprenticeships. This distinction allows learners to choose the awarding body that aligns best with their educational and career goals. How This Course Will Work? This Level 2 Functional Skills Maths course will help you build a solid foundation in mathematics. Throughout the course, it will provide you with various learning materials and activities to enhance your understanding of these subjects. Initial Assessment: To identify the current level of a student's abilities and recommend the appropriate course to enrol in upon completion. Diagnostic Assessment: Identifies skill gaps and produces an individual learning plan Learning Resources: Comprehensive video tutorials, practice quizzes & topic-based tests Progress Tracker: To record your progress in the course Free Mock Test: Access our free mock test facility for professional feedback and to prepare for the final exam. Entry Requirement This level 2 maths qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. However, you will require a laptop/desktop computer and a good internet connection. Exam Structure The Functional Skills NCFE, Pearson Edexcel and Open Awards Qualification in Mathematics Level 2 consist of one externally assessed assessment that comprises two sections- a non-calculator section (calculator prohibited) and a calculator section (calculator permitted). The assessments are available as paper-based and onscreen, on-demand assessments.  Section A (Non-calculator) Awarding Body Exam Duration Total Marks Questions Cover Edexcel 25 minutes 16 25% NCFE / Open Awards 30 minutes 15 25%   Section B (Calculator) Awarding Body Exam Duration Total Marks Questions Cover Edexcel 1 hour 30 minutes 48 75% NCFE / Open Awards 1 hour 30 minutes 45 75% Pass Mark (NCFE): Learners are required to achieve an overall (from sections A and B) (57% – 62%) mark to pass the exam. Please note, that the marks varies for individual exam papers so for all the exam papers the pass marks is not fixed for the NCFE exam.  Pass Mark (Open Awards): Pass Marks for Level 2 Maths assessments vary per assessment version and are set following standardisation and awarding activities.  Each Maths assessment is designed to enable a minimally competent learner to achieve a pass mark of 36 out of 60. However, the awarding process will determine specifically where the pass mark sits for each assessment version. Therefore, the pass mark may vary between assessments. Recognised Accreditation This Functional Skills Maths Level 2 has been independently accredited by Pearson Edexcel, NCFE and Open Awards also regulated by Ofqual. The Office of Qualifications and Examinations Regulation (Ofqual) is responsible for regulating qualifications, assessments, and examinations in England. Pearson Edexcel is the most prestigious awarding body, for an academic and vocational qualifications. Pearson Edexcel qualifications are regulated by Ofqual and recognised by universities and employers across the world. NCFE is a charity and awarding organisation that provides qualifications in England, Wales, and Northern Ireland. It is regulated by Ofqual in England and recognised in Wales and Northern Ireland. Open Awards is an awarding organisation that offers a wide range of qualifications across various sectors, including education, health and social care, and business. Their qualifications are regulated by Ofqual and are designed to meet the needs of learners and employers. Open Awards also works closely with educational institutions and employers to ensure their qualifications are relevant and up-to-date. Additional Features  Access to On-Demand Classes Opportunity to Book 1:1 Live Tutor Support via Zoom Enrol in Our Course and Prepare for the Exam from Home Get a Free Mock Test with Professional Feedback Course Curriculum Unit 1: Number Lesson 1.1: Numbers and the Number System The number system gives you a general insight into the mathematical operations regarding the given numbers. You will acquire skills in division, multiplication, addition and subtraction, which require steps in real-life contexts. Lesson 1.2: Fractions and Decimals You will be learning many types of fractions, including improper fractions, proper fractions, equivalent fractions and more. Along with this, you will learn Ordering Decimal Numbers, Subtracting Decimals, multiplying and dividing decimals and more, which enables you to apply real-world problem-solving. Lesson 1.3: Percentages You will learn to calculate the Percentage and how to express a Number as a Percentage of Another. Interpreting the Original Value, Calculating Percent Increase and Decrease, and so on. This learning you can easily apply in real-life counting issues along with increasing your rational thinking. Lesson 1.4: Ratio and Proportion You will be learning to calculate the Total Amounts using Ratios, direct Proportion, Inverse Proportion and many more things, which help you in doing comparisons, learning science and engineering and more. Lesson 1.5: Formula You will learn the definition of formulas Formula Using Words, Multi-Step Formulas, Formula Using Letters and so on. Learning formulas has a large impact on real life as these formulas are used extensively in measuring, building infrastructure and more. Unit 2: Measures, Shapes and Space Lesson 2.1: Money Math You will be mastering Solving Money Related Questions, including percentage-based discounts, discounts Related to Fractions, Profit and Percentage, etc. This money math learning will help you to understand money-earning and saving-related issues that you face in daily activities. Lesson 2.2: Units You will learn units and Types of Units, Units of Weight, Units of Length, Units of Capacity, etc. Also, you will gain knowledge about steps to convert between Metric Units, Imperial to Imperial Conversions, and Other Unit Conversions will help pursue a higher university degree. Lesson 2.3: Speed and Density You will be clearing the concept of speed, calculations to find out distance and time, density, Relation between Density, Weight and Volume. Lesson 2.4: Perimeter You will learn to find perimeter and area, Circle, perimeter of triangle etc. which require in measurement, design and planning and so on. Lesson 2.5: Area and Shapes You will gain skills in formulas for calculating area, finding areas of complex shapes, applying area calculations in complex questions, different Types of 3D Shapes, surface area, finding the surface area of complex 3D Shapes, using nets, plans and elevations, etc. learning about area and shapes will certainly help you in building your dream home and more. Lesson 2.6: Volume In the volume classes, you will learn Formulas for calculating volume, Questions based on volumes of different 3D Shapes, finding the Scale in a Diagram, Making Scale Drawings, which are required in building critical thinking skills and more. Lesson 2.7: Coordinates & Angles You will be learning necessary things about the coordinate Grid, How to Read Coordinates on a Grid? Plotting Points on a Grid and more which extensively requires in making video games, medical imaging, physics and more. Unit 3: Handling Data and Information Lesson 3.1: Median and Mode You will be learning about median and mode, which is one of the most interesting mathematical chapters. As you will know how to find the median and mode from the sets of numbers, you can easily implement such learning in household work and other places as well. Lesson 3.2: Mean and Range You will be able to find the mean, median and mode. Knowing how to find these is highly important in all aspects of life. Lesson 3.3: Probability You will learn Probability: Definition and Meaning, Calculating Probabilities, Probability of Something Happening and Something Not Happening, etc. Once you know how to find probability, you can easily detect business profit loss and implement other parts of your life. FAQs The Functional Maths level 2 Course is equivalent to? The functional skills Math level 2 is equivalent to GSCE Maths pass grade. Which one is more difficult between Functional and GCSE Maths courses? The functional skills Maths course is more flexible than the GCSE math course since you have to sit for the official exam in the GCSE courses. Why should I take the Functional Skills Maths instead of the GCSE Maths? The functional maths course is comparatively easier than the GCSE math and additionally the value of it is also more than the GCSE math course. However, you should select the course that suits your needs, as both courses provide different values for different people. How will I purchase this course? First, select your desired course plan among the multiple existing course plans on the right side of your screen, then select the payment type, and once you made the payment, you can access the course any time you want. How will I access the functional skills level 2 course after payment? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with Lead Academy. Will I get access to the Course if my location is outside the UK? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol in our courses. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realize the benefit of having an accredited certificate once you face the corporate world. As employees, job places, and more value the accredited certificate, you must own this certificate by doing the course with us. What is an Edexcel accredited course? Exdexcel is a British multinational education and examination body. If any functional skills training providers claim the course is Edexcel accredited, that means the course has been approved by the governor body of Edexcel. Their certificates have been valued in the UK and worldwide. Is functional skills level 2 maths equivalent to gcse? Functional Skills Level 2 of Maths is equivalent to a GCSE at grade 4 (C) or above. This means that achieving a Level 2 qualification in Functional Skills Maths demonstrates the same level of knowledge and maths skills as attaining a Grade 4 or higher in GCSE Maths. For further information, do give a read to our blog, 'What is Functional Skills Maths Level 2 Equivalent To?' Is this qualification hard? The difficulty may vary depending on the individual's prior knowledge and skill level in maths. However, it is generally considered equivalent in difficulty to a GCSE Grade 4/C, a standard proficiency level in maths. However, with adequate preparation and practice, many individuals find it manageable to achieve a pass. What are the system requirements for remote exam? For Pearson Edexcel and NCFE: To sit your assessment, you’ll need: A laptop/desktop with webcam and microphone; you can’t sit the assessment on a tablet or smartphone a good Wi-Fi connection – recommended minimum 1Mbit/s Upload, minimum 10Mbit/s Download. You MUST use google chrome browser for the exam, as this is recommended by the awarding body. A smartphone or tablet (Apple iOS 8.0 / Android 4.1 or higher) - this will be used to record you taking the assessment. A suitable environment - quiet room with no distractions The link for the assessment sent to your email; remember to check your spam/junk folder. You must activate Airplane mode on your smartphone however you need to be connected to Wi-Fi, so turn on Airplane mode then reactivate your Wi-Fi. Please familiarise yourself with the potential violations as these can potentially lead to the assessment being voided. Ensure ALL equipment is plugged in (including phone for the recording of sessions). Loss of power at any point could lead to the assessment being voided. You must brief other members of your household/workplace that you’re sitting an assessment, and they must not enter the room at any point. There is a 24-hour live chat function within the assessment software for technical support should you need it at any time. For Open Awards: In order to take your exam, you need to have the following equipment: A good quality laptop or PC with a minimum screen size of approx. 14” and minimum resolution of 1024 x 768. A stable internet connection with at least 3mbps. An integrated (i.e., fixed) webcam on your PC/ laptop or a portable webcam. If using a PC/ laptop with an integrated webcam, a reflective surface (e.g., a mirror) must be available. This will be used to show the invigilator the space immediately surrounding your screen and keyboard. A basic (non-scientific) calculator for maths assessments. You will have access to an on-screen calculator but may feel more comfortable using a separate calculator. Please note that all workings need to be added to the assessment platform if you use a separate calculator so that your workings can be marked. Plain paper. You will need to show this to your invigilator at the beginning of the exam to assure them that you do not have access to notes. A dictionary (where allowed). Supported Browsers Chrome: 34.0.1847 or above Microsoft Edge: Version 88.0.705.81 or newer Firefox: 31.0 or above Safari: 6.2 or above Safe Exam Browser 2.0.2 or above Please note: Chromebooks are not compatible with the Safe Exam Browser Browser settings Popups must be allowed. Guidance on how to do this below: Chrome Edge Firefox Safari

Follow your dreams by enrolling on the Microsoft Excel Masterclass course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel Masterclass will help you arm yourself with the qualities you need to work towards your dream job. Study the Microsoft Excel Masterclass training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel Masterclass course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Microsoft Excel Masterclass course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel Masterclass course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Microsoft Excel Masterclass course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Excel Masterclass course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel Masterclass course. The Microsoft Excel Masterclass course is designed by industry experts and is tailored to help you learn new skills with ease.  The Microsoft Excel Masterclass is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Excel Masterclass when it suits you. Access the Microsoft Excel Masterclass course modules from any internet-enabled device, including computers, tablets, and smartphones. The Microsoft Excel Masterclass course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel Masterclass now and start learning instantly! What You Get Out Of Studying Microsoft Excel Masterclass With Janets: Receive a digital Certificate upon successful completion of the Microsoft Excel Masterclass course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Microsoft Excel Masterclass training course is delivered through Janets' online learning platform. Access the Microsoft Excel Masterclass content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel Masterclass course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Microsoft Excel Masterclass course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel Masterclass course. After successfully passing the Microsoft Excel Masterclass course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel Masterclass qualification. Certification All students who successfully complete the Microsoft Excel Masterclass course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Excel Masterclass course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Microsoft Excel Masterclass is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel Masterclass course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Microsoft Excel Masterclass is open to all students and has no formal entry requirements. To study the Microsoft Excel Masterclass course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Microsoft Excel Masterclass is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel Masterclass and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Microsoft Excel Beginners 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 Workbooks - Microsoft Excel Beginners Workbooks - Microsoft Excel 2019 00:00:00 Microsoft Excel Intermediate Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 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 Workbooks - Microsoft Excel Intermediate Workbooks - Microsoft Excel Intermediate 00:00:00 Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Use Links and External References 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 Workbooks - Microsoft Excel Advanced Workbooks - Microsoft Excel Masterclass 00:00:00 Mock Exam Mock Exam - Microsoft Excel Masterclass 00:20:00 Final Exam Final Exam - Microsoft Excel Masterclass 00:20: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.