9618 Courses

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

Give a compliment to your career and take it to the next level. This Construction Engineering bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Construction Engineering bundle will help you stay ahead of the pack. Throughout the Construction Engineering programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Construction Engineering course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. Learning Outcomes of Construction Engineering Bundle: Learn the fundamentals of construction engineering. Understand the project life cycle and how to manage it successfully. Develop skills in cost management, site management, and materials management. Gain knowledge of health and safety in construction. Apply legal and ethical principles in construction. Communicate effectively with stakeholders. Use information technology to support construction projects. This Construction Engineering Bundle Consists of the following Premium courses: Course 01: Diploma in Construction Management Course 02: Building Surveyor Course 03: Land Surveying Course 04: LEED V4: Building Design and Construction Course 05: WELL Building Standard Course 06: Construction Industry Scheme (CIS) Course 07: AutoCAD VBA Programming - Beginner course Course 08: Construction Cost Estimation Diploma Course 09: Bricklaying Course 10: LOLER Training Course 11: Construction Safety So, enrol this Construction Engineering now to advance your career! Construction Engineering is a multidisciplinary field that combines the principles of engineering, management, and economics to plan, design, and construct buildings and infrastructure. This Construction Engineering course covers a wide range of topics, including project management, cost management, quality assurance, construction materials, and equipment. Curriculum of Construction Engineering Bundle Course 01: Diploma in Construction Management Introduction to Construction Management Project Life Cycle and Success Cost Management Preliminary Site Investigation and Site Organisation Site Management Planning and Management of Equipment Construction Materials Management Vendor Analysis in Construction Management Construction Procurement Stock Control Supply Chain Management The Main Participators Quality Assurance and Customer Care Legal Aspects of Contracting Human Resources Management Risk and Value Management Communications, Information and Documentation of Construction Health and Safety in Construction Management ---------- 10 more Construction engineering-related courses ------- How will I get my Construction Engineering Certificate? After successfully completing the Construction Engineering course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. This Construction Engineering course is a great choice to start. This Construction Engineering course will provide you with the knowledge and skills you need to succeed in this exciting field. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Construction Engineering Bundle: Students who are interested in a career in construction engineering Professionals who want to learn more about construction engineering Anyone who wants to learn about the planning, design, and construction of buildings and other infrastructure Anyone who wants to learn about the legal and ethical principles of construction Anyone who wants to learn about the use of information technology in construction Disclaimer: Our comprehensive Construction Engineering course will enhance your theoretical knowledge to help you explore your opportunities in relevant sectors. But please note that this Construction Engineering course is not a professional qualification and will not allow you to work professionally. Requirements This Construction Engineering course has been designed to be fully compatible with tablets and smartphones. Career path Having this Construction Engineering bundle, will increase the value of your CV and open you up to multiple job sectors: Construction Engineer: £25,000 - £40,000 Construction Project Manager: £35,000 - £60,000 Construction Site Manager: £30,000 - £50,000 Construction Quantity Surveyor: £30,000 - £50,000 Construction CAD Technician: £20,000 - £30,000 Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Diploma in Construction Management) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Learn how to build a RESTful API using ASP.NET Core 6, and then consume it in a modern Blazor single-page application. Along the way, you will review clean coding principles and patterns, RESTful standards, logging tools, database development and management, and application testing and deployment strategies.

We often run private workshops, these could be one to one lessons, two to one lessons, group sessions for parties or a private session for a group of friends to have a fun day out. Whatever the occasion or need, we are able to host your requirements at the Workshop. The best way to arrange a private session is to email us and tell us what it is you are looking for. Let us know if you have any specific dates or times in mind, and if you have any set goals in mind so we can gauge what you are looking to achieve. We can help you get the most out of your time with us and we will work hard to accommodate your needs Please contact us before booking to confirm booking timings and project ideas. Private one to one classes bookings are valid for one year from the purchase date. We often run private workshops, these could be one to one lessons, two to one lessons, group sessions for parties or a private session for a group of friends to have a fun day out. Whatever the occasion or need, we are able to host your requirements at the Workshop. The best way to arrange a private session is to email us and tell us what it is you are looking for. Let us know if you have any specific dates or times in mind, and if you have any set goals in mind so we can gauge what you are looking to achieve. We can help you get the most out of your time with us and we will work hard to accommodate your needs Please contact us before booking to confirm booking timings and project ideas. Private one to one classes bookings are valid for one year from the purchase date.

