• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

639 Macro courses

🔥 Limited Time Offer 🔥

Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X

VBA with Microsoft Excel

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. USING VBA TO SOLVE BUSINESS PROBLEMS * Use Macros to Automate Tasks in Excel * Identify Components of Macro-Enabled Workbooks * Configure the Excel VBA Environment 2. RECORDING A MACRO * Use the Macro Recorder to Create a VBA Macro * Record a Macro with Relative Addressing * Delete Macros and Modules * Identify Strategies for Using the Macro Recorder 3. WRITING VBA CODE DIRECTLY * Write VBA Code * Discover Objects You Can Use * Create a Custom Function 4. SOLVING PROBLEMS THROUGH CODE * Make Decisions in Code * Work with Variables * Perform Repetitive Tasks 5. IMPROVING YOUR VBA CODE * Debug VBA Errors * Deal with Errors * Improve Macro Performance 6. CONTROLLING HOW AND WHEN MACROS RUN * Prompt the User for Information * Configure Macros to Run Automatically ADDITIONAL COURSE DETAILS: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.

VBA with Microsoft Excel
Delivered OnlineTwo days, Jun 18th, 13:00
£655

Certified Lean Six Sigma Black Belt Training April 2024

By Centre for Competitiveness

Course Overview Lean Six Sigma is a proven combination of tools and techniques that has been used by leading organizations to improve efficiency, productivity and customer satisfaction. It achieves this by providing a rigorous and structured methodology and team approach to problem solving which leads to quality and performance improvements. Our Lean Six Sigma Black Belt workshop is an eight (8) day programme designed to develop Lean Six Sigma Green Belts into Black Belts, qualifying them to become agents of change within an organization, enhancing their current skills, by developing a thorough understanding of the DMAIC methodology and its applications, to manage a culture of problem solving and continuous improvement in your organization. It therefore allows key personnel to support your company’s larger goals and objectives. It is suited to those who will have a company-wide role in Six Sigma, including the deployment of the methodology, project selection work, and leadership responsibilities. The course uses a blend of theory and practical exercises to ensure that delegates have the confidence and capability to identify opportunities for improvement and lead in the delivery of more complex business improvement projects and transformations.  Black Belts can develop individual projects, or they can engage in a macro Black Belt project which can incorporate several Green Belt projects as support. The tools acquired during training will enable them to solve more challenging problems and use team dynamics to lead improvement teams towards the implementation of change within the organization. Key topics covered at Green Belt level are refreshed, focusing on how to use data to pinpoint processes that need to be analysed and improved using the Six Sigma Tool sets, with a view to problem solving, increasing operational efficiency, improving productivity and customer satisfaction and the company’s overall business results. In addition, subjects dealt with in the Black Belt course include project mandate preparation, team leadership and facilitation techniques, as well as project management skills. On the data analysis side, Statistical analysis plays a major part of this course. Means to deal with non-normal data are considered, there are also sections on probability, the binomial and Poisson distributions, and multiple factor analysis. Design of experiments is also considered – this is a structured approach to experimentation to help determine which inputs are important in a process.  Our Lean Six Sigma Black Belt programme incorporates a project to be undertaken in your own organization during and after the training modules. This allows you to apply the tools, in your own working environment, to processes that are known to you, making the training relevant, and also leaving a improvement with measurable results in your organization. MINITAB (trial version can be downloaded free) and Excel software are used by participants during the training sessions and to complete their projects. Structure of the Course This 8-day training programme is divided into three modules as follows:  * Define / Measure Phase - 3 days from April 8th to 10th,  2024 * Analyse Phase - 3 days on May 13th to 15th, 2024 * Improve / Control Phase - 2 days on June 17th & 18th, 2024 A gap of 4 weeks between each module provides an opportunity for trainees to work on a project within their workplace, applying the methodology and tools learned during the previous module. Extra support can be provided between modules for each trainees with their project work. We provide a Lean Six Sigma Black Belt Manual for all delegates, and a Certification is awarded upon completion of the Black Belt training and ONE project by each trainee in which the targeted outcomes have been achieved. An outcome report and/or project presentation which demonstrates the use of the tools and methodology is required. Cost: £2,200 + VAT per person. What is included * Eight days of face-to-face training delivered in 3 modules as detailed above * Project review and support for all participants during modules 2 & 3.  * Remote support available for the duration of the programme for trainees to consult with the trainer. * All training material, and a Lean Six Sigma Black Belt Manual for all delegates * Refreshments and lunch provided each day of training * Free car park for all delegates * Lean Six Sigma Black Belt certificate In-house Option This workshop can also be delivered in-house as a stand-alone training workshop or integrated into wider improvement activities. Contact us for more details at compete@cforc.org and we will be happy to discuss in the context of your own business needs. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here [http://www.cforc.org/join-us].

Certified Lean Six Sigma Black Belt Training April 2024
Delivered In-Person in AntrimFull day, Jun 17th, 08:00 + 1 more
£2200

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - USING VBA TO SOLVE BUSINESS PROBLEMS * Topic A: Use Macros to Automate Tasks in Excel * Topic B: Identify Components of Macro-Enabled Workbooks * Topic C: Configure the Excel VBA Environment 2 - AUTOMATING REPETITIVE TASKS * Topic A: Use the Macro Recorder to Create a VBA Macro * Topic B: Record a Macro with Relative Addressing * Topic C: Delete Macros and Modules * Topic D: Identify Strategies for Using the Macro Recorder 3 - GETTING HELP ON VBA * Topic A: Use VBA Help * Topic B: Use the Object Browser to Discover Objects You Can Use in VBA * Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - CREATING CUSTOM WORKSHEET FUNCTIONS * Topic A: Create a Custom Function * Topic B: Make Decisions in Code * Topic C: Work with Variables * Topic D: Perform Repetitive Tasks 5 - IMPROVING YOUR VBA CODE * Topic A: Debug VBA Errors * Topic B: Deal with Errors * Topic C: Improve Macro Performance 6 - CONTROLLING HOW AND WHEN MACROS RUN * Topic A: Prompt the User for Information * Topic B: Configure Macros to Run Automatically 7 - DEVELOPING CUSTOM FORMS * Topic A: Display a Custom Dialog Box * Topic B: Program Form Events 8 - USING VBA TO WORK WITH FILES * Topic A: Use VBA to Get File and Directory Structure * Topic B: Use VBA to Read Text Files * Topic C: Use VBA to Write Text Files 9 - USING VBA TO CLEAN AND TRANSFORM DATA * Topic A: Automate Power Query * Topic B: Transform Data Using VBA and Workbook Functions * Topic C: Use Regular Expressions * Topic D: Manage Errors in Data 10 - EXTENDING THE PROGRAMMING ENVIRONMENT BEYOND THE WORKBOOK * Topic A: Run Other Programs and Commands * Topic B: Share Your VBA Projects

Programming and Data Wrangling with VBA and Excel
Delivered Online4 days, Jul 10th, 13:00
£885

Excel - Automating Excel with Macros and Analysis Tools

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS * Working with Named Ranges * Link Cells Across Worksheets and Workbooks * Use 3D References to Calculate Across Worksheets * Consolidate Data USE FORMULA AUDITING AND ERROR CHECKING * Reveal Formulas * Trace Cell Precedents and Dependents * Locate Errors in Formulas * Watch and Evaluate Formulas REVIEWING AND PROTECTING WORKBOOKS * Control Data Entry via Data Validation * Protect Workbook Access * Protect Worksheets and Cell Content * Add and Edit Comments * Prepare a Workbook for Distribution * Modify Excel's Default Settings USING MACROS TO AUTOMATE WORKBOOK FUNCTIONALITY * Create Macros via Recording * Run Macros via Buttons and Shortcuts * Assign Macros to the Quick Access Toolbar and Ribbon * Assign Macros to Objects * View Macro Code FORECASTING AND ANALYSIS DATA * Use Conditional Formatting to Highlight, Sort and Filter Key Data * Advanced Conditional Formatting using Formulas * Create Sparklines to Visualise Data * Add Trendlines to Charts to Visualise and Forecast Trends * Use Data Tables and Scenarios to Project Potential Outcomes * Use Goal Seek to Calculate Outcomes * Forecast Data Trends Using Solver

Excel - Automating Excel with Macros and Analysis Tools
Delivered OnlineTwo days, Jun 27th, 08:30 + 5 more
£197

Understanding Commercial Property Valuations

By Property Overview Ltd

For those that process, commission or consume valuation reports and want to understand everything in it -------------------------------------------------------------------------------- ABOUT WHO COULD BENEFIT?   An on-line course for those who work with valuation reports – in property or for property clients – and who need to understand the valuation approaches & methods, jargon and drivers per property type better, to enable better informed decision making and more confident discussions with a valuer, or help with the production and sales of valuation systems. We explain the IVS-recognised valuation standards, the valuation methods that fall under those standards and valuation techniques or models. We make delegates comfortable with the jargon and explain the various drivers including by per property type. We use examples to bring the theory to life. The course is taught by Kaushik Shah and Philip Walker, a senior accredited and highly respected valuer. -------------------------------------------------------------------------------- MODULES UNDERSTANDING COMMERCIAL PROPERTY VALUATIONS This one-day course is aimed at people who process, commission or consume commercial property valuations and who would like to understand valuation reports more fully, enable them to derive value more effectively. This course goes from macro to micro. It describes the drivers of value, distinguishing between Price, Market Value and Worth. The course explains the RICS valuation standards and guidance, how things are measured (do you know?) and describes the three valuation approaches and the five underlying valuation methods for residential and commercial. We can cover methods used in the UK and the rest of the world such as Germany. The course explains what is usually used in what situation, and why. All the jargon you are likely to find in a valuation report is explained. We provide real-life examples to bring the valuations to life, and we work through the various valuation types, situations and property types. We finish with an outlook on how valuations are changing. Course book provided on the day. Taught by Philip Walker, FRICS and Kaushik Shah. Next Date Available: Wed 5 July | Location: London or on-line as preferred IN-HOUSE COURSE UNDERSTANDING VALUATIONS Our tailor-made courses fit around what your team requires. Courses can be freely constructed from a range of available modules, or new ones can be added. Items can be discussed as in-depth as required. We pride ourselves on our real-life, hands-on experience and insight on top of the theoretical basis. This enables us to teach a vast range of topics. Enquire about a half, 1 or 2-day course. Combination with other courses such as ‘An Introduction to Property’ is possible. Multi-buy discounts available. Detailed course manual is supplied on the day. To book email kaushik@propertyoverview.co.uk or call +44 (0)7722 866610 -------------------------------------------------------------------------------- PRICING FIND THE BEST PRICE.   Property Overview offers competitively priced training courses with unique practitioner-led content, which means we can tailor our on-line in-house courses around your debt or investment portfolio and the types of valuation reports you receive. Applied, relevant content leads to greater impact and value-for-money. Pricing below is shown for on-line public courses for individual bookings (left), and for on-line or face-to-face in-house courses (right). For bookings of 4 or more staff an in-house course is recommended, also as the content can be tailored around your needs and your products or services. To book fill in the booking form or email kaushik@propertyoverview.co.uk [kaushik@propertyoverview.co.uk] UNDERSTANDING COMMERCIAL PROPERTY VALUATIONS -------------------------------------------------------------------------------- £ 875PP • Standard Price +VAT for public course • Discounts available through SPR & IPF for public courses. IN-HOUSE COURSE UNDERSTANDING VALUATIONS -------------------------------------------------------------------------------- £ 3,850/DAY • One day course, plus VAT. • Includes up to 6 attendees. • £60pp/day + VAT surcharge applies thereafter. • Multi-buy discounts are available. • UK pricing, prices upon application for courses taught abroad.

Understanding Commercial Property Valuations
Delivered Online & In-PersonFull day, Jul 5th, 08:00
£875 to £3850

The Simplest Guide™ to Advanced SAS Programming | Macros | Proc SQL

By Packt

The Simplest Guide™ to Advanced SAS Programming | Macros | SQL is an accelerated path to learning advanced SAS programming taught in a simple, visual, and immersive style. If you already know SAS, this course will equip you with skills to reveal amazing insights within your data, while helping you prepare for advanced SAS certification exams.

The Simplest Guide™ to Advanced SAS Programming | Macros | Proc SQL
Delivered Online On Demand
£101.99

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

By Packt

This course is perfect for the beginner but also delves into building a SAS Model and intermediate topics. Learn SAS Data Step, SQL Step, Macros, SAS Model Building, Predictive Analytics, SAS and ML. If you are using SAS Enterprise Guide and want to learn how to code/program instead of using the point-and-click interface, this course is ideal!

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja
Delivered Online On Demand
£97.99

5G demystified

5.0(3)

By Systems & Network Training

5G TRAINING COURSE DESCRIPTION This course is designed to give the delegate an understanding of the technologies and interworking requirements of the next generation of cellular communications. It is not a definitive set of descriptions but a possibility of the final deployment. During the course we will investigate the 10 pillars for 5G, which will include various Radio Access Technologies that are required to interwork smoothly. Hence we will look at the 4G Pro features and other RATs. WHAT WILL YOU LEARN * List the ten pillars of 5G deployment. * Explain the 5G Internet and Software Distributed Networks (SDN). * Explain carrier aggregation, the mobile cloud and RAT virtualisation. * Explain an overall picture of 5G architecture. 5G TRAINING COURSE DETAILS * Who will benefit: Anyone who is looking to work with next generation networks. * Prerequisites: Mobile communications demystified * Duration 3 days 5G TRAINING COURSE CONTENTS * Drivers for 5G 5G Road Map, 10 Pillars of 5G, evolving RATs, small cell, o SON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation. * 4G LTE advanced features *MIMO, Downlink & uplink MIMO R8, MIMO technology in LTE advanced, Downlink 8-layer SU-MIMO, Downlink MU-MIMO, Uplink MU-MIMO, Uplink transmit diversity, Coordinated multi-point operation (CoMP), Independent eNB & remote base station configurations, Downlink CoMP, * Uplink Multi-Cell Reception. * ICIC & eICIC ICIC, Homogeneous to heterogeneous network, eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS). * Carrier aggregation Component carriers (CC), * CC aggregation, Intra-band contiguous solutions, Intra-band non-contiguous solutions, Inter-band non-contiguous solutions, CA bandwidth classes, Aggregated transmission bandwidth configurations (ATBC), Possible carrier aggregation configurations (Rel 9, 10 & 12). * Enhanced Interference Mitigation & Traffic Adaptation (eIMTA) TDD UL-DL reconfiguration for traffic adaptation, Reconfiguration mechanisms, Interference mitigation schemes, Dynamic & flexible resource allocation. * 5G architectures 5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, innovation centre, 5G in North America, research, company R & D, 5G specifications. * The 5G internet Cloud services, IoT & context awareness, network reconfiguration & virtualization support, hypervisors, SDN, the controller, service-oriented API, OpenFlow switches, SDN operation, SDN control for traffic flow redirection, OpenFlow controllers, how SDN works, application, control and infrastructure layers, a programmable network, how SDN & NFV tie together, SDN's downside, SDN orchestration, Mobility, architectures for distributed mobility management, MEDIEVAL & MEDIVO projects, a clean slate approach, mobility first architecture, network virtualization (VNet), INM, NetInf, ForMux, MEEM, GP & AM, QoS support, network resource provisioning, IntServ, RSVP, DiffServ, CoS, aggregated resource provisioning, SICAP, MARA, Emerging approach for resource over-provisioning, example use case architecture for the 5G internet, integrating SDN/NFV for efficient resource control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations, network operations. * Small cells for 5G Average spectral efficiency evolution, What are small cells? WiFi & Femto cells as candidate small-cell technologies, Capacity limits & achievable gains with densifications, gains with multi-antenna techniques, gains with small cells, Mobile data demand, approach & methodology, subscriber density projections, traffic demand projections, global mobile data traffic increase modelling, country level backhaul traffic projections, 2020 average spectrum requirement, Small cell challenges, backhaul, spectrum, automation. * Cooperation for next generation wireless networks Cooperative diversity & relaying strategies, Cooperative ARQ & MAC protocols, NCCARQ & PRCSMA packet exchange, Physical layer impact on MAC protocol, NCCARQ overview, PHY layer impact, Performance evaluation, simulation scenario and results. * Mobile clouds; technology & services for future communications platforms Mobile cloud, software, hardware and networking resources, Mobile cloud enablers, mobile user domain, wireless technologies, WWAN WLAN and WPAN range, Bluetooth, IEEE.802.15.4, software stacks, infrared, near field communications (NFC), store & forward vs compute & forward, random/linear network coding. * Security for 5G communications Potential 5G architectures, Security issues & challenges in 5G, user equipment, mobile malware attacks, 5G mobile botnets, attacks on 4G networks, C-RNTI & packet sequence numbers based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, attacks on mobile operator's network, user data & identity attacks, DDoS attacks, amplification, HSS saturation, external IP networks.

