3803 Office Skills courses in Morpeth delivered Online

The Ultimate Dot Net Training for Everyone Course is designed to elevate your programming prowess with a clear, well-organised approach to mastering the .NET framework. Whether you’re a complete beginner or looking to sharpen your coding talents, this course presents a logical progression through essential concepts and advanced techniques, ensuring a smooth learning journey. With an emphasis on clarity and precision, you’ll gain confidence in developing applications using the latest Microsoft technologies, all at your own pace and convenience. Forget the jargon and unnecessary fluff—this course offers focused lessons packed with relevant examples and insightful explanations that make complex topics approachable and even enjoyable. Dive into the world of .NET and discover how to create efficient, robust software solutions without the fuss. Ideal for aspiring developers and tech enthusiasts alike, this training is your trusted companion for unlocking the full potential of the .NET platform—no travel, no fuss, just pure learning delivered straight to your screen. Learning Outcomes: Gain a solid understanding of the .NET framework and its capabilities. Learn how to program in C# and create basic software applications. Discover how to handle exceptions, work with databases, and create games and chatbots. Understand the principles of object-oriented programming and their applications in software development. Learn how to create robust and scalable software applications using the .NET framework. The Ultimate Dot Net Training for Everyone course is designed to provide you with the skills and knowledge you need to become a proficient .NET software developer. Starting with the basics of C# programming and moving on to more advanced topics, this course covers everything you need to know to create robust and scalable software applications. You'll learn how to work with databases, handle exceptions, and even create your own games and chatbots. Along the way, you'll gain a solid understanding of the principles of object-oriented programming and its applications in software development. Ultimate Dot Net Training for Everyone Course Curriculum Section 01: Installation Section 02: Basics on C# Programming Section 03: Conditional Constructs Section 04: Loops Section 05: Arrays and For loop Section 06: Methods Section 07: OOPS Concepts Section 08: Project - Creating a Login Page Section 09: File Handling Section 10: Exception Handling Section 11: Database Connectivity Section 12: Project - Creating a login Page Using DB Connectivity Section 13: Working with Database Section 14: Project - Flappy Bird Game Section 15: Project - Baneful Game Section 16: Project - Chabot Section 17: Project - Online Examination System How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals who are new to programming and want to learn about the .NET framework. Experienced programmers who want to expand their skills and knowledge in .NET development. Entrepreneurs who want to develop their own software applications using .NET. Students who want to enhance their skills in software development and prepare for a career in the field. Anyone who wants to develop their skills in the software development industry. Career path Junior .NET Developer: £20,000 - £35,000 .NET Developer: £28,000 - £55,000 Senior .NET Developer: £40,000 - £80,000 Software Engineer: £28,000 - £60,000 Chief Technology Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Fractions are the building blocks of many mathematical concepts, and this course is designed to make them approachable and clear. Whether you’re revisiting fractions after some time or encountering them with fresh curiosity, this course offers a straightforward exploration of how fractions work, why they matter, and how to confidently manipulate them. From recognising numerators and denominators to mastering addition, subtraction, multiplication, and division of fractions, you’ll develop a solid grasp that forms the foundation for further mathematical learning. With carefully structured lessons that break down each concept into digestible parts, this course avoids unnecessary jargon and keeps the focus on what really matters—understanding fractions with clarity and confidence. Suitable for learners at various levels, it provides the clarity and support needed to boost both knowledge and self-assurance. If numbers sometimes seem like a puzzle, this course is the friendly guide to making fractions less puzzling and more manageable. Learning Outcomes: Develop a foundational understanding of fractions and their applications in math Learn how to add, subtract, multiply, and divide fractions Gain confidence in solving fraction problems and applying mathematical concepts Expand your understanding of practical applications of fractions in real-world scenarios Prepare for more advanced math courses or exams that involve fractions The Mathematics Fundamentals - Fraction course is designed to provide learners with a comprehensive understanding of fractions and their applications in math. Through engaging lessons, expert guidance, and a proven curriculum, learners will gain the skills and confidence they need to solve fraction problems. Upon completing this course, learners will have a solid foundation in fractions and be prepared for more advanced math courses or exams. With a focus on developing practical skills in adding, subtracting, multiplying, and dividing fractions, this course is the key to unlocking your potential and achieving success in math. Mathematics Fundamentals - Fraction Course Curriculum Introduction Introduction Fractions Lesson 1 - Finding fractions of whole numbers Lesson 2 - Multiplying fractions Lesson 3 - Simplifying fractions Lesson 4 - Simplifying fractions Lesson 5 - The 3 times table Lesson 6 - Tips for simplifying any fraction Lesson 7 - Multiplying fractions with whole numbers Lesson 8 - Dividing fractions Lesson 9 - Turning improper fractions into mixed fractions Lesson 10 - Turning improper fractions into mixed fractions Lesson 11 - Turning improper fractions into mixed fractions Lesson 12 - Turning improper fractions into mixed fractions Lesson 13 - Turing mixed fractions into improper fractions Lesson 14 - Turning mixed fractions into improper fractions Lesson 15 - Dividing fractions Lesson 16 - Dividing fractions Lesson 17 - Dividing with fractions and whole numbers Lesson 18 - Dividing with fractions and whole numbers Lesson 19 - Adding fractions Lesson 20 - Adding fractions Lesson 21 - Adding fractions Lesson 22 - Adding fractions Lesson 23 - Adding fractions Lesson 24 - Subtracting fractions Lesson 25 - Subtracting fractions Lesson 26 - Subtracting fractions Lesson 27 - Whole numbers subtracting fractions Lesson 28 - Whole numbers subtracting fractions Lesson 29 - Recap Lesson 30 - Practice questions Lesson 31 - Practice questions Lesson 32 - Practice questions Lesson 33 - Practice questions Lesson 34 - Practice questions Lesson 35 - Practice questions Lesson 36 - Practice questions Lesson 37 - Practice questions How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students struggling with fractions in their math classes Individuals seeking to improve their math skills for personal or professional reasons Professionals seeking to enhance their math skills in their careers Anyone interested in expanding their understanding of fractions and their applications in math Students preparing for math exams or courses that involve fractions Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Engineer Architect Mathematician Statistician Financial analyst £20,000 - £70,000+ (depending on career path and experience) Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Whether you're brushing up or building from scratch, the Ultimate Dot Net Training for Everyone Course is tailored for those who want to get to grips with the .NET framework without the headache. Covering everything from the basics of C# to more structured application development using modern .NET features, this course offers a straight-talking guide through the platform’s essentials—minus the noise, filler, and waffle. You’ll follow a logical progression designed to make sure concepts stick, without needing to decipher cryptic docs or sit through endless theory slides. The content has been crafted with clarity, structure, and a touch of dry wit—because learning doesn’t have to feel like reading a manual from the 90s. Whether you’re interested in developing sleek APIs, building reliable backends, or just understanding how .NET pieces fit together, this course gives you the tools to do just that—digitally, remotely, and at your own pace. It’s a solid, no-frills walkthrough for anyone keen to make sense of Microsoft’s development stack, whether you're exploring it for the first time or picking it back up after a few versions off. Learning Outcomes: Gain a solid understanding of the .NET framework and its capabilities. Learn how to program in C# and create basic software applications. Discover how to handle exceptions, work with databases, and create games and chatbots. Understand the principles of object-oriented programming and their applications in software development. Learn how to create robust and scalable software applications using the .NET framework. The Ultimate Dot Net Training for Everyone course is designed to provide you with the skills and knowledge you need to become a proficient .NET software developer. Starting with the basics of C# programming and moving on to more advanced topics, this course covers everything you need to know to create robust and scalable software applications. You'll learn how to work with databases, handle exceptions, and even create your own games and chatbots. Along the way, you'll gain a solid understanding of the principles of object-oriented programming and its applications in software development. ⊱⊱ Ultimate Dot Net Training for Everyone Course Curriculum Section 01: Installation Section 02: Basics on C# Programming Section 03: Conditional Constructs Section 04: Loops Section 05: Arrays and For loop Section 06: Methods Section 07: OOPS Concepts Section 08: Project - Creating a Login Page Section 09: File Handling Section 10: Exception Handling Section 11: Database Connectivity Section 12: Project - Creating a login Page Using DB Connectivity Section 13: Working with Database Section 14: Project - Flappy Bird Game Section 15: Project - Baneful Game Section 16: Project - Chabot Section 17: Project - Online Examination System How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals who are new to programming and want to learn about the .NET framework. Experienced programmers who want to expand their skills and knowledge in .NET development. Entrepreneurs who want to develop their own software applications using .NET. Students who want to enhance their skills in software development and prepare for a career in the field. Anyone who wants to develop their skills in the software development industry. Career path Junior .NET Developer: £20,000 - £35,000 .NET Developer: £28,000 - £55,000 Senior .NET Developer: £40,000 - £80,000 Software Engineer: £28,000 - £60,000 Chief Technology Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Overview   With the ever-increasing demand for Data Entry in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Data Entry may be.   Learning about Data Entry or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Data Entry. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Data Entry is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by Compete High in this Data Entry Training course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Data Entry Training course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Data Entry Training course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Data Entry, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Data Entry, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Data Entry, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Data Entry Training course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Module 1 - Introduction to Data Entry Introduction to Data Entry 00:00 Module 2 - Types of Data Entry Types of Data Entry 00:00 Module 3 - Data Entry Jobs Data Entry Jobs 00:00 Module 4 - Data Entry Standards -Guidelines and Examples Data Entry Standards -Guidelines and Examples 00:00 Module 5 - Using Excel for Efficient Data Entry Using Excel for Efficient Data Entry 00:00 Module 6 - Using Flash Fill in Excel Using Flash Fill in Excel 00:00 Module 7 - How to Create a Data Entry Form in Excel How to Create a Data Entry Form in Excel 00:00 Module 8 - Managing Workbooks Managing Workbooks 00:00

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Overview This comprehensive course on Microsoft Excel Training: Depreciation Accounting will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel Training: Depreciation Accounting comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Microsoft Excel Training: Depreciation Accounting. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel Training: Depreciation Accounting is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so 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 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 7 sections • 16 lectures • 01:01:00 total length •Introduction: 00:03:00 •Minimum requirements before taking the course: 00:01:00 •Download master depreciation template: 00:00:00 •Definition of Depreciation: 00:02:00 •Amortization: Depreciation vs Amortization: 00:02:00 •Related Terms to Depreciation: 00:02:00 •Most Common Methods of Depreciation: 00:09:00 •Accounting for Depreciation: 00:05:00 •Depreciation Tax Shield: 00:04:00 •Depreciation Tax Shield Under Various Depreciation Methods: 00:03:00 •Introduction and basics of Depreciation Model in Excel: 00:01:00 •Deep Dive into Depreciation Model: 00:07:00 •How to use the model with Example: 00:10:00 •Advanced functionalities of the Model: 00:11:00 •Thank you for Enrolling: 00:01:00 •Resources - Microsoft Excel Training: Depriciation Accounting: 00:00:00

