5811 Computing courses in Glenrothes delivered Online

Duration 3 Days 18 CPD hours This course is intended for IT Professionals who deploy small-to- medium scale enterprise network solutions based on Aruba products and technologies Overview Upon completion of this course, you will be able to:Explain how Aruba networking solutions meet customers? requirementsExplain how Aruba AirWave provides unified wireless and wired network managementDescribe in-band management and out-of-band managementComplete the initial setup on ArubaOS switchesControl access to switches for both in-band and out-of-band managementManage software and configuration files on ArubaOS switchesExplain use cases for VLANs and configure port-based VLANs on ArubaOS switchesUnderstand and configure Rapid Spanning Tree Protocol (RSTP)Understand and configure Multiple Spanning Tree Protocol (MSTP)Differentiate between different types of link aggregation and understand the benefits of Link Aggregation Control Protocol (LACP)Configure and troubleshoot link aggregation on ArubaOS switchesConfigure static routes on ArubaOS switches and interpret IP routing tablesConfigure a basic Open Shortest Path First (OSPF) solutionDescribe how Virtual Switching Framework (VSF) works and the advantages that it providesConfigure and verify a simple VSF fabricDescribe the basics of wireless communications and 802.11 standardsDefine a wireless LAN (WLAN) and differentiate between wireless security optionsConfigure basic settings on Aruba Instant APsConfigure AirWave management settings on an IAP clusterConfigure SNMP v2c settings on ArubaOS switchesDiscover ArubaOS switches in AirWave and bring switches and IAPs under monitoring and managementImplement zero touch provisioning (ZTP) for Aruba IAPs and ArubaOS switches This course teaches you the fundamental skills necessary to configure and manage modern, open standards-based networking solutions. This course consists of approximately 20% lecture and 80% hands-on lab exercises to help you learn how to implement and validate small to medium enterprise network solutions. This 3-day course prepares network professionals for the HPE ATP - Aruba Mobile First Solutions V1 certification exam.In this course, participants learn about ArubaOS switch technologies including: VLANs, securing access, redundancy technologies such as MSTP, link aggregation techniques including LACP, and switch virtualization with Aruba?s Virtual Switching Framework (VSF). You also learn about IP Routing including static and dynamic IP routing with OSPF. This course teaches you how to deploy Aruba wireless Access Points and configure Aruba Clustering technology. It also teaches you how to configure, manage and monitor the network with the Aruba AirWave management solution. Introduction to Aruba, a Hewlett Packard Enterprise companySwitch CLI (Command Line Interface) NavigationProtecting Management AccessManagement of Software and ConfigurationsVLANSSpanning Tree Protocol (STP)Link AggregationIP RoutingVirtual Switching Framework (VSF)Wireless for Small-to-Medium Businesses (SMBs)Aruba AirWave

Duration 5 Days 30 CPD hours This course is intended for Ideal candidates include network professionals who are looking to build their foundational knowledge of the ClearPass product portfolio. Overview After you successfully complete this course, expect to be able to: Implement a ClearPass network access solution Design and apply effective services and enforcement in ClearPass Troubleshoot a ClearPass solution This course provides participants the foundational skills in Network Access Con-trol using the Aruba ClearPass product portfolio. This 5-day course includes both instructional modules and labs to teach participants about the major fea-tures in the ClearPass portfolio. Participants will learn how to setup ClearPass as an AAA server, and configure the Policy Manager, Guest, OnGuard and Onboard feature sets. In addition, this course covers integration with external Active Directory servers, Monitoring and Reporting, as well as deployment best practices. The student will gain insight into configuring authentication with ClearPass on both wired and wireless networks. Introduction to ClearPass BYOD High Level Overview Posture and Profiling Guest and Onboard AAA Policy Service Rules Authentication Authorization and Roles Enforcement Policy and Profiles External Devices Network Access Devices Messaging Services External Context Servers Endpoint Profiling Introduction to profiling Profiling collectors External collectors and profilers Roles and Enforcement Services Enforcement ClearPass roles Configuring Services Service selection rules Creating services Configuring Web Services Content Manager Skins Web page editor Guest Authentication Captive portal process Web logins Guest accounts Guest access with MAC authentication Guest Access Self-Registration Self-registration experience Configuring self-registration Self-registration process Wired Authentication Wired access Wired enforcement Profiling on wired ports Downloadable User Roles Requirements for DUR DUR enforcement profiles Dynamic Segmentation What is Dynamic Segmentation? How it works Configuring Dynamic Segmentation OnGuard Configuration Postures Posture policies OnGuard Agent Monitoring OnGuard OnGuard in Enforcement OnGuard workflow OnGuard enforcement Onboard Provisioning Configuring certificate authorities Portal setup Configuring services Onboard Administration Managing certificates Managing users and devices Certificate revocation and OCSP Administrative Operations Licenses Certificates Updates and upgrades Gathering logs ClearPass Cluster Cluster structure Policy Manager zones High availability Administrative Access Admin access to NADs Admin access to Policy Manager Guest operator logins Insight Reports Alerts Reports Administration Additional course details: Nexus Humans Aruba ClearPass Configuration 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 Aruba ClearPass Configuration 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.

