7519 Power courses delivered Online

Learn the power of Google Script and see how you can connect Google Spreadsheet as a data source for a post board

Learners will be introduced to Voice Alarm (VA) systems as part of the fire alarm solutions.

Explore the art and science of woodworking with our comprehensive course. From fundamental techniques to advanced skills, master the use of hand and power tools, joinery methods, and expert wood finishing. Unlock your creativity and craft timeless, handcrafted wood pieces. Enroll now for a hands-on experience in the world of woodworking craftsmanship.

Highlights of the Course Course Type: Online Learning Duration: 360 Hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about electrical engineering Understand the core competencies and principles of electrical engineering Explore the various areas of electrical engineering Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert electrician, electrical engineer or technicians Professional Electrician -13 Electrician Courses Bundle Are you interested to begin your electrical engineering career or want to gain more advanced skills in electrical engineering? Then this professional electrician course will help you get one step closer to your professional aspirations and develop your skills and knowledge in electrical engineering for a rewarding career. This Bundle Package Includes: The skills and knowledge that you will gain through studying the following courses will teach you the theory of effective electrical engineering practice and equip you with the essential skills, confidence and competence to assist you in the electrical engineering industry. You'll gain a solid understanding of the core competencies required to drive a successful career in electrical engineering. Electricity and DC Circuit Analysis For Professionals Master In Digital Electric Circuits Trigonometry For Electrical Engineering Professionals Engineering Calculus For Professionals Per Unit Analysis For Electrical Engineering Professionals Symmetrical Three Phase Voltages and Current Analysis Short Circuit Analysis For Electrical Engineering Professionals HV Power Circuit - Protection and Control Distribution Station & Feeder Protection For Professionals Master In Electrical 3 Phase Power Transformers Electric Power Metering For Professionals AC Circuits - Power Analysis AC Circuit Analysis For Beginners Gain electrical engineering skills and credentials that employers value. This bundle course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards to your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Master the skills you need to propel your career forward in electrical engineering. Equip yourself with the essential knowledge and skillset that make you a confident electrician, electrical engineer or technicians and take your career to the next level. This comprehensive bundle course is designed to help you reach your professional goals. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive course is designed for electrical engineering professionals who are aspiring to specialise in electrical engineering. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV. Enrol today and take the next step towards your personal and professional goals. Who is this Course for? This comprehensive professional electrician course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this electrical engineering can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This professional electrician course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This professional electrician course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This professional electrician course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Electricity and DC Circuit Analysis For Professionals Master In Digital Electric Circuits Trigonometry For Electrical Engineering Professionals Engineering Calculus For Professionals Per Unit Analysis For Electrical Engineering Professionals Symmetrical Three Phase Voltages and Current Analysis Short Circuit Analysis For Electrical Engineering Professionals HV Power Circuit - Protection and Control Distribution Station & Feeder Protection For Professionals Master In Electrical 3 Phase Power Transformers Electric Power Metering For Professionals AC Circuits - Power Analysis AC Circuit Analysis For Beginners Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Imagine a career where creativity meets strategy, and your digital presence makes a real impact. A career where you are not just a marketer but a storyteller, engaging audiences and driving results. If this sounds like the kind of career you're passionate about, then the Digital Marketing & Social Media Manager - Job Ready Program is the perfect opportunity for you. At studyhub, we understand that breaking into the competitive world of digital marketing and social media management can be challenging, especially without prior experience. That's why we go above and beyond to equip you with the knowledge and guidance you need to excel. Our expert mentors are seasoned professionals in the field, ready to provide personalised one-on-one counselling sessions that cater to your unique needs. But that's not all - we offer much more than just mentorship. Our program is designed to empower you with the essential tools to create a standout CV and portfolio that captures the attention of potential employers. We understand what employers are looking for, and we'll work with you to showcase your skills, creativity, and potential effectively. What sets us apart is our unwavering commitment to your success. We don't stop supporting you until you secure a job in the dynamic field of digital marketing and social media management. We provide ongoing assistance, helping you navigate the job market, refine your interview skills, and connect with potential employers. We are your dedicated job and career support system, guiding you every step of the way. Our mission is simple: To be your trusted partner and assist you every step of the way until you land the marketing job of your dreams. Here are the 30 courses we will provide once you enrol in the program: Course 01: Professional Digital Marketing Diploma Course 02: Learn to Drive Traffic into Sales through Digital Marketing Course 03: SEO - Search Engine Optimisation Course 04: Advanced Training on SEO & SMM Strategies Course 05: Content Marketing Certification Course 06: Content Writing Course 07: Certificate in SEO Content Writing Course 08: Social Media Marketing Course -The Step by Step Guide Course 09: Email Marketing Course Course 10: Sales and Marketing: Email Marketing Course 11: Unlocking the Power of Google Adwords for Digital Marketing Course 12: Google Ads Training Course 13: Facebook Marketing Course 14: Instagram Marketing Course 15: Affiliate Marketing Course 16: Linkedin Marketing Course 17: Youtube Marketing Course 18: Social Media Influencer Course 19: Youtube and Instagram Video Production Course 20: Make a Wordpress WooCommerce Amazon Affiliate Store Course 21: Build an Amazon Affiliate E-Commerce Store from Scratch Course 22: Affiliate Marketing Business Essentials Course 23: E-Commerce: Complete Guide to Income Mastery Course 24: Blogging Course 25: Determining Market Size for Your Product Course 26: Simple Copywriting Secrets: How to Write Killer Sales Copy Course 27: ChatGPT for Marketing Content and Productivity with AI Tools Course 28: Lead Generation and Attraction Marketing Training Course 29: Marketing Strategies for Business Course 30: Brand Branding Why Choose Us Money Back Guarantee: We believe in the effectiveness of our program. If you follow our guidance and do not secure a job within a specified period, we offer a money-back guarantee. Personalised Job Search Assistance: We're in this together! Our dedicated team will tirelessly support your entire job searching process, ensuring you have a compelling application that gets noticed. Expertly Crafted Portfolio: Your portfolio is your digital showcase. Our professional writers will create a customised portfolio highlighting your unique skills and experiences, maximising your chances of standing out among the competition. Strategic Placement: We understand the power of strategic exposure. We'll submit your portfolio to various platforms and networks, expanding your reach and connecting you with valuable opportunities aligned with your marketing career goals. One-On-One Consultation Sessions with Industry Experts: Gain invaluable insights and guidance from seasoned professionals who have excelled in the digital marketing and social media management field. Comprehensive Skill Development: Our program is designed to equip you with the most sought-after skills in the digital marketing and social media management sector, ensuring you have the knowledge and expertise to excel in any marketing-driven environment. Ongoing Support: The journey to your dream job doesn't end with placement. Our commitment to your success extends well beyond your initial training, with our support team available to answer your questions, provide guidance, and assist you as you progress in your marketing career. The Program is completed in 5 easy steps: Step 1 - Enrol in the program and start learning from the courses we provide Upon enrolment in the Digital Marketing & Social Media Manager - Job Ready Program, you gain lifetime access to 6 premium courses dedicated to honing your digital marketing and social media management skills. Our customer service team remains in constant contact with you, providing assistance at every step of your learning journey. Step 2 - Complete your courses and get certifications Upon completion of each course, you'll earn certifications through exams designed to test your knowledge. Achieving a 90% pass mark for the initial course and 80% for subsequent relevant courses is required. Once successful, you'll receive hardcopy certificates, solidifying your expertise in the field. Step 3 - Get a consultation session from a professional Marketing expert Elevate your Digital Marketing & Social Media Manager skills with a personalised one-on-one consultation session led by an industry-seasoned professional. Gain insights, expert tips, and tailored advice to propel your marketing career forward. Step 4 - Complete the CV and attend the interview Armed with your certifications, our team of professionals will craft a compelling CV and LinkedIn profile tailored to your unique strengths. Armed with these powerful tools, you'll confidently tackle job interviews, launching your career with a starting salary ranging from •30,000 to •50,000 annually. Step 5 - We will not leave you until you get a job Our commitment to your success goes beyond completion. We stand by your side, offering personalised support, expert guidance, and unwavering dedication until you secure your dream job. Your job search becomes our mission, ensuring you have the best chance for a thriving career in Digital Marketing & Social Media Management. Don't let your dream career as a Digital Marketing & Social Media Manager remain out of reach. Focus on developing your skills - finding a job is our task! Join our Job Ready Program today, and let us be your trusted partner on your journey to success. Why Choose Us: Money Back Guarantee We believe in the effectiveness of our program. If you follow our guidance and do not secure a job within a specified period, we offer a money-back guarantee. Trust us to be your dedicated partner in achieving your dream job in the dynamic world of Digital Marketing & Social Media Management. Detailed Curriculum Course 01: Professional Digital Marketing Diploma Comprehensive digital marketing fundamentals covering SEO, social media, email, and content strategies. Learn to craft effective campaigns, analyze data, and create impactful online presence. Course 02: Learn to Drive Traffic into Sales through Digital Marketing Explore advanced tactics to boost website traffic and convert leads to sales. Master the art of targeting, engagement, and conversion optimization in the digital landscape. Course 03: SEO - Search Engine Optimisation In-depth SEO training covering keyword research, on-page optimization, and backlink strategies. Acquire the skills to enhance website visibility and ranking on search engines. Course 04: Advanced Training on SEO & SMM Strategies Build expertise in advanced SEO and Social Media Marketing (SMM) techniques. Dive into algorithm updates, analytics, and harness the power of social platforms for optimal digital presence. Course 05: Content Marketing Certification Master content creation and distribution strategies. Develop engaging, keyword-rich content for diverse platforms, and understand the role of storytelling in effective digital marketing. Course 06: Content Writing Hone your writing skills for digital platforms. Learn to create compelling, SEO-friendly content that resonates with your target audience and drives online engagement. Course 07: Certificate in SEO Content Writing Specialized content writing with a focus on SEO. Craft content that not only captivates readers but also enhances search engine rankings and visibility. Course 08: Social Media Marketing Course - The Step by Step Guide A step-by-step guide to effective social media marketing. Understand platform dynamics, create engaging content, and implement strategies for organic and paid social media success. Course 09: Email Marketing Course Master the art of email marketing. Learn to build and segment lists, design impactful campaigns, and optimize for conversions while adhering to best practices. Course 10: Sales and Marketing: Email Marketing Integrate email marketing into your sales strategy. Explore techniques to nurture leads, build customer relationships, and drive revenue through targeted email campaigns. Course 11: Unlocking the Power of Google Adwords for Digital Marketing Harness the potential of Google AdWords. Understand keyword targeting, ad creation, and bid management to maximize visibility and achieve marketing goals. Course 12: Google Ads Training Comprehensive Google Ads training covering ad formats, targeting options, and campaign optimization. Gain expertise in creating effective advertising campaigns on the Google platform. Course 13: Facebook Marketing Dive into Facebook marketing strategies. Learn to create compelling content, utilize paid advertising, and leverage analytics to optimize campaigns on the world's largest social platform. Course 14: Instagram Marketing Master Instagram marketing essentials. Explore content creation, engagement strategies, and advertising techniques to build a strong brand presence on this visual-centric platform. Course 15: Affiliate Marketing Unlock the potential of affiliate marketing. Understand partnership structures, optimize promotional strategies, and leverage affiliate networks to generate passive income. Course 16: Linkedin Marketing Strategic marketing on LinkedIn. Explore content creation, networking, and advertising techniques to enhance brand visibility and generate business leads on the professional platform. Course 17: Youtube Marketing Comprehensive YouTube marketing training. Learn content creation, optimization, and advertising strategies to maximize visibility and engagement on the world's largest video platform. Course 18: Social Media Influencer Transform into a social media influencer. Discover content creation, audience engagement, and collaboration strategies to build a personal brand and monetize influence. Course 19: Youtube and Instagram Video Production Master video production for YouTube and Instagram. Learn scripting, filming, editing, and optimization techniques to create engaging and shareable video content. Course 20: Make a Wordpress WooCommerce Amazon Affiliate Store Build a profitable Amazon affiliate store using WordPress and WooCommerce. Learn to set up, customize, and optimize your online store for maximum affiliate revenue. Course 21: Build an Amazon Affiliate E-Commerce Store from Scratch Step-by-step guide to creating an Amazon affiliate e-commerce store. Covering product selection, site setup, and marketing strategies to generate income through affiliate sales. Course 22: Affiliate Marketing Business Essentials Essential knowledge for successful affiliate marketing. Covering niche selection, audience targeting, and optimization strategies to build a lucrative affiliate marketing business. CPD 1000 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Course 23: E-Commerce: Complete Guide to Income Mastery Comprehensive e-commerce guide covering product sourcing, store setup, and marketing strategies. Learn to maximize income through effective e-commerce practices. Course 24: Blogging Master the art of blogging for business. Explore content creation, SEO optimization, and monetization strategies to build a successful and profitable blog. Course 25: Determining Market Size for Your Product Learn market analysis techniques to assess the size and potential of your target market. Understand the importance of data-driven decision-making in product development and marketing. Course 26: Simple Copywriting Secrets: How to Write Killer Sales Copy Unlock the secrets of persuasive copywriting. Learn to craft compelling sales copy that resonates with your audience and drives conversions across various marketing channels. Course 27: ChatGPT for Marketing Content and Productivity with AI Tools Harness the power of ChatGPT for marketing content creation and productivity. Learn to use AI tools to streamline tasks, enhance creativity, and improve overall marketing efficiency. Course 28: Lead Generation and Attraction Marketing Training Master lead generation and attraction marketing techniques. Explore strategies to attract and convert prospects into customers through effective marketing campaigns. Course 29: Marketing Strategies for Business Develop comprehensive marketing strategies for business success. Covering market segmentation, targeting, positioning, and effective promotional tactics to achieve business goals. Course 30: Brand Branding Dive into the intricacies of brand branding. Learn to develop a strong brand identity, create brand messaging, and implement strategies to build brand loyalty and recognition. The Digital Marketing & Social Media Manager - Job Ready Program is crafted for individuals with diverse backgrounds who aspire to excel in the dynamic field of marketing. This program is especially ideal for: Entry-Level Marketing Enthusiasts:Individuals who are passionate about marketing and eager to kickstart their career in the digital marketing and social media management domain. Limited or No Prior Experience in Marketing:This program caters to individuals with minimal or no prior experience in the marketing industry, providing a comprehensive foundation for success. Recent Graduates in Marketing or Related Fields:Graduates looking to translate their educational background into practical skills and secure a position in the competitive landscape of digital marketing and social media management. Career Changers into the Marketing Field:Individuals seeking a career transition into marketing, leveraging this program to gain the necessary expertise and skills for success. Motivated Individuals Eager for Comprehensive Support:This program is perfect for those with a strong drive to succeed, offering extensive mentoring and support to navigate the complexities of digital marketing and social media management.CIM Diploma in Professional Digital Marketing (Online)Level 4 Diploma in Digital Marketing (HL)COB Certified Digital Marketing ManagerProfessional Diploma in Social Media Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements No experience required. Just enrol & start learning. Career path Digital Marketing Specialist Social Media Manager Content Marketing Coordinator SEO Analyst PPC Campaign Manager Email Marketing Specialist Digital Marketing Manager Brand Strategist Influencer Marketing Coordinator Online Community Manager E-commerce Marketing Specialist Data Analyst (Marketing) Marketing Automation Specialist Social Media Strategist Content Creator (Digital Marketing) Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included Student ID Card Digital certificate - Included The Quality Licence Scheme Endorsed Certificate of Achievement Hard copy certificate - Included

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

