26917 Courses delivered Online

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is as follows: Data Center engineers Cloud engineers System engineers Field engineers Implementation/operation/support/installation and upgrade specialists IT administrators Network engineers Cloud computing experts Security specialists Cisco integrators and partners Overview Upon completing this course, the learner will be able to meet these overall objectives: Describe items to be aware of before installing a Cisco CSR 1000V, including virtual machine requirements for installing Cisco CSR 1000V, licensing options that are available with Cisco CSR 1000V, supported Cisco IOS XE technologies, and management options for Cisco CSR 1000V. Prepare for installation of Cisco CSR 1000V Series routers. Explain common Cisco IOS XE Command-Line Interface (CLI) commands and conventions that can make it easier to work in the CLI, and describe how you can get help with command syntax and command options. Describe the options you can use to activate the license for Cisco CSR 1000V and activate the license for each option. Troubleshoot issues with Cisco CSR 1000V licenses. Upgrade the Cisco IOS XE software for an existing Cisco CSR 1000V installation. Describe the Call Home feature and its benefits, configure the feature on the Cisco CSR 1000V, including the anonymous reporting option, and display the Call Home configuration. List the different Call Home events that trigger alerts and commands that are executed as a result of the alert. Troubleshoot Cisco CSR 1000V Virtual Machine (VM) issues. Rehost a Cisco CSR 1000V license to a new VM, whether the current Cisco CSR 1000V router is accessible or not. Describe the Virtual Extensible LAN (VXLAN) Layer 2 gateway feature and configure this feature on the Cisco CSR 1000V router. Deploy the Cisco CSR 1000V in a virtual private cloud using Microsoft Azure or Amazon Web Services (AWS). Describe common network operations that the Cisco CSR 1000V supports. Explore programmability support on Cisco CSR 1000V, including APIs, shells, and data models. The Deploying Cloud Connect Solutions with Cisco Cloud Services Router 1000V (CLDCSR) course shows you how to deploy and operate Cisco© Cloud Services Router 1000V (CSR1000V) to provide comprehensive WAN gateway and network services functions including connectivity, routing, and security into virtual and cloud environments. Through expert instruction and hands-on labs, you will learn: Cisco CSR 1000V deployment options and requirements; hypervisor support, licensing models, features and programmability support; and how to implement, integrate, install, manage, and troubleshoot the deployment process and common operation issues.This class will help you:Learn how to use the CSR 1000V Series to extend your enterprise network to public and private cloudsGain hands-on practice acquiring skills in virtual and cloud-based technologies Course Outline Introducing Cisco CSR Product Overview Preparing for Installation Installing Cisco CSR 1000V in VMware Elastic Sky X (ESXi) Environments Booting Cisco CSR 1000V and Accessing the Console Using Cisco IOS XE Software Managing Cisco CSR 1000V Licenses Upgrading the Cisco IOS XE Software Mapping Cisco CSR 1000V Network Interfaces to Virtual Machine Network Interfaces Using GRUB Mode (Bootstrap Program) Configuring Call Home for Cisco CSR 1000V Configuring Virtual CPU (vCPU) Distribution Across Data, Control, and Service Planes Troubleshooting Cisco CSR 1000V Virtual Machine Issues Rehosting a Smart License Supporting the Cisco CSR 1000V Virtual Extensible LAN (VXLAN) Feature Deploying Cisco CSR 1000V in a Virtual Private Cloud Exploring Cisco CSR 1000V Operations Exploring Programmability on Cisco CSR 1000V