Overview This comprehensive course on Excel Pivot Tables, Pivot Charts, Slicers, and Timelines will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables, Pivot Charts, Slicers, and Timelines comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Excel Pivot Tables, Pivot Charts, Slicers, and Timelines. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables, Pivot Charts, Slicers, and Timelines is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 15 lectures • 01:21:00 total length •Getting started with your Pivot Table: 00:04:00 •Drill Down: 00:01:00 •Managing the Field List: 00:02:00 •Changing the Calculation type with Value Field Settings: 00:06:00 •Growing your Pivot Table with Multiple Fields: 00:04:00 •Formatting the Pivot Table: 00:05:00 •Sorting and Filtering the Pivot Table: 00:03:00 •Creating a Dashboard with Slicers, Timelines and Pivot Charts: 00:09:00 •Reporting by day, month, qtr, or year within the Pivot Table: 00:04:00 •Refreshing the Pivot Data with new data: 00:03:00 •Adding your own calculations into the Pivot Table: 00:03:00 •The power of the Filter Section in the Pivot Table: 00:04:00 •PowerQuery: 00:12:00 •PowerPivot: 00:21:00 •Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines: 00:00:00

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 5 sections • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel 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 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •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 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •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 •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 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •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 •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:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08: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 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00

Overview This comprehensive course on Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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 2 sections • 23 lectures • 01:56:00 total length •Excel promo: 00:01:00 •Getting the most of the course: 00:01:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:06:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!: 00:00:00