5G demystified
Delivered in-person, on-request, onlineDelivered Online & In-Person in Internationally
£2367

Essential 5G

5.0(3)

By Systems & Network Training

ESSENTIAL 5G TRAINING COURSE DESCRIPTION This course is designed to give delegates an explanation of the technologies and interworking requirements of the next generation of cellular communications. It is not a definitive set of descriptions but a possibility of the final deployment. we will investigate the 10 pillars for 5G which will include various Radio Access Technologies that are required to interwork smoothly. We will look at the 4G Pro features and other RATs. WHAT WILL YOU LEARN * List the ten pillars of 5G deployment. * Describe the 5G Internet. * Explain virtualization and RAT virtulization. * Describe Software Defined Networks (SDN). * Explain carrier aggregation. * Describe the mobile cloud. * Explain an overall picture of 5G architecture. ESSENTIAL 5G TRAINING COURSE DETAILS * Who will benefit: Anyone looking for an understanding of the technologies and interworking requirements of the next generation of cellular communications. * Prerequisites: None. * Duration 3 days ESSENTIAL 5G TRAINING COURSE CONTENTS * Drivers for 5G 5G Road Map, 10 Pillars of 5G, evolving RATs, oSON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation. * 4G LTE Advanced MIMO technology in release 8, Downlink & uplink MIMO R8, MIMO technology in LTE advanced, Downlink 8-layer SU-MIMO, Downlink MU-MIMO, Uplink MU-MIMO, Uplink transmit diversity, Coordinated multi-point operation (CoMP), Independent eNB & remote base station configurations, Downlink CoMP. * ICIC & eICIC ICIC, Homogeneous to heterogeneous network evolution, Introduction to eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS). * Carrier aggregation Component carriers (CC), CC aggregation deployments, Intra-band contiguous solutions, Intra-band non-contiguous solutions, Inter-band non-contiguous solutions, CA bandwidth classes, Aggregated transmission bandwidth configurations (ATBC), Possible carrier aggregation configs. * eIMTA TDD UL-DL reconfig. for traffic adaptation, Reconfig. mechanisms, Interference mitigation schemes, Dynamic & flexible resource allocation. * 5G architectures 5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, 5G in North America, academy research, company R&D, 5G specifications. * The 5G internet High-level view of Cloud Services, The Internet of Things & context awareness, Network reconfiguration & virtualization support, server proliferation, how VMs fix underutilised server problem, enter the hypervisor, why are VM such a big deal? SDN, evolution of the data centre network, high availability, low latency, scalability, security, cost model explodes, service-oriented API. OpenFlow switches, OpenFlow controllers, how SDN works. The big picture, pulling it all together, why the network had to change, how SDN & NFV tie together. Evolutionary approach to the internet, architectures for distributed mobility management, MEDIEVAL & MEDIVO projects, a clean slate approach, mobility first architecture. VNet, INM, NetInf, ForMux, MEEM. Generic Path (GP) & anchorless mobility (AM), Quality of Service support, network resource provisioning, resourcing inside a network. IntServ, RSVP, DiffServ, CoS. Emerging approach for resource over- provisioning, example use case architecture for scalable resource control scenarios in the 5G internet. Integrating SDN/NFV for efficient resource over-reservation control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations & operations. * Small cells for 5G Average spectral efficiency evolution, WiFi & Femto cells, Capacity limits. Achievable gains with densifications, multi-antenna techniques, small cells. Mobile data demand, approach & methodology, subscriber density and traffic demand projections to 2020. Demand versus capacity, global mobile data traffic increase modelling, country level backhaul traffic projections, Small cell challenges, backhaul, spectrum, automation. * Cooperation for next gen wireless networks Diversity & relaying strategies, cooperation & network coding, ARQ & MAC protocols, NCCARQ & PRCSMA packet exchange, Physical layer impact on MAC protocol analysis, NCCARQ overview, PHY layer impact, Case study on NCCARQ. * Mobile clouds Mobile cloud, Mobile cloud enablers, mobile user domain, wireless technologies, WWAN WLAN and WPAN range, Bluetooth, IEEE.802.15.4 & software stacks, infrared, near field communications (NFC). Network coding, store & forward vs compute & forward, linear network coding, random linear coding. * Security for 5G communications Potential 5G communication systems architectures, Security issues & challenges. Mobile malware attacks targeting the UE, 5G mobile botnets, access networks, attacks on 4G networks, C-RNTI & packet sequence number based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, credential attacks, configuration and protocol attacks, attacks on MON, user data & identity attacks, mobile operator's core network, DDoS attacks targeting MON, signalling amplification, HSS saturation, external IP networks.

Essential 5G
Delivered in-person, on-request, onlineDelivered Online & In-Person in Internationally
£2367

Level 7 Diploma in Excel VBA Data Management - QLS Endorsed

By Kingston Open College

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Level 7 Diploma in Excel VBA Data Management - QLS Endorsed
Delivered Online On Demand
£105

Educators matching "Macro"

Show all 26