3412 Office Skills & Productivity courses in Bradford delivered Online

Description The Oracle Database server composes PL/SQL units and stores it in the database. Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? Oracle 11g PL/SQL Intermediate 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 Oracle 11g PL/SQL Intermediate 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. Introduction Introduction FREE 00:03:00 Preparing Your Environment Install Oracle XE 00:11:00 SQL Developer Installation 00:20:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: If you already have the basic and intermediate knowledge and skills of Microsoft Outlook 2010 then this advanced level is designed for you. This Microsoft Office 2010 Outlook Advanced - Complete Video Course builds on the skills and concepts taught in Outlook 2010: intermediate. Here, you will personalize and organize your e-mail as well as customize an Outlook form, archive your e-mail files and learn advance techniques to manage contacts and work remotely. Learn how to stay connect with colleagues via the Outlook Social Connector, advanced techniques for managing and maintaining mailboxes, creating and work with notes and journal entries, share Outlook calendars and contacts, create customized e-mail templates, and use mail merge to send personalized messages to groups of contacts, and much more. This advanced series will help you to upgrade your knowledge and skills on Microsoft Outlook 2010. So be an expert by learning from this course. 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 2010 Outlook 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 2010 Outlook 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. Collaboration Connecting with Colleagues via Outlook Social Connectors FREE 00:20:00 Staying Informed with RSS 00:09:00 Mailbox Management Managing Your Mailbox 00:27:00 Archiving Your Mail 00:13:00 The Notes and Journal Folders Recording Information with 00:14:00 Tracking Activities with the Journal 00:15:00 Calendars and Contacts Managing Your Calendar 00:24:00 Managing Contacts 00:13:00 Mail Merges and Templates Performing Mail Merges 00:18:00 Working with Templates 00:12:00 Mock Exam Mock Exam- Microsoft Office 2010 Outlook Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Outlook Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Learn all the essential skills to become an expert in Functional IT. From this comprehensive Functional Skills - IT course, you will be able to understand the principles of Functional IT. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Functional Skills - IT is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Learning Outcomes Get a deep understanding of the fundamentals of Information Technology (IT) Master all the IT Components Understand how operating systems work Master software building tools and languages Learn how information flows within IT and how Storage Companies and Technologies work Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Functional Skills - IT course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Functional Skills - IT course, learn the vital abilities and knowledge you require to succeed in your life. Section 01: Introduction Unit 01: Introduction 00:01:00 Unit 02: Course Outline 00:06:00 Section 02: Information Technology Unit 01: Facts about Information Technology (IT) 00:05:00 Unit 02: What is Information Technology & How IT Works 00:02:00 Section 03: Components of IT Unit 01: IT Components 00:02:00 Section 04: Hardware Unit 01: What is Hardware 00:02:00 Unit 02: Examples of Computer 00:02:00 Unit 03: Computer Hardware Manufacturers 00:04:00 Unit 04: Hardware Jobs 00:05:00 Section 05: Operating System Unit 01: What is Operating System 00:02:00 Unit 02: Examples of Operating System 00:08:00 Unit 03: Operating System Jobs 00:10:00 Unit 04: OS Tools Related Jobs 00:02:00 Section 06: Application/Software Unit 01: What is Application/Software 00:03:00 Unit 02: Software Building Tools and Languages 00:03:00 Unit 03: Software/Application Building Jobs 00:03:00 Unit 04: Software/Application User Jobs 00:03:00 Section 07: Networking Unit 01: What is Computer Networking 00:02:00 Unit 02: Computer Network Companies 00:02:00 Unit 03: Network Jobs 00:04:00 Section 08: Security Unit 01: What is Computer Security 00:02:00 Unit 02: Security Companies 00:01:00 Unit 03: Security Jobs 00:03:00 Section 09: Traffic Flow & Enterprise Level IT Components Unit 01: How Information Flow within IT 00:02:00 Unit 02: Enterprise Level IT Components 00:02:00 Section 10: Storage Unit 01: What is Storage 00:05:00 Unit 02: Storage Companies and Technologies 00:02:00 Unit 03: Jobs in Storage 00:02:00 Section 11: Database Unit 01: What is Database 00:02:00 Unit 02: Database Type and Technologies 00:04:00 Unit 03: Database Jobs 00:02:00 Section 12: Virtualisation & Cloud Unit 01: What is Virtualisation 00:03:00 Unit 02: What is Cloud Technology 00:02:00 Unit 03: Virtualisation and Cloud Companies 00:02:00 Unit 04: Virtualisation and Cloud Jobs 00:02:00 Section 13: Management & Other IT Jobs Unit 01: IT Management Jobs 00:03:00 Unit 02: Other IT Jobs 00:09:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