Are you someone wishing to learn the skills to analyze data professionally using Power BI? Do you want to learn to create impressive reports? Then this is the right course for you! Learn the complete workflow in Power BI from A-to-Z and advanced analytics with DAX-calculated columns and measures, forecasting, and advanced analytics.

Not sure where to start your DevOps journey? Or want to know what kind of activities a DevOps engineer would do on Git and GitHub in the real world? Or would you like to set up a production-ready Git environment for your developers? Then this course is for you.

Who is this course for? The Architecture and Interior Design course is ideal for individuals aiming to master both interior design and architecture. Guided by certified tutors from Autodesk and Adobe, students will gain comprehensive skills in these fields. Click here for more info: Website Duration: 40 hours.1-on-1 Training. In-Person or Live online. When can I book: 9 am - 7 pm (Choose your preferred day and time once a week). Flexible timing with advance booking Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction. Upon completion, participants will: Master Software Tools: Excel in AutoCAD, SketchUp, Vray, Photoshop, and InDesign for digital design. Advanced Design Skills: Create intricate 2D/3D designs, plans, and visualizations. Project Management: Manage layouts, plotting, and projects efficiently. Realistic Rendering: Produce lifelike visualizations using Vray. Creative Composition: Understand design principles for impactful creations. Portfolio Development: Create a professional online portfolio. Career Readiness: Prepare for job interviews and enhance resumes. Potential Jobs: Architect Interior/Exterior Designer CAD Technician Visualization Specialist Design Consultant Project Manager These skills open doors to varied roles in architecture and design, ensuring career growth and job readiness. Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction.

