3151 ARC courses

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Get a step-by-step guideline on how to take amazing pictures and build a thriving career in the industry through the Digital Photography Masterclass course. This course will help you take your photography skills to the next level. Within a few steps, you will learn the essentials of capturing the perfect shot. This course is designed to provide you with an overall understanding of digital photography. Here, you will get to learn about the anatomy of the camera. Then the course will provide detailed lessons on exposure, colour, depth and much more. In the next step, you will grasp the skills to capture landscapes, portraits, architecture etc. Furthermore, the course will teach you effective editing skills and introduce you to photo editing software. In addition, through this course, you will learn the process of building your own photography business. This course is the perfect chance to build your expertise and secure a QLS-endorsed certificate of achievement. Enrol now! Learning Outcomes Get introduced to the camera and tools required for photography Learn the basic principles of different photography elements like exposure, white balance and more Build your expertise to photograph various events and scenarios Learn the techniques to take pictures in different lighting Develop the editing skills required to enhance the picture qualities Familiarise yourself with the steps to start your own photography business Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be a final assessment. A set of questions will be provided, and you can complete these questions according to your convenient time. After you submit the assignment, our expert team will evaluate them and provide constructive feedback. Career path This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Freelance Photographer Wildlife Photographer Event Manager Wedding Photographer

Learning Outcomes Get a thorough understanding of the concepts of interior design and the components that go into successful home styling Learn the techniques required to produce expert design plans and mood boards for home settings Investigate how to employ colour, texture, lighting, and materials to design rooms that are both aesthetically pleasing and useful Recognise the significance of eco-friendly and sustainable design principles in interior architecture Learn how to use design tools and software Get hands-on project management experience, including budgeting, purchasing, and speaking with vendors and contractors Create a professional portfolio that exhibits your ability to design successful solutions for home areas and highlights your design talents Overview Master the art of creating extraordinary yet comforting spaces with the Design and Home Styling Certificate Level 3 course. Students who enrol in the course will get a thorough understanding of the ideas and methods needed to design appealing, practical, and unique residential settings.  This diploma-level course aims to give students the information and abilities required to produce expert design plans, mood boards, and oversee interior design projects from beginning to end. The essential components of design will be examined by the students throughout the course. Students who will successfully complete the Interior Design and Home Styling Certificate Level 3 course will have a professional portfolio that highlights their creative abilities and shows how they can come up with effective design solutions for residential settings.  For those with a passion for design who want to work in interior design, home styling, or similar sectors, this diploma-level course is the best option. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment To successfully finish the course, students must take an online automated multiple-choice exam and achieve a minimum score of 60%. Upon passing the exam, students can apply for a certificate of achievement endorsed by the Quality Licence Scheme. Career path Completing an Interior Design and Home Styling Diploma Level 3 course can open up a range of career opportunities in the UK. Some potential career paths include: Interior Designer: The average annual salary for an interior designer in the UK is £26,000 - £40,000. Home Stager: The average annual salary for a home stager in the UK is £20,000 - £30,000. Set Designer: The average annual salary for a set designer in the UK is £22,000 - £45,000. Exhibition Designer: The average annual salary for an exhibition designer in the UK is £22,000 - £40,000. Course Contents Module 01: Popular Interior Design Styles and How to Use Them Module 02: Design Principles and Elements in Interiors Module 03: Introduction to Colour in Interiors Module 04: Introduction to Space Planning In Interiors Module 05: Textiles and Fabrics for Interiors Module 06: Styling and Staging Interior Spaces

Our comprehensive Transport Infrastructure Manager Course will provide you with all the collective knowledge and skills needed to control a complex building project from start to finish. Each stage of a construction lifecycle is examined, and you will be taught the abilities required to drive every part to a successful conclusion. Each module contains tips and techniques from the experts in the UK's building industry to enable you to excel as a Construction Manager. You will be taught how to investigate, organise, and finance a building site, along with all the equipment and resources that will be critical to realising the whole project. The contents also detail the processes for dealing with vendors, Human Resources, and Health & Safety. Each module delivers an in-depth presentation of the critical phases in a typical construction project and how to control it precisely. The Transport Infrastructure Manager Course is a reliable and effective method for the definitive training of a building specialist. The online study material has been crafted with the aid of industry experts and provides stimulating exercises that ensure your acquired knowledge will be retained and put to practical use. If you enrol now, you will rapidly gain the abilities to manage the most complex building projects with aplomb. Why choose this Transport Infrastructure Manager Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Method of Assessment To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? This course has been designed to train those individuals who have senior roles in a construction project or manages an active building. Comparable positions in the UK housing industry will also benefit from the information provided. Career path The training supplied by the Transport Infrastructure Manager Course will benefit those who work in a senior position on active construction sites or wish to do so. As such, it will significantly enhance the following careers or roles: Construction Manager Construction Project Manager Design Manager and Architects Building Site Manager Buildings Inspector Building Site Worker Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Photography: Photography Masterclass If you want to learn about Photography and become an expert in the field, you have arrived at the right place. Industry experts designed this Photography course to enable you to learn quickly and efficiently and at your own pace and convenience. Our expert instructors will teach you the basics of camera settings, lighting, composition, and more, as well as advanced techniques for capturing portraits, landscapes, and other subjects. You'll also learn about different types of photography, including wildlife photography, fashion photography, and architectural photography, so you can find your niche. Whether you're looking to turn your hobby into a career or simply want to take better photos for personal use, Training Tale's photography program has everything you need. Our flexible schedule and online platform make it easy to fit the program into your busy life. Why Choose Photography Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Photography course. [ Note: Free PDF certificate will provide as soon as complete the Photography Course course ] Photography: Photography Masterclass Industry Experts Designed this Photography course into 09 detailed modules. Assessment Method of Photography After completing each module of the Photography Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Photography After completing the MCQ/Assignment assessment for this Photography course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Photography: Photography Masterclass This Photography course is designed for those who want to learn the skills needed to start a successful career in the Media and art industry. Requirements Photography: Photography Masterclass There are no specific requirements for this Photography Masterclass course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Photography course must meet the following requirements: Photography: Good command of the English language Photography: Must be vivacious and self-driven Photography:Basic computer knowledge A minimum of 16 years of age is required Career path Photography: Photography Masterclass