Level 5 - Two Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Telecomms training course description A comprehensive tour of the telecommunications technologies and terminology currently in use, and under development. What will you learn List and describe components of the PSTN. Explain how calls are made over the PSTN Compare analog and digital transmission methods. Describe the technologies within the transport plane. Recognise the benefits of extra features available in today's telephone networks. Telecomms training course details Who will benefit: Anyone new to the Telecommunications industry. Prerequisites: None. Duration 2 days Telecomms training course contents Telephone network architecture Handsets, local loop, distribution points, Local exchanges, main telephone switches, PBXs. Making a call - some basics Telephone call components, how a telephone call works, accessing the local exchange, loop disconnect, DTMF, standards, E.164, PSTN routing, Intelligent Networks, Special Rate Services. Analogue vs Digital Voice characteristics, PSTN bandwidth, analogue signalling, Digital encoding, PCM and the 64k, ADPCM and other voice compression methods. PBXs PABX, Call processing, networking PBXs, PBX facilities, bandwidth, blocking probability and Erlangs, Erlang models, using Erlang tables. Transmission methods Two wire transmission, 64k circuits, Nx64, E1, 2 wire to 4 wire conversion, echo, echo suppression, echo cancellers, twisted pair, coax, fibre optic, power lines, satellite systems, microwave. Signalling Analogue signalling, loop start, earth calling, E&M, AC15. Digital signalling -CAS, robbed bits and E1 slot 16 signalling. Digital signalling CCS, Q.931, SS7, Q.SIG, DPNSS, DASS2. Transport planes PDH, PDH issues, SDH, SDH architecture, SDH standards, SDH bit rates, SDH mulitplexors, DWDM. Networks Circuit Switched Networks, TDM, Packet Switched Networks, Frame Relay, Message Switching, Circuit Switching, STDM, Cell Switching, ATM, ATM cells, ATM traffic parameters, ATM QoS, MPLS. Other network access Modems, modulation, speeds, ISDN, BRI, PRI, xDSL, SDSL, ADSL. Other Services Centrex, VPNs, FeatureNet, CTI, Call Processing Systems, Voice Mail, Automated Attendant Systems, Interactive Voice Response, Call Management Systems, Call Conferencing, Star Services. Mobile communications 3 types of wireless telephone, mobile generations, base stations, cells, GSM, GPRS, 3G, UMTS, WCDMA, 4G, LTE. VoIP overview What is VoIP, VoIP benefits, What is IP? The IP header, Packetising voice, VoIP addressing, H.323, SIP, RTP. Bandwidth requirements.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