***Limited Time Exclusive Bundle*** Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Database Administrator course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Database Administrator bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Database Administrator course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Database Administrator and help you along your learning journey. Advanced audio-visual learning modules of these Database Administrator courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Database Administrator, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Database Administrator Bundle Consists of the following Premium courses: Course 01: Introduction to Data Analysis Course 02: Data Center Training Essentials: General Introduction Course 03: Data Analytics with Tableau Course 04: Basic Google Data Studio Course 05: Complete Google Analytics Course Course 06: Python for Data Analysis Course 07: Data Analysis in Excel Level 3 Course Course 08: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 09: GDPR Data Protection Level 5 Course 10: Level 3 Cyber Security Course 11: Encryption Course 12: Windows 10 Pro Complete Training Course 13: Functional Skills IT Course 14: Learning Computers and Internet Level 2 Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Administrator expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Introduction to Data Analysis Module 01: Introduction Module 02: Agenda and Principles of Process Management Module 03: The Voice of the Process Module 04: Working as One Team for Improvement Module 05: Exercise: The Voice of the Customer Module 06: Tools for Data Analysis Module 07: The Pareto Chart Module 08: The Histogram Module 09: The Run Chart Module 10: Exercise: Presenting Performance Data Module 11: Understanding Variation Module 12: The Control Chart Module 13: Control Chart Example Module 14: Control Chart Special Cases Module 15: Interpreting the Control Chart Module 16: Control Chart Exercise Module 17: Strategies to Deal with Variation Module 18: Using Data to Drive Improvement Module 19: A Structure for Performance Measurement Module 20: Data Analysis Exercise Module 21: Course Project Module 22: Test your Understanding Course 02: Data Center Training Essentials: General Introduction Module 01: Data Center Introduction Module 02: Data Center Reliability Module 03: Data Center Equipment Module 04: Data Center White Space Module 05: Data Center Support Spaces Module 06: Data Center Security, Safety, Networks and IT Course 03: Data Analytics with Tableau Module 01: Introduction to the Course Module 02: Project 1: Discount Mart (Sales and Profit Analytics) Module 03: Project 2: Green Destinations (HR Analytics) Module 04: Project 3: Superstore (Sales Agent Tracker) Module 05: Northwind Trade (Shipping Analytics) Module 06: Project 5: Tesla (Stock Price Analytics) Module 07: Bonus: Introduction to Database Concepts Module 08: Tableau Stories Course 04: Basic Google Data Studio Module 01: Introduction to GDS Module 02: Data Visualization Module 03: Geo-visualization Module 04: A Socio-Economic Case Study Course 05: Complete Google Analytics Course Module 01: Overview Module 02: Navigation and Admin Module 03: Creating a New Google Analytics Account Module 04: Website Account Creation Module 05: Connecting To WordPress Website Module 06: Connecting To HTML Site Module 07: Connect Custom Page and Site Builders Module 08: Setting Up Annotations Module 09: Setting Up Intelligence Events Module 10: Set Up Custom Segments Module 11: Export Data for Analysis Module 12: Set Up Custom Reports Module 13: Set Up Google Integrations Module 14: Google Analytics Templates Module 15: Real Time Reporting Module 16: Setting Up Goals Module 17: Third Party Integrations Module 18: Audience Menu Overview Module 19: Interests and Geography Module 20: Conclusion Course 06: Python for Data Analysis Welcome, Course Introduction & overview, and Environment set-up Python Essentials Python for Data Analysis using NumPy Python for Data Analysis using Pandas Python for Data Visualization using matplotlib Python for Data Visualization using Seaborn Python for Data Visualization using pandas Python for interactive & geographical plotting using Plotly and Cufflinks Capstone Project - Python for Data Analysis & Visualization Python for Machine Learning (ML) - scikit-learn - Linear Regression Model Python for Machine Learning - scikit-learn - Logistic Regression Model Python for Machine Learning - scikit-learn - K Nearest Neighbors Python for Machine Learning - scikit-learn - Decision Tree and Random Forests Python for Machine Learning - scikit-learn -Support Vector Machines (SVMs) Python for Machine Learning - scikit-learn - K Means Clustering Python for Machine Learning - scikit-learn - Principal Component Analysis (PCA) Recommender Systems with Python - (Additional Topic) Python for Natural Language Processing (NLP) - NLTK - (Additional Topic) Course 07: Data Analysis in Excel Level 3 Course Modifying a Worksheet Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Course 08: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Introduction Prepaid Expenses Models: Resources Download Accounting for Prepaid Expenses Excel Formulas Detailed: Introduction to three Excel Models Formula Based Prepaid Expenses Model Calculate Prepaid Expenses Amortisation from Exact Start Date Prepaid Expenses Summary with Power Query and Pivot Table Advanced VBA Prepaid Expenses Amortisation Model BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Thankyou Course 09: GDPR Data Protection Level 5 Module 01: GDPR Basics Module 02: GDPR Explained Module 03: Lawful Basis for Preparation Module 04: Rights and Breaches Module 05: Responsibilities and Obligations Course 10: Level 3 Cyber Security FUNDAMENTALS OF NETWORKING GETTING STARTED WITH CYBER SECURITY LET'S BEGIN - THE FUNDAMENTALS OF CYBER SECURITY DIVING DEEP INTO CYBER SECURITY TYPES OF ACTORS, ATTACKS, MALWARE AND RESOURCES FIREWALLS AND ANTIVIRUS KEY SECURITY CONCEPTS Course 11: Encryption Section 01: Introduction Section 02: Basics of Common Encryption Section 03: Technical Aspects of Encryption Section 04: AES Basic Tech Demo Section 05: File and System Encryption Section 06: Conclusion Course 12: Windows 10 Pro Complete Training Module 01: Course Overview Module 02: Building Your Virtual Lab Environment Module 03: Upgrading Windows 7, 8, or 8.1 to Windows 10 Module 04: Building a Microsoft Server 2016 Domain Module 05: Windows Deployment Services (WDS) Module 06: Windows 10 Firewall, Windows Defender and UAC Module 07: Networking Module 08: Troubleshooting Module 09: User Preferences Module 10: Maintenance Course 13: Functional Skills IT Section 1: Introduction Section 2: Information Technology Section 3: Components of IT Section 4: Hardware Section 5: Operating System Section 6: Application/Software Section 7: Networking Section 8: Security Section 9: Traffic Flow & Enterprise Level IT Components Section 10: Storage Section 11: Database Section 12: Virtualisation & Cloud Section 13: Management & Other IT Jobs Course 14: Learning Computers and Internet Level 2 Module 01 : Computer Operating and Troubleshooting Module 02 : Internet and Computing - Key Applications Module 03 : Internet and Computing - Tools & Networking Module 04 : Windows 8 for PC Module 05 : Windows 10 - New Developments Module 06 : Cyber Security Awareness CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Database Administrator bundle. Requirements Our Database Administrator course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Database Administrator expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Level 7 Diploma(FREE QLS Endorsed Certificate)| 11 CPD Courses+11 PDF Certificates| 145 CPD Points|CPD & CiQ Accredited

Unlock the keys to successful building construction with our 'Building Construction: Comprehensive Techniques Training' course. From Construction Management and CDM Regulations to Risk Assessment, Cost Estimation, and Safety Protocols, gain the skills needed for effective project execution. Elevate your expertise in occupational health, material management, and project management. Join us for a comprehensive learning experience that integrates theory and practice, ensuring you're well-prepared for the dynamic challenges of the construction industry. Enroll now and build your future with confidence.