Duration 3 Days 18 CPD hours This course is intended for Typical candidates for this course are IT Professionals who deploy small-to-medium scale enterprise network solutions based on Aruba products and technologies. Overview After you successfully complete this course, expect to be able to: Explain how Aruba's wireless networking solutions meet customers' requirements Explain fundamental WLAN technologies, RF concepts, and 802.11 Standards Learn to configure the Mobility Master and Mobility Controller to control access to the Employee and Guest WLAN Control secure access to the WLAN using Aruba Firewall Policies and Roles Recognize and explain Radio Frequency Bands and channels, and the standards used to regulate them Describe the concept of radio frequency coverage and interference and successful implementation and diagnosis of WLAN systems Identify and differentiate antenna technology options to ensure optimal coverage in various deployment scenarios Describe RF power technology including, signal strength, how it is measured and why it is critical in designing wireless networks Learn to configure and optimize Aruba ARM and Client Match and Client Insight features Learn how to perform network monitoring functions and troubleshooting This course teaches the knowledge, skills and practical experience required to set up and configure a basic Aruba WLAN utilizing the OS 8.X architecture and features. Using lecture and labs, this course provides the technical understanding and hands-on experience of configuring a single Mobility Master with one controller and AP Aruba WLAN. Participants will learn how to use Aruba hardware and ArubaOS to install and build a complete, secure controller network with multiple SSIDs. This course provides the underlying material required to prepare candidates for the Aruba Certified Mobility Associate (ACMA) certification exam. WLAN Fundamentals Describes the fundamentals of 802.11, RF frequencies and channels Explain RF Patterns and coverage including SNR Roaming Standards and QOS requirements Mobile First Architecture An introduction to Aruba Products including controller types and modes OS 8.X Architecture and features License types and distribution Mobility Master Mobility Controller Configuration Understanding Groups and Subgroups Different methods to join MC with MM Understanding Hierarchical Configuration Secure WLAN configuration Identifying WLAN requirements such as SSID name, encryption, authentication Explain AP groups structure and profiles Configuration of WLAN using the Mobility Master GUI AP Provisioning Describes the communication between AP and Mobility controller Explain the AP booting sequence and requirements Explores the APs controller discovery mechanisms Explains how to secure AP to controller communication using CPSec Describes AP provisioning and operations WLAN Security Describes the 802.11 discovery, authentication and association Explores the various authentication methods, 802.1x with WPA/WPA2, Mac auth Describes the authentication server communication Explains symmetric vs asymmetric Keys, encryption methods WIPS is described along with rogue discovery and protection Firewall Roles and Policies An introduction into Firewall Roles and policies Explains Aruba?s Identity based Firewall Configuration of Policies and Rules including aliases Explains how to assign Roles to users Dynamic RF Management Explain how ARM calibrates the network selecting channels and power settings Explores OS 8.X Airmatch to calibrate the network How Client Match and ClientInsight match steers clients to better APs Guest Access Introduces Aruba?s solutions for Guest Access and the Captive portal process Configuration of secure guest access using the internal Captive portal The configuration of Captive portal using Clearpass and its benefits Creating a guest provisioning account Troubleshooting guest access Network Monitoring and Troubleshooting Using the MM dashboard to monitor and diagnose client, WLAN and AP issues Traffic analysis using APPrf with filtering capabilities A view of Airwaves capabilities for monitoring and diagnosing client, WLAN and AP issues Additional course details: Nexus Humans Aruba Mobility Fundamentals, Rev. 20.11 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 Aruba Mobility Fundamentals, Rev. 20.11 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.