Duration 4 Days 24 CPD hours This course is intended for This course is intended for: System engineers Technical support personnel Channel partners and resellers Overview After taking this course, you should be able to: Describe Cisco DWDM platform basics Describe DWDM network topologies Describe the management software used for managing Cisco DWDM networks List the different hardware components of the Cisco ONS and Cisco NCS DWDM systems Provision nodes and circuits in a Cisco DWDM network Perform node and multishelf configurations Implement SMR-based rings Provision optical circuit protection mechanisms Configure Any Rate cards Describe the function of Raman amplifiers Perform basic maintenance and troubleshooting of a Cisco DWDM network The Cisco Optical Technology Intermediate (OPT200) v3.0 course is designed to teach you the skills necessary to deploy the Cisco© Optical Networking System (ONS), 15454 Multiservice Transport Platform (MSTP), and Cisco Network Convergence System (NCS) 2000 Series Dense Wavelength-Division Multiplexing (DWDM) networks from installation to protection. Through a combination of lecture and hands-on experience, you will learn installation, configuration, circuit protection, maintenance, and basic troubleshooting using the Cisco Transport Controller for the Cisco ONS 15454 M6 and M12 shelves, and for the Cisco NCS 2016 shelf.Additionally, in this course you will review DWDM terminology and components, explore available chassis and cards, and discuss hardware installation. You will learn to use the Cisco Transport Controller server software to connect to the nodes, perform network turn-up and circuit creation, and deploy linear and single-module ROADM (SMR) DWDM multishelf topologies. Using this software, you will also configure Raman amplifiers and Any Rate cards, and configure protected and unprotected circuits. The course covers a variety of card options: controllers, transponders, multiplexer-demultiplexer, add/drop, Raman amplifiers, and Cisco Any Rate muxponder cards. You will use the various cards to configure terminal, amplifier, mesh, split, Optical Service Channel (OSC) regenerator, and Reconfigurable Optical Add/Drop Multiplexing (ROADM) nodes. Finally, you will learn how to use many of the tools and features available with the Cisco Transport Controller to perform maintenance, testing, and basic troubleshooting of your optical network. Course Outline DWDM Optical Platform Foundation Chassis and Cards Hardware Installation Node Turn-Up and Circuit Creation Node and Multishelf Configurations SMR-Based Rings 10Gb Circuit Protection Any Rate Card Configuration Raman Amplifiers Maintenance and Basic Troubleshooting Additional course details: Nexus Humans Cisco Optical Technology Intermediate v3.0 (OPT200) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Optical Technology Intermediate v3.0 (OPT200) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Getting Started The LLM International Business Law programme delves into the intricate legal aspects of the global business environment, offering a profound understanding of international trade, contracts, and corporate governance. It equips individuals, including legal professionals, with the expertise needed to navigate the complex legal terrain of international business. The programme is designed for individuals who hold a Qualifi Level 7 Diploma in International Business Law or equivalent qualification.  Anglia Ruskin University provides the LLM International Business Law (Top-Up) programme, a comprehensive and specialised postgraduate qualification tailored to meet the needs of legal professionals and graduates seeking advanced knowledge in international business law. This top-up programme builds upon existing legal knowledge and qualifications, enabling students to grasp the intricate legal intricacies of international business transactions, trade, and commerce. With a strong emphasis on practical application, the program equips students with the essential skills to handle the complexities of global business law, covering areas such as international contracts, trade regulations, dispute resolution, and corporate governance. The curriculum is meticulously designed to remain highly relevant to the ever-evolving demands of the international business landscape, ensuring that graduates are well-prepared to tackle global marketplace challenges. Taught by experienced faculty and supported by cutting-edge resources, the LLM International Business Law (Top-Up) program at Anglia Ruskin University presents an exceptional opportunity for legal professionals and aspiring lawyers to enhance their expertise and advance their careers in the dynamic field of international business law. The LLM International Business Law (Top-Up) programme is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Major Project No examinations Entry Requirements Qualifi Level 7 Diploma in International Business Law or equivalent qualification Minimum 2 Years of managerial experience Further, candidates are also required to demonstrate their English language proficiency. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure LLM International Business Law Top-Up Programme Structure Major Research Project Delivery Methods The LLM International Business Law (Top-Up) programme is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