The Introduction to Material Management course provides a comprehensive understanding of material management principles and practices. Participants will explore topics such as purchasing, supply chain management, inventory control, forecasting, and materials handling to enhance their knowledge and skills in effective material management. Learning Outcomes: Understand the fundamentals and importance of material management. Learn about purchasing processes and supply chain management in material acquisition. Master inventory management techniques and planning for efficient stock control. Gain insights into stores management and control to optimize material handling. Explore various forecasting methods to anticipate material needs accurately. Implement material requirements planning (MRP) to optimize resource allocation. Enhance knowledge of materials handling techniques and equipment for efficient operations. Develop strategies for cost-effective and sustainable material management practices. Why buy this Introduction to Material Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Introduction to Material Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Procurement professionals looking to enhance their material management skills. Inventory and warehouse managers aiming to optimize stock control. Supply chain professionals seeking a deeper understanding of material flow. Operations managers interested in improving overall material handling and planning. Prerequisites This Introduction to Material Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Introduction to Material Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Material Manager: Oversee material procurement, storage, and distribution processes. Supply Chain Analyst: Analyze supply chain data to improve material flow. Inventory Control Specialist: Manage inventory levels and optimize stock management. Operations Coordinator: Coordinate material handling and logistics in an organization. Purchasing Officer: Handle purchasing activities and supplier relationships. Course Curriculum Module 01: Introduction to Material Management Introduction to Material Management 00:14:00 Module 02: Purchasing and Supply Chain Management Purchasing and Supply Chain Management 00:15:00 Module 03: Inventory Management, Planning and Control Inventory Management, Planning and Control 00:17:00 Module 04: Stores Management and Control Stores Management and Control 00:24:00 Module 05: Forecasting Forecasting 00:13:00 Module 06: Material Requirements Planning Material Requirements Planning 00:22:00 Module 07: Materials Handling Materials Handling 00:14:00 Assignment Assignment - Introduction to Material Management 00:00:00