Duration 5 Days 30 CPD hours This course is intended for Typical candidates for this course are IT Professionals who deploy small-to-medium scale enterprise network solutions based on Aruba products and technologies Overview After you successfully complete this course, expect to be able to: Explain how Aruba's wireless networking solutions meet customers' requirements Explain fundamental WLAN technologies, RF concepts, and 802.11 Standards Learn to configure the Mobility Master and Mobility Controller to control access to the Employee and Guest WLAN Control secure access to the WLAN using Aruba Firewall Policies and Roles Recognize and explain Radio Frequency Bands and channels, and the standards used to regulate them Describe the concept of radio frequency coverage and interference and successful implementation and diagnosis of WLAN systems Identify and differentiate antenna technology options to ensure optimal coverage in various deployment scenarios Describe RF power technology including, signal strength, how it is measured and why it is critical in designing wireless networks Learn to configure and optimize Aruba ARM and Client Match features Learn how to perform network monitoring functions and troubleshooting AR-AMF teaches knowledge, skills & practical exp. to set up & config a basic AR WLAN utilizing OS 8.X architecture & features.using lecture & labs,AR-AMF provides tech. & hands-on exp. of config. a single Mobility Master with 1 controller & AP WLAN WLAN Fundamentals Describes the fundamentals of 802.11, RF frequencies and channels Explain RF Patterns and coverage including SNR Roaming Standards and QOS requirements Mobile First Architecture An introduction to Aruba Products including controller types and modes OS 8.X Architecture and features License types and distribution Mobility Master Mobility Controller Configuration Understanding Groups and Subgroups Different methods to join MC with MM Understanding Hierarchical Configuration Secure WLAN configuration Identifying WLAN requirements such as SSID name, encryption, authentication Explain AP groups structure and profiles Configuration of WLAN using the Mobility Master GUI AP Provisioning Describes the communication between AP and Mobility controller Explain the AP booting sequence and requirements Explores the APs controller discovery mechanisms Explains how to secure AP to controller communication using CPSec Describes AP provisioning and operations WLAN Security Describes the 802.11 discovery, authentication and association Explores the various authentication methods, 802.1x with WPA/WPA2, Mac auth Describes the authentication server communication Explains symmetric vs asymmetric Keys, encryption methods WIPS is described along with rogue discovery and protection Firewall Roles and Policies An introduction into Firewall Roles and policies Explains Aruba?s Identity based Firewall Configuration of Policies and Rules including aliases Explains how to assign Roles to users Dynamic RF Management Explain how ARM calibrates the network selecting channels and power settings Explores the new OS 8.X Airmatch to calibrate the network How Client Match and Client Insight match steers clients to better Aps Dynamic RF Management Explain how ARM calibrates the network selecting channels and power settings Explores the new OS 8.X Airmatch to calibrate the network How Client Match and Client Insight match steers clients to better Aps Guest Access Introduces Aruba?s solutions for Guest Access and the Captive portal process Configuration of secure guest access using the internal Captive portal The configuration of Captive portal using Clearpass and its benefits Creating a guest provisioning account Troubleshooting guest access Network Monitoring and Troubleshooting Using the MM dashboard to monitor and diagnose client, WLAN and AP issues Traffic analysis using APPrf with filtering capabilities A view of Airwaves capabilities for monitoring and diagnosing client, WLAN and AP issues

Duration 3 Days 18 CPD hours This course is intended for Built for experienced IT Professionals who want to be familiar with Citrix ADC. Potential students include administrators, engineers, and architects interested in learning how to deploy or manage Citrix ADC. Overview Understand the functionality and capabilities of the Citrix ADC Complete the initial setup and configuration of the Citrix ADC appliance Understand Citrix ADC Load Balancing and High Availability configuration options and management Employ recommended tools and techniques to troubleshoot common ADC network and connectivity issues Learn the skills required to implement Citrix ADC Essential components includingsecure Load Balancing, High Availability, and Citrix ADC Management. At the endof the course, students will be able to configure their Citrix ADC environments toaddress traffic delivery and management requirements including Load Balancing,Availability, and ADC Operation Management. Getting Started Introduction to Citrix ADC Feature and Platform Overview Deployment Options Architectural Overview Setup and Management Basic Networking Networking Topology Citrix ADC Components Routing Access Control Lists ADC Platforms Citrix ADC MPX Citrix ADC VPX Citrix ADC CPX Citrix ADC SDX Citrix ADC BLX High Availability Citrix ADC High Availability High Availability Configuration Managing High Availability In Service Software Upgrade Troubleshooting High Availability Load balancing Load Balancing Overview Load Balancing Methods and Monitors Load Balancing Traffic Types Load Balancing Protection Priority Load Balancing Load Balancing Troubleshooting SSL Offloading SSL Overview SSL Configuration SSL Offload Troubleshooting SSL Offload SSL Vulnerabilities and Protections Security Authentication, Authorization, and Auditing Configuring External Authentication Admin Partitions Security Citrix ADC Logging Monitoring with SNMP Reporting and Diagnostics AppFlow Functions Citrix Application Delivery Management Troubleshooting