The course aim to unlock the secrets of bond, forward and futures analysis to maximize your investment potential. After the successful completion of the course, you will be able to learn about the following; Understand the fundamentals of bond market analysis, including the different types of bonds and their characteristics. Learn about the advantages and disadvantages of investing in bonds, and how to assess whether they are the right investment option for you. Gain an in-depth knowledge of the various classifications of bonds, such as government, corporate, and municipal bonds, and how they differ from each other. Discover the importance of macro-level analysis in bond investment, including factors such as interest rates, inflation, and economic indicators. Learn about the concept of options and futures, and the role they play in financial markets and investment strategies. Understand the concept and uses of swaps, including interest rate swaps and currency swaps, and how they can be used to manage risk and optimize investment returns. This course is designed to provide a comprehensive understanding of bond market analysis, classification, and macro-level analysis. You will learn about the advantages and disadvantages of investing in bonds, the different types and their characteristics, and how to assess whether they are the right investment option for you. In addition, you will learn about options and futures and their role in financial markets and investment strategies. You will also understand the concept and uses of swaps, including interest rate swaps and currency swaps, and how they can be used to manage risk and optimize investment returns. This course is suitable for finance professionals, investment analysts, and anyone who wants to enhance their understanding of bond market analysis and investment strategies. The course aim to unlock the secrets of bond, forward and futures analysis to maximize your investment potential. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Analysis of Bonds, Forward and Futures Self-paced pre-recorded learning content on this topic. Analysis of Bonds, Forward and Futures Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Financial analysts Investment bankers Portfolio managers Financial advisors Risk managers Bond traders Corporate treasurers Fixed income analysts Wealth managers Pension fund managers Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Free online MS Awareness training session for care providers

Our extensive Call Centre & Customer Service Training course will help your call center workforce reach its full potential. Our 10-module programme covers all the essentials for providing great customer service, from learning the fundamentals to honing communication skills and creating goals. Develop your questioning skills, master phone etiquette, and improve your public speaking abilities. Equip yourself with the instruments required to succeed in the fast-paced field of customer service with an emphasis on pragmatism and benchmarking. Become a light of excellence for your call center by partnering with us. Key Features: CPD Certified Developed by Specialist Lifetime Access Throughout this course, participants will first gain an understanding of the core competencies and knowledge required for work in contact centres and customer service. The nuances of phone etiquette will then be covered in detail, enabling them to speak with professionalism and effectiveness when on the phone. Learners will explore different types of questions and how to respond to them appropriately, enhancing their ability to assist customers efficiently. They'll also learn techniques to speak confidently and skillfully, aiming to provide stellar customer service experiences. The curriculum emphasises key steps in handling customer interactions, setting achievable goals, and effectively closing conversations. Learners will gain insights into benchmarking performance and utilising various tools to support their customer service efforts effectively. Overall, this curriculum equips learners with the essential skills and knowledge needed to excel in call centre and customer service roles. Course Curriculum: Module 01: The Basics (I) Module 02: The Basics (II) Module 03: Phone Etiquette Module 04: Types of Questions Module 05: Speaking Like a Star Module 06: Key Steps Module 07: Goal Setting Module 08: Closing Module 09: Benchmarking Module 10: Tools Learning Outcomes: Understand fundamental principles of call centre and customer service operations. Master phone etiquette for effective communication in customer interactions. Develop skills to handle various types of customer inquiries confidently. Enhance verbal communication techniques to engage and assist customers effectively. Implement key steps and strategies to achieve customer service goals. Utilise benchmarking and tools for continuous improvement in service quality. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring for customer service or call centre roles. Professionals seeking to enhance customer communication and service skills. Job seekers aiming for entry-level positions in customer support. Anyone interested in understanding call centre operations and customer service. Individuals aiming to improve their communication skills in service-oriented roles. Career path Customer Service Representative Call Centre Operator Customer Support Assistant Helpdesk Support Agent Client Relationship Manager Sales Support Executive Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Imagine embarking on a Customer Support Training Course that equips you with essential skills crucial in today's digital age. Customer support is not just about solving problems; it's about fostering positive relationships and ensuring satisfaction. In our modern world, where businesses thrive on customer loyalty, mastering Customer Support is paramount. This course teaches you effective communication, telephone etiquettes, and negotiation techniques, preparing you to handle various customer interactions confidently. These skills are invaluable in both daily life and professional careers, opening doors to job opportunities across the UK. Customer Support roles are in high demand, with salaries reflecting this need-ranging from competitive entry-level packages to lucrative senior positions. The sector is growing steadily, with a significant rise in job openings over the past decade. By enrolling in this course, you not only enhance your employability but also contribute to your personal growth and the success of any organization you join. Customer Support isn't just a skill; it's a pathway to thriving in today's service-driven economy. Key Features: CPD QS Certified Customer Support Course Free Certificate Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Call Centre Module 02: Traits of a Call Centre Agent Module 03: Agent and Customer Relationship Module 04: Telephone Etiquettes Module 05: Communication Skills Module 06: Scripts and Negotiation Techniques Module 07: Managing Difficult Customers Module 08: Call Centre Metrics and Benchmarking Module 09: Call Centre Technology and Trends Learning Outcomes: Develop strong customer rapport for enhanced service delivery and satisfaction. Perfect telephone etiquette to create a positive and professional impression. Acquire effective communication skills for seamless customer-agent interactions. Hone negotiation techniques within scripted scenarios for optimal outcomes. Navigate challenging customer situations with confidence and strategic proficiency. Interpret call centre metrics to drive performance and achieve benchmarked success. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Customer Support Training course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Customer Support Training. Moreover, this course is ideal for: Aspiring customer service professionals seeking skills enhancement. Call centre agents eager to refine their customer interaction capabilities. Team leaders aiming to elevate their team's customer satisfaction scores. Customer support managers focused on improving overall team performance. Individuals in roles requiring mastery of call centre dynamics and metrics. Requirements There are no requirements needed to enrol into this Customer Support Training course. We welcome individuals from all backgrounds and levels of experience to enrol into this Customer Support Training course. Career path After finishing this Customer Support Training course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Customer Support are: Customer Service Representative - £18K to 25K/year Call Centre Team Leader - £22K to 30K/year Customer Support Manager - £30K to 40K/year Technical Support Specialist - £20K to 28K/yr Customer Experience Analyst - £25K to 35K/yr Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Our extensive Call Centre & Customer Service Training course will help your call center workforce reach its full potential. Our 10-module programme covers all the essentials for providing great customer service, from learning the fundamentals to honing communication skills and creating goals. Develop your questioning skills, master phone etiquette, and improve your public speaking abilities. Equip yourself with the instruments required to succeed in the fast-paced field of customer service with an emphasis on pragmatism and benchmarking. Become a light of excellence for your call center by partnering with us. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Throughout this course, participants will first gain an understanding of the core competencies and knowledge required for work in contact centres and customer service. The nuances of phone etiquette will then be covered in detail, enabling them to speak with professionalism and effectiveness when on the phone. Learners will explore different types of questions and how to respond to them appropriately, enhancing their ability to assist customers efficiently. They'll also learn techniques to speak confidently and skillfully, aiming to provide stellar customer service experiences. The curriculum emphasises key steps in handling customer interactions, setting achievable goals, and effectively closing conversations. Learners will gain insights into benchmarking performance and utilising various tools to support their customer service efforts effectively. Overall, this curriculum equips learners with the essential skills and knowledge needed to excel in call centre and customer service roles. Course Curriculum: Module 01: The Basics (I) Module 02: The Basics (II) Module 03: Phone Etiquette Module 04: Types of Questions Module 05: Speaking Like a Star Module 06: Key Steps Module 07: Goal Setting Module 08: Closing Module 09: Benchmarking Module 10: Tools Learning Outcomes: Understand fundamental principles of call centre and customer service operations. Master phone etiquette for effective communication in customer interactions. Develop skills to handle various types of customer inquiries confidently. Enhance verbal communication techniques to engage and assist customers effectively. Implement key steps and strategies to achieve customer service goals. Utilise benchmarking and tools for continuous improvement in service quality. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring for customer service or call centre roles. Professionals seeking to enhance customer communication and service skills. Job seekers aiming for entry-level positions in customer support. Anyone interested in understanding call centre operations and customer service. Individuals aiming to improve their communication skills in service-oriented roles. Career path Customer Service Representative Call Centre Operator Customer Support Assistant Helpdesk Support Agent Client Relationship Manager Sales Support Executive Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Learn the main topics related to Microsoft excel 2007. Identify the basic excel techniques, explore the advanced functions of excel 2007 and create automated reports with the press of a button in this course. By completing this course, you will become an excel expert and use excel 2007 as a professional. Who is the course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application. This course is for office professionals who want to nail all the meetings and projects at the workplace. This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy at a cost of £39 or in PDF format at a 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 recognised 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 diploma in Microsoft Excel 2007 will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Final Exam Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00