Are you looking to enhance your Systems Engineering skills? If yes, then you have come to the right place. Our comprehensive course on Systems Engineering will assist you in producing the best possible outcome by mastering the Systems Engineering skills. The Systems Engineering course is for those who want to be successful. In the Systems Engineering course, you will learn the essential knowledge needed to become well versed in Systems Engineering. Our Systems Engineering course starts with the basics of Systems Engineering and gradually progresses towards advanced topics. Therefore, each lesson of this Systems Engineering course is intuitive and easy to understand. Systems Engineering Curriculum Breakdown of the Systems Engineering Course Course Outline: Software Hardware Security Networking Basic IT Literacy Why would you choose the Systems Engineering course from Compliance Central: Lifetime access to Systems Engineering course materials Full tutor support is available from Monday to Friday with the Systems Engineering course Learn Systems Engineering skills at your own pace from the comfort of your home Gain a complete understanding of Systems Engineering course Accessible, informative Systems Engineering learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Systems Engineering Study Systems Engineering in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Systems Engineering Course CPD 35 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Systems Engineering course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Systems Engineering. It is also great for professionals who are already working in Systems Engineering and want to get promoted at work. Requirements To enrol in this Systems Engineering course, all you need is a basic understanding of the English Language and an internet connection. Career path Systems Engineer: £40,000 to £70,000 per year Project Manager (Systems Engineering): £45,000 to £80,000 per year Systems Analyst: £35,000 to £60,000 per year Systems Integration Engineer: £40,000 to £70,000 per year Technical Consultant (Systems Engineering): £50,000 to £90,000 per year Systems Architect: £55,000 to £100,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Property Development - Diploma Online As long as civilization exists, the need for property development will continue to rise, making this one of the most profitable industries to build a career. This Property Development - Diploma can be a stepping stone for someone interested in property development and wants to get a head start in his career path. This course is designed to provide you with the knowledge and skills required to be a strong candidate in today's competitive job market. The Property Development - Diploma course covers the whole property development process, from the research stage to implementing plans and marketing the property. You will be guided through the process step by step using interactive audiovisual content. This course will lead you through many types of property in the real estate market, as well as English and Scottish property development laws. You will also learn about the property research process and financing options. Course Included in This Property Development - Diploma Courses Course 01: Property Development Course 02: Communication Skills Course Course 03: Level 7 Project Management Course [ Note: Free PDF certificate as soon as completing the Property Development - Diploma course] Property Development - Diploma Industry Experts Designed this Property Development - Diploma course into 09 detailed modules. Assessment Method of Property Development - Diploma After completing each module of the Property Development - Diploma Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Property Development - Diploma After completing the MCQ/Assignment assessment for this Property Development - Diploma course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Property Development - Diploma This Property Development - Diploma course is suitable for those who want to learn more about Property Development and wants to make a career in this field, which includes: Estate agents Construction project managers Real estate planners Property brokers Engineers Architects Requirements Property Development - Diploma There are no specific requirements for Property Development - Diploma course because it does not require any advanced knowledge or skills. Career path Property Development - Diploma Studying the Property Development - Diploma course is intended to help you obtain the skills, knowledge, and job of your dreams, as well as a publicity! With the assistance and guidance of our course, you will learn the necessary skills and knowledge to excel in your professional life. Certificates Certificate of completion Digital certificate - Included