Want to get rid of the burden of heavy calculations? On the off chance that you have ever been keen on speeding up your Mathematics multiple times quicker with Vedic Math, Mental Math tricks and shortcuts for GMAT, Olympiad, then Best Techniques To Speed Up Your Mathematics will be the best opportunity for you. Through this course, you will receive lots of tips and tricks which will become a component of your calculations. Besides, numerous know-how of Vedic Mathematics also covered in this course which can easily apply in today's Math. By the time you complete this course, you will be set to perform large calculations and enhanced your Mathematics skills. To sum up, this course will be remarkably helpful for individuals who have interest in doing complicated multiplication in less time. What Will I Learn? Apply ' Digital Sum' technique of vedic Mathematics to find right options in multiple choice questions with in a few seconds. Short cuts for 'Time & Work' explained in 11 lectures with lots of practice problems. Find day of the week when any old or coming date is given without counting odd days and leap years Count number of squares , rectangles and triangles with the help of short cut tricks Find answer in 2 seconds of simplification problems like 1/6 +1/12+1/20+1/30+1/42+1/50+1/72+1/90+1/110+1/132 Apply short cuts to solve fraction series like 3/1²×2² + 5/ 2²×3² + 7/ 3²×4² +.............19/9²×10² Simplify in 2 seconds problems like ( 1 - 1/3 ) ( 1 - 1/4 ) ( 1 - 1/5 ) ( 1 - 1/6) ........ ( 1 - 1/50 ) Find the solution of complicated repeated square root problems like √5(√5(√5(√5))) in two seconds Squaring any two digit numbers,decimal and non decimal with the help of vedic math technique Squaring any three digit numbers,decimal and non decimal with the help of vedic math technique Able to find square root of any digit number which are not perfect square easily with a special short trick Able to find cube root of any digit number which are not perfect cube easily with a special short trick With Vedic Maths techniques, Multiplying any digit number by 9 ; 99 ; 999 ; 9999999 etc faster than calculator like 47356 × 99999 and 345 × 99999 Multiplying two numbers of any digit in a single line with the help of very fast technique of Vedic mathematics 'Vertically and Crosswise' Multiply any two digit number or any big number by 11,22 and 33 in brain faster than the calculator . Learn how to find remainder when any big digit number is divided by 9 without actually dividing , faster than calculator With Vedic Maths techniques, Multiplying two large numbers of same digits below the base 1000 ;10000 ;100000 etc in 2 seconds like 996 ×995, 9991 × 9992 Multiplying two numbers of same digits above the base 1000 ;10000 ;100000 etc in 2 seconds like 105 ×106 , 1003 × 1007, 100001 × 100006 Multiplication of numbers one above the base and the other less than the base like 1 0 5 × 9 4 ; 1 0 02 × 996 etc in 2 seconds Multiplying any digit number by 5 , 25 and 125 very fast within 2 seconds. Squaring numbers that end in 5 faster than calculator Requirements Knowledge of mathematics up to fifth grade Knowledge of the Times Tables up to 9 A pen/ pencil and paper Who is the target audience? GMAT, GRE, CAT, Maths Olympiad, Banking Exams and University entrance exams students looking to increase calculation power with the help of Vedic Maths Shortcuts Whoever wants to learn to do calculations without calculator Whoever wants to increase Math power, skill and get rid of fear of Maths School students want to learn short tricks , wants to increase concentration Middle school and High school students want to do calculations many times faster Introduction Lecture 1 Introduction.mp4 FREE 00:02:00 Section 2 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Section 3 Lecture 3 Finding remainder when a number of any digits is divided by 9.mp4 00:04:00 Section 4 Lecture 4 Multiplying any digit number by series of 9; 99; 999; 99999 Part 1.mp4.TS 00:08:00 Lecture 5 Multiplying any digit number by series of 9; 99 ; 999 ; 99999 Part 2.mp4 00:07:00 Section 5 Lecture 6 Product of two numbers below the base number 100; 1000 etc.mp4 00:08:00 Lecture 7 Multiplication of Numbers above the base 1000; 10000; 100000 etc.mp4 00:08:00 Lecture 8 Multiplication of numbers one above the base and second less than the base.mp4 00:06:00 Section 6 Lecture 9 multiplying any two digit numbers using Vertically and Crosswise.mp4 00:04:00 Lecture 10 Multiplying three digit numbers using Vertically and Crosswise.mp4 00:05:00 Section 7 Lecture 11 Multiplying any digit number by 5, 25, and 125 faster than calculator.mp4 00:07:00 Section 8 Lecture 12 Squaring numbers that end in 5 using Vedic Math.mp4.TS 00:04:00 Lecture 13 Squaring two digit numbers mentally Using Vedic Math technique.mp4 00:06:00 Lecture 14 Squaring three digit numbers mentally Using Vedic Math technique.mp4 00:05:00 Section 9 Lecture 15 Finding cube of any two digit number faster than calculator.mp4 00:10:00 Section 10 Lecture 16 Approximate value of square root of numbers which are not perfect squares.mp4 00:09:00 Lecture 17 Approximate value of cube root of numbers which are not perfect cubes.mp4 00:05:00 Section 11 Lecture 18 Short tricks to count Number of Squares in given figure.mp4 00:05:00 Lecture 19 Short tricks to count Number of Rectangles in given figure.mp4 00:03:00 Lecture 20 Short tricks to count Number of triangles in given figure.mp4.TS 00:04:00 Section 12 Lecture 21 Finding Day of the week when any date is given in 2 Seconds mentally.mp4 00:12:00 Simplify calculations super fast Lecture 22 Digital sum of a number.mp4 00:04:00 Lecture 23 Digital sum- Addition and Subtraction.mp4 00:10:00 Lecture 24 Digital sums- Multiplication.mp4 00:07:00 Lecture 25 Digital sum- divisions.mp4 00:08:00 Simplification short cuts for complicated fractions and square root problems Lecture 26 Simplification short tricks for complicated fractions.mp4 00:10:00 Lecture 27 Simplification short tricks for fractions series part 1.mp4 00:07:00 Lecture 28 Simplification short tricks for fractions series part 2.mp4 00:05:00 Lecture 29 Simplification short tricks for complicated square root problems.mp4 00:09:00

Overview With the ever-increasing demand for Functional Skills 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 Functional Skills may be. Learning about Functional Skills 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 Functional Skills . 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 Functional Skills 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 Functional Skills 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 Functional Skills 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 Functional Skills 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 Functional Skills , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Functional Skills , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Functional Skills , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Functional Skills 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 Functional Skills Maths Level 2 Module 01 Introduction Introduction 00:00 Functional Skills Maths Level 2 Module 2 Basic arithmetic Basic arithmetic 00:00 Functional Skills Maths Level 2 Module 3 Fractions Fractions 00:00 Functional Skills Maths Level 2 Module 4 Decimals Decimals 00:00 Functional Skills Maths Level 2 Module 5 Using a calculator Using a calculator 00:00 Functional Skills Maths Level 2 Module 6 Percentages Percentages 00:00 Functional Skills Maths Level 2 Module 7 Ratio and proportion Ratio and proportion 00:00 Functional Skills Maths Level 2 Module 8 Powers, roots and laws of indices Powers, roots and laws of indices 00:00 Functional Skills Maths Level 2 Module 9 Units, prefixes and engineering notation Units, prefixes and engineering notation 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

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Course Description The Critical Thinking, Problem Solving and Decision Making: Part 2 course is designed to enhance your problem-solving and decision-making skills through developing critical thinking. In this course, you will learn about the standards and steps of critical thinking. The course will help you to enhance and boost your critical thinking skills. You will also learn about the characteristics and qualities of a critical thinker. This bite-size course will help you to make better decisions and solve problems with critical thinking. Enrol the course now if you want to develop these skills. Learning outcome  Gain knowledge about the standards and steps of critical thinking Enhance your critical thinking skills Learn about the characteristics of a critical thinker Make better decisions with critical thinking How Much Do Managers Earn? Senior - £70,000(Appx.) Average - £46,000(Appx.) Starting - £36,000(Appx.) Requirement Our Critical Thinking, Problem Solving and Decision Making: Part 2 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. Critical Thinking, Problem Solving and Decision Making: Part 2 Module 01: What Are the Critical Thinking Steps 00:17:00 Module 02: Critical Thinking Strategies 00:25:00 Module 03: Recognising a Critical Thinker 00:23:00 Module 04: Decision Making with Critical Thinking 00:26:00 Module 05: Problem-Solving Through Critical Thinking 00:25:00 Assignment Assignment - Critical Thinking, Problem Solving and Decision Making: Part 2 00:00:00