Embark on a transformative learning journey with our course, 'Microsoft Teams - Master Microsoft Teams.' Unleash the full potential of Microsoft Teams as you delve into an immersive curriculum that goes beyond the basics. From mastering the essentials of Teams' interface to advanced tips and tricks, this course is your key to becoming a Teams maestro. Dive into the world of team and member management, collaborative document editing with Word, Excel, and PowerPoint, and efficient communication through voice and video calls. Whether you're new to Teams or seeking to elevate your proficiency, this course offers a holistic understanding of Teams' functionalities, empowering you to navigate its intricacies effortlessly. Learning Outcomes Gain comprehensive knowledge of Microsoft Teams, from installation to advanced settings. Master team and member management, ensuring seamless collaboration. Explore the intricacies of managing channels and optimizing communication through chat. Harness the power of collaborative document editing with Word, Excel, and PowerPoint. Implement advanced tips and tricks, from shortcuts and customizations to private channels and channel notifications. Why choose this Microsoft Teams - Master Microsoft Teams course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Teams - Master Microsoft Teams course for? Business professionals aiming to enhance collaboration within their teams. Remote workers looking to optimize their use of Microsoft Teams for effective communication. Project managers seeking to streamline team management and communication. Small business owners exploring efficient and cost-effective collaboration tools. Students and educators interested in utilizing Teams for virtual classrooms and group projects. Career path Collaboration Specialist: £30,000 - £50,000 Project Manager (Remote Teams): £35,000 - £55,000 IT Support Analyst: £25,000 - £45,000 Business Communication Manager: £40,000 - £60,000 Education Technology Specialist: £35,000 - £55,000 Digital Workspace Consultant: £45,000 - £70,000 Prerequisites This Microsoft Teams - Master Microsoft Teams does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Microsoft Teams - Master Microsoft Teams was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Microsoft Teams - Introduction PROMO Video 00:01:00 Introduction on Microsoft Teams 00:02:00 Free and Paid versions 00:02:00 Accessing Teams - Web or Desktop 00:02:00 Installing Desktop 00:02:00 Mastering Microsoft Teams Managing Teams and Members 00:05:00 Inviting Members 00:05:00 Managing Channels 00:07:00 Chat 00:04:00 Collaboration with Word, Excel, PowerPoint 00:10:00 Voice & Video Calls 00:05:00 Meetings - Available on the Paid version of Microsoft Teams 00:03:00 Adding More Apps 00:08:00 Activity 00:02:00 Search Bar 00:03:00 Settings 00:05:00 Multiple Organizations 00:02:00 Microsoft Teams Mobile 00:05:00 Top Microsoft Teams Tips TIP#1 - Forwarding Email 00:03:00 TIP#2 - Saving Items 00:01:00 TIP #3 - Naming Group Chats 00:01:00 TIP #4 - Connectors 00:03:00 TIP #5 - Live Captions in Meetings 00:02:00 TIP #6 - Top Shortcuts 00:03:00 TIP #7 - Customize the Environment 00:03:00 TIP #8 - Channel Notifications 00:02:00 TIP #9 - Private Channels 00:02:00 TIP #10 - Pin Channels 00:01:00 TIP #11 - Post Announcements 00:02:00

Dive deep into the dynamic world of web development through the 'ASP.Net MVC and Entity Framework Course'. Navigate the complexities of setting up a robust ASP.Net MVC application, and then master the nuances of user authentication. But that's not all; this comprehensive course also introduces you to efficient source and package management. Furthermore, elevate your coding prowess by seamlessly integrating JQuery and Ajax into your projects. Learning Outcomes Establish and configure an ASP.Net MVC application. Implement secure user authentication strategies. Efficiently manage source codes and software packages. Integrate JQuery for enhanced client-side scripting. Incorporate Ajax for asynchronous web functionalities. Why choose this ASP.Net MVC and Entity Framework Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the ASP.Net MVC and Entity Framework Course Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this ASP.Net MVC and Entity Framework Course for? Web developers eager to expand their skill set. Computer science students focused on web technologies. Professionals transitioning to web-based projects. Entrepreneurs looking to manage web projects effectively. Tech enthusiasts wanting to understand ASP.Net MVC and Entity Framework. Career path ASP.Net Developer: £30,000 - £50,000 MVC Framework Specialist: £32,000 - £52,000 Web Application Developer: £28,000 - £48,000 Back-end Developer: £31,000 - £53,000 Web Project Manager: £35,000 - £55,000 Entity Framework Specialist: £33,000 - £53,000 Prerequisites This ASP.Net MVC and Entity Framework Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This ASP.Net MVC and Entity Framework Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01 : Setup ASP.Net MVC Application Module 01: Install Visual Studio Community Edition 00:02:00 Module 02: Create ASP.Net MVC Project 00:04:00 Module 03: Setup Database 00:06:00 Module 04: Add Entity Framework Data Model 00:06:00 Module 05: Tour of Folder Structure and How to Add Views 00:23:00 Module 06: Scaffolding: Adding Controller and Views 00:35:00 Module 07: Managing Database Changes 00:14:00 Module 08: Customizing a View - Bootstrap 00:20:00 Module 09: Customizing a View - Additional Data 00:09:00 Module 10: Add Data Validations to Forms 00:31:00 Unit 02 : User Authentication Module 01: Understanding Authentication Functionality 00:05:00 Module 02: Adding User Data Points 00:30:00 Module 03: Control User Access 00:07:00 Module 04: Adding Roles and Authorizations 00:37:00 Unit 03 : Source and Package Management Module 01: Add Project to GitHub 00:12:00 Module 02: Understanding Package Management 00:08:00 Unit 04 : Using JQuery an Ajax Module 01: Add Lecturer and Enrollment Management Modules 00:14:00 Module 02: Install JQueryUI Javascript Libraries 00:12:00 Module 03: Implement JQueryUI Autocomplete 00:35:00 Module 04: Create an JQuery/Ajax Form 00:34:00 Module 05: Partial View and Data Refresh 00:33:00 Resourse Resource - ASP.Net MVC and Entity Framework Course 00:00:00 Assignment Assignment - ASP.Net MVC and Entity Framework Course 00:00:00

🚀 Unlock Your Excel Potential with the Microsoft Excel Crash Course 2024: Masterclass for Weekend! 🚀 Are you tired of spending endless hours trying to figure out Microsoft Excel on your own? Do you want to boost your skills and become an Excel pro without sacrificing your entire weekend? Look no further - our Microsoft Excel Crash Course 2024 is here to revolutionize the way you work with spreadsheets!   🔥 Why Excel Matters: In today's data-driven world, Excel proficiency is a non-negotiable skill. Whether you're a student, a professional, or someone looking to enhance your productivity, mastering Excel can open doors to new opportunities.   💡 What Sets Our Masterclass Apart: ✅ Weekend-Friendly Format: We get it - your time is precious! That's why our course is designed to be completed over a weekend, giving you the skills you need without disrupting your busy schedule. ✅ Hands-On Learning: Forget boring lectures! Dive straight into hands-on, practical exercises that reinforce your learning. Our step-by-step approach ensures you grasp each concept thoroughly. ✅ Up-to-Date Content: Excel evolves, and so do we! Our 2024 edition is packed with the latest features and best practices, ensuring you're on the cutting edge of spreadsheet mastery. ✅ Expert Guidance: Learn from seasoned Excel experts who've cracked the code to efficient and effective spreadsheet use. Benefit from their real-world insights and insider tips that go beyond basic functions. ✅ Lifetime Access: Purchase once, benefit forever! Gain access to our course materials, updates, and a supportive community, ensuring you stay on top of your Excel game for years to come.   📚 Course Highlights: 👉 Essential Excel Functions: From basic formulas to advanced functions, we cover it all. 👉 Data Visualization: Transform your data into impactful charts and graphs. 👉 Pivot Tables Mastery: Unlock the power of data analysis with Pivot Tables. 👉 Time-Saving Shortcuts: Work smarter, not harder, with keyboard shortcuts. 👉 Advanced Formulas: Impress your colleagues with advanced calculations. 👉 Automation with Macros: Streamline your tasks with Excel automation. 👉 Error Handling: Learn how to troubleshoot and avoid common mistakes.   🎓 Who Should Enroll: Professionals looking to enhance their spreadsheet skills. Students aiming to boost their academic performance. Entrepreneurs and business owners seeking data-driven insights. Anyone wanting to save time and increase productivity.   🌟 Get Ready to Excel! Don't miss out on this opportunity to become an Excel maestro in just one weekend! Enroll now in the Microsoft Excel Crash Course 2024: Masterclass for Weekend and empower yourself with the skills that will set you apart. 👉 Limited seats available. Secure your spot now! 👈 Disclaimer: Results may vary based on individual commitment and practice. Course Curriculum Module- 1 Introduction 00:00 Getting started on Windows, macOS, Android, and IOS 00:00 How to ask great questions 00:00 FAQ 00:00 Start Excel 00:00 Module- 2 Overview of top Excel tips 00:00 Add numbers like a pro 00:00 Save time by filling cells automatically 00:00 Did data enter into one column - Split it 00:00 Switch data around by transposing it 00:00 Sort and filter for quick results 00:00 Create a data table for tasks to make it easy 00:00 Make drop-down list 00:00 Quick Data Analysis 00:00 Great charts for your visualization 00:00 Pivot Tables for Data Analytics 00:00 Module- 3 Introduction 00:00 Basic formula operations 00:00 Mathematical functions level1 00:00 Mathematical functions level2 00:00 Text functions level1 00:00 Text functions level2 00:00 Logical functions 00:00 Date time functions 00:00 V Lookup formula 00:00 HLookup formula 00:00 HLookup Match formula 00:00 Match Index formula 00:00 Module- 4 Introduction 00:00 XLookup 00:00 Handling NA and Approximates match in XLookup 00:00 Wildcard matching in XLookup 00:00 Module- 5 Introduction 00:00 Split Text into columns 00:00 Flash Fill 00:00 Remove Duplicates 00:00 Data Validation 00:00 Get - import Data from Text 00:00 Get - import Data from CSV 00:00 Module- 6 Introduction 00:00 Creating Pivot Table 00:00 Value field settings 00:00 Number format 00:00 Pivot Table Design 00:00 Excel Exercise 00:00 Solution for Excel Exercise 00:00 Module- 7 Introduction 00:00 Excel Charts - Categories 00:00 Elements of a chart 00:00 Easy way to create charts 00:00 Column or Bar charts 00:00 Formatting charts 00:00 Line charts 00:00 Area charts 00:00 Pie and Doughnut charts 00:00 Format Area Plot or XY chart 00:00 Scatter or bubble charts 00:00

Overview   With the ever-increasing demand for MS Excel 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 MS Excel may be.   Learning about MS Excel 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 MS Excel. 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 MS Excel 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 Microsoft Excel Beginner to Intermediate 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 Microsoft Excel Beginner to Intermediate 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 Microsoft Excel Beginner to Intermediate 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 MS Excel, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in MS Excel, Anyone looking for a certificate of completion on doing an online training on this topic, Students of MS Excel, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Microsoft Excel Beginner to Intermediate 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 01-Excel Interface Module 01-Excel Interface 00:00 Module-02-Basic Functions Module-02-Basic Functions 00:00 Module-03-Working With Worksheet Module 03-Working With Worksheet 00:00 Module-04-Work with Data and Excel tables Module-04-Work with Data and Excel tables 00:00 Module-05-Basic Calculations Module-05-Basic Calculations 00:00 Module-06-Shortcuts in Excels Module-06-Shortcuts in Excels 00:00

🚀 Unleash Your Excel Mastery with 'Microsoft Excel 2016 (Basic to Advanced)' Course! 🚀 Are you tired of spending hours grappling with Excel, only to end up with frustrating and inefficient solutions? Do you dream of becoming the Excel wizard in your workplace, effortlessly creating powerful and efficient solutions? Look no further! Introducing our groundbreaking online course: 'Microsoft Excel 2016 (Basic to Advanced).'   🌟 Why Choose 'Microsoft Excel 2016 (Basic to Advanced)'? ✅ Master Advanced Excel Techniques: Dive deep into the world of Excel with our comprehensive modules that cover everything from advanced formulas and functions to data visualization and analysis. ✅ Practical Real-World Applications: Say goodbye to theoretical lessons! We focus on real-world scenarios, ensuring you can immediately apply your newfound skills to solve complex problems in your professional life. ✅ Build Efficiency: Learn the secrets of crafting efficient and streamlined Excel solutions. From automating repetitive tasks to optimizing complex workflows, you'll become a productivity powerhouse. ✅ Expert-Led Instruction: Our experienced instructors are Excel aficionados with a passion for teaching. Benefit from their wealth of knowledge and insider tips, ensuring you stay ahead of the curve. ✅ Interactive Learning: Engage with hands-on exercises, quizzes, and projects that reinforce your understanding and transform you into a confident Excel pro. ✅ Lifetime Access: Gain unlimited access to the course content, updates, and a supportive community. Your learning journey doesn't end - it evolves.   🎓 What You'll Learn: Advanced Formulas and Functions: Supercharge your spreadsheet skills with complex formulas and functions, unlocking Excel's true potential. Data Visualization Mastery: Transform raw data into visually stunning charts and graphs, making your reports and presentations more impactful. Automation Techniques: Streamline your work by mastering Excel's automation features, saving time and reducing errors. Data Analysis Strategies: Unlock the power of PivotTables, data models, and analysis tools to gain valuable insights from your data. Optimizing Workflows: Learn to design efficient workflows and templates that enhance collaboration and productivity.   🌐 Who Is This Course For? Professionals aiming to boost their Excel proficiency. Entrepreneurs seeking to optimize business processes. Students preparing for a data-driven career. Anyone who wants to stay ahead in today's competitive workplace.   Don't miss out on this opportunity to elevate your Excel skills and stand out in the crowd. Join 'Microsoft Excel 2016 (Basic to Advanced)' today and pave the way for a successful and efficient future! Course Curriculum Microsoft Excel 2016 Basic Pre Sell Video 00:00 Lesson 1 - Overview 00:00 Lesson 2 - Interface 00:00 Lesson 3 - File Menu - Part 1 00:00 Lesson 4 - File Menu - Part 2 00:00 Lesson 5 - Home Menu 00:00 Lesson 6 - Insert Menu 00:00 Lesson 7 - Page Layout Menu 00:00 Lesson 8 - Formulas Menu 00:00 Lesson 9 - Data Menu - Part 1 00:00 Lesson 10 - Data Menu - Part 2 00:00 Lesson 11 - Review Menu 00:00 Lesson 12 - View Menu 00:00 Lesson 13 - Templates 00:00 Lesson 14 - Dates 00:00 Lesson 15 - Numbers 00:00 Lesson 16 - Text 00:00 Lesson 17 - B - Calculations-Manual 00:00 Lesson 18 - Calculations 00:00 Lesson 19 - Page Set Up 00:00 Lesson 20 - Print Settings 00:00 Lesson 21 - Conclusion 00:00 Microsoft Excel 2016 Advanced Lesson 1 - Overview 00:00 Lesson 2 - Calculations - Absolute References 00:00 Lesson 3 - Calculations - Relative References 00:00 Lesson 4 - Using Logical Formulas 00:00 Lesson 5 - Using Text Formulas 00:00 Lesson 6 - Using Lookup Formulas 00:00 Lesson 7 - Using Financial Formulas 00:00 Lesson 8 - Using Date and Time Formulas 00:00 Lesson 9 - Sorting Data 00:00 Lesson 10 - Formatting Data into Tables 00:00 Lesson 11 - Using Pivot Tables - Part 1 00:00 Lesson 12 Using Pivot Tables - Part 2 - Design 00:00 Lesson 13 - Formatting Data as Charts 00:00 Lesson 14 - Formatting As Data as Maps 00:00 Lesson 15 - Formatting Data as Formal Reports 00:00 Lesson 16 - Formatting Data for Other Office Documents 00:00 Lesson 17 - Cell Protection and Collaboration 00:00 Lesson 18 - Cell Protection and Collaboration - Part 2 00:00 Lesson 19 - Interface with Google Sheets 00:00 Lesson 20 - Conclusion 00:00

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00