Are you looking to enhance your Database Programmer skills? If yes, then you have come to the right place. Our comprehensive course on Database Programmer will assist you in producing the best possible outcome by mastering the Database Programmer skills. The Database Programmer course is for those who want to be successful. In the Database Programmer course, you will learn the essential knowledge needed to become well versed in Database Programmer. Our Database Programmer course starts with the basics of Database Programmer and gradually progresses towards advanced topics. Therefore, each lesson of this Database Programmer course is intuitive and easy to understand. Why would you choose the Database Programmer course from Compliance Central: Lifetime access to Database Programmer course materials Full tutor support is available from Monday to Friday with the Database Programmer course Learn Database Programmer skills at your own pace from the comfort of your home Gain a complete understanding of Database Programmer course Accessible, informative Database Programmer learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Database Programmer Study Database Programmer in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Database Programmer Course Database Programmer Curriculum Breakdown of the Database Programmer Course Unit 01: Introduction Unit 02: Manipulating Tables and Data - CRUD Operations Unit 03: Relationships and Foreign Keys Unit 04: Aggregate Functions CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Database Programmer course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Database Programmer. It is also great for professionals who are already working in Database Programmer and want to get promoted at work. Requirements To enrol in this Database Programmer course, all you need is a basic understanding of the English Language and an internet connection. Career path The Database Programmer course will enhance your knowledge and improve your confidence. Database Administrator: £35,000 to £65,000 per year Data Analyst: £25,000 to £50,000 per year Database Developer: £30,000 to £60,000 per year Business Intelligence Analyst: £35,000 to £65,000 per year Data Engineer: £40,000 to £75,000 per year Database Architect: £45,000 to £85,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Learning Outcomes Familiarise yourself with the anatomy of cameras Enrich your knowledge of white balance, exposure, lighting, lens and more Develop the skills to take pictures at different events and scenarios Build your expertise in photo editing Learn the techniques to take portraits, low-light images, landscape pictures etc Gain the confidence and competence to start your own photography business Description Master the art of capturing beautiful moments and memories in a frame with our comprehensive Complete Photography Course. This course is designed to help photography enthusiasts turn their passion into a successful profession. It will help you improve your skills and allow you to pursue your dream career. In this ultimate training program, you will learn the fundamentals of photography. The detailed modules will help you grasp the core elements of photography such as colour, white balance, exposure, lenses etc. Furthermore, you will grasp the techniques to take photos in a wide range of scenarios. The course will also include informative lectures on how to take different types of photos. Moreover, you will be able to develop effective editing skills. Finally, the course will show how to start your own photography business. Along with excellent photography skills, the course will provide you with a certificate of achievement endorsed by QLS. This certificate will uplift your CV and increase your employability. Join now! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an online MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, you will get the results immediately and can apply for your QLS-endorsed certificate. Career path This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Freelance Photographer Wildlife Photographer Event Manager Wedding Photographer Course Contents Introduction Exposure Digital Photography Masterclass Focus and Depth of Field Camera Anatomy White Balance and Color Lighting Mobile Photography Equipment - Cameras Equipment - Lenses Equipment - Accessories Photo Scenario - Portrait Photo Scenario - Long Exposure Photo Scenario - Landscape Photo Scenario - Product Photo Scenario - Low Light Photo Scenario - Sports & Action Photo Scenario - Macro Photo Scenario - Street & Architecture Photo Scenario - Events Photo Scenario - Aerial Photo Scenario - Night Intro to Photo Editing Photoshop CC Lightroom Classic CC Lightroom CC Mac Photos Google Photos Photoshop Express Snapseed Sharing Your Photos Starting a Photo Business Selling Stock Photos Printing Conclusion Wildlife Activity Upload

Are you looking to enhance your IT Consultant skills? If yes, then you have come to the right place. Our comprehensive course on IT Consultant will assist you in producing the best possible outcome by mastering the IT Consultant skills. The IT Consultant course is for those who want to be successful. In the IT Consultant course, you will learn the essential knowledge needed to become well versed in IT Consultant. Our IT Consultant course starts with the basics of IT Consultant and gradually progresses towards advanced topics. Therefore, each lesson of this IT Consultant course is intuitive and easy to understand. Why would you choose the IT Consultant course from Compliance Central: Lifetime access to IT Consultant course materials Full tutor support is available from Monday to Friday with the IT Consultant course Learn IT Consultant skills at your own pace from the comfort of your home Gain a complete understanding of IT Consultant course Accessible, informative IT Consultant learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the IT Consultant Study IT Consultant in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your IT Consultant Course IT Consultant Curriculum Breakdown of the IT Consultant Course Course Outline: Section 01: How People Use Computers Section 02: System Hardware Section 03: Device Ports and Peripherals Section 04: Data Storage and Sharing Section 05: Understanding Operating Systems Section 06: Setting Up and Configuring a PC Section 07: Setting Up and Configuring a Mobile Device Section 08: Managing Files Section 09: Using and Managing Application Software Section 10: Configuring Network and Internet Connectivity Section 11: IT Security Threat Mitigation Section 12: Computer Maintenance and Management Section 13: IT Troubleshooting Section 14: Understanding Databases Section 15: Developing and Implementing Software CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The IT Consultant course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in IT Consultant. It is also great for professionals who are already working in IT Consultant and want to get promoted at work. Requirements To enrol in this IT Consultant course, all you need is a basic understanding of the English Language and an internet connection. Career path IT Project Manager: £40,000 to £80,000 per year IT Business Analyst: £35,000 to £60,000 per year IT Consultant: £35,000 to £70,000 per year Solutions Architect: £45,000 to £85,000 per year IT Service Delivery Manager: £40,000 to £70,000 per year IT Program Manager: £50,000 to £95,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each