About this Virtual Instructor Led Training (VILT)  This 4 half-day Virtual Instructor Led Training (VILT) course will address a variety of contract and loan structuring issues associated with geothermal energy projects as well as comparison with solar, wind and battery storage. The course is designed to investigate how various project finance techniques and contract structures can be used to achieve a competitive power prices while maintaining a satisfactory equity return. Distinctive project finance features of power facilities that depend on geothermal, wind, hydro or solar resources will be evaluated with financial models. The course will cover economic analysis of exploration and development of geothermal facilities and how to incorporate probability of failure and success into an IRR framework. Subsequent sessions will address the theory underlying liquidated damages for delay, and performance as well as design of other incentives that is inherent in different contract structures. Nuanced project finance issues associated with structuring debt for renewable projects will be discussed including under what conditions the DSCR drives debt capacity and when the debt to capital ratio is instrumental. The course will be taught with a combination of theoretical discussions, term sheet review and focused financial models. Training Objectives Evaluation of the economic risks that arise from uncertainty associated with drilling exploration wells and development wells for geothermal projects. Analyse the theoretical issues with computing LCOE for geothermal projects compared to other renewable and non-renewable resources and the importance of cost of capital for renewable projects; Understand differences in contract structures for renewable projects and dispatchable projects and how a single price structure can distort incentives for efficient construction and operation; Understand components of financing that influence the bid price required to meet a required rate of return on equity and can result in relatively low prices with reasonable returns. Understand the importance of debt sizing constraints and what strategies are relevant when the debt to capital constraint applies relative to when the debt service coverage ratio drives the debt size; Understand how to compute P50, P90 and P99 for different projects driven by resource risk; Understand the difference between mean reverting resource variation and estimation mistakes that do not correct as the basis for 1-year P90 and 10-year P90. Understand under what conditions debt sculpting can affect returns and how synthetic sculpting can be used to increase returns when the DSCR constraint applies. Understand the theory of credit spreads, variable rate debt and interest rates in different currencies and compute the implied probability of default that in inherent in credit spreads. Understand how to evaluate the costs to equity investors and the benefits to lenders for various credit enhancements including DSRA accounts, cash flow sweeps and covenants. Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day, including time for lectures, discussion, quizzes and short classroom exercises. Trainer Your expert course leader provides financial and economic consulting services to a variety of clients, he teaches professional development courses in an assortment of modelling topics (project finance, M&A, and energy). He is passionate about teaching in Africa, South America, Asia and Europe. Many of the unique analytical concepts and modelling techniques he has developed have arisen from discussion with participants in his courses. He has taught customized courses for MIT's Sloan Business School, Bank Paribas, Shell Oil, Society General, General Electric, HSBC, GDF Suez, Citibank, CIMB, Lind Lakers, Saudi Aramco and many other energy and industrial clients. His consulting activities include developing complex project finance, corporate and simulation models, providing expert testimony on financial and economic issues before energy regulatory agencies, and advisory services to support merger and acquisition projects. Our key course expert has written a textbook titled Corporate and Project Finance Modelling, Theory and Practice published by Wiley Finance. The book introduces unique modelling techniques that address many complex issues that are not typically used by even the most experienced financial analysts. For example, it describes how to build user-defined functions to solve circular logic without cumbersome copy and paste macros; how to write function that derives the ratio of EV/EBITDA accounting for asset life, historical growth, taxes, return on investment, and cost of capital; and how to efficiently solve many project finance issues related to debt structuring. He is in the process of writing a second book that describes a series of valuation and analytical mistakes made in finance. This book uses many case studies from Harvard Business School that were thought to represent effective business strategies and later turned into valuation nightmares. Over the course of his career our key course expert has been involved in formulating significant government policy related to electricity deregulation; he has prepared models and analyses for many clients around the world; he has evaluated energy purchasing decisions for many corporations; and, he has provided advice on corporate strategy. His projects include development of a biomass plant, analysis and advisory work for purchase of electricity generation, distribution and transmission assets by the City of Chicago, formulation of rate policy for major metro systems and street lighting networks, advocacy testimony on behalf of low income consumers, risk analysis for toll roads, and evaluation of solar and wind projects. He has constructed many advisory analyses for project finance and merger and acquisition transactions. Lastly, our key course expert was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He received an MBA specializing in econometrics (with honours) from the University of Chicago and a BSc in Finance from the University of Illinois (with highest university honours). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations