34 Nest courses in London

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients 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 public, one to one, tailored and bespoke courses. Tailored training courses: In, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

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 from our growing corporate clients 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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

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

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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

Python Basics: Course Description Excellent for beginners, practical, in small groups of max 4 people, 1 Day Online Instructor-led. You could contact us for your prefereed date. Session 1: Python Data Types and Variables: Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python. Operators and Expressions: Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.. Exercise: Calculate Movie Tickets for a Party, Are there enough seats in the cinema? Decision Making & Loops If statement; If - else statement; If- elif - else statement; Nested if - else; Exercise: Calculate the travel fee to deliver goods The while, For loop Jump statements: break, continue; Nesting loops. Exercise: Enter a password, if incorrect 3 times, you are blocked. Session 2: Data Structures Lists. Tuples. Exercise: Hangman Game Exercise: Get a word for the game from a Json File, store the high score in a Dictionary file Session 3: Files and exceptions Exception Handling, Exception types; Using try and Except. Files, streams: Open, Traverse, Read and Create Files: Csv, txt and Json Files. API: Connecting to API’s. Session 4: OOP Creating and using custom Functions. Using parameters and return values. Creating a Class; Creating an Object; Using an Object; Adding Instance variables; Class Constructors; Parameterized Constructors. Inheritance. Override. Session 5: Pandas Dataframe Basics Getting data into a dataframe: Dict to Dataframe, Dataframe to Dict. Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets. Getting information about the dataframe, Filter, sort and query a Dataframes, Slicing Dataframes, Duplicate values,Working with null-values, Sampling. Exercise: Query the top 1000 grossing movies of the last century Session 6: Built in Functions: String, Math, Random Python built-in functions: Strings functions. Maths functions. Random Functions. Exercise: Find information in prose, to get the sentiment of the prose. Exercise: Get a word for the game from a txt File Exercise: Win the lottery Included: PCWorkshops's Python Programming Basics Certification Course notes, exercises and code examples Revision session after the course Refund Policy No Refunds

Advanced Adobe InDesign Training Program Learn InDesign with a course at Real Animation Works. Choose from Weekend, Weekday or Evening Courses and learn from expert tutors. Benefit from professional InDesign training conducted by Adobe Certified Instructors with extensive graphic design expertise. Check our Website Duration: 10 hours. Approach: 1-on-1 and personalized attention. Schedule: 1-on-1 sessions, available Monday to Saturday from 9 am to 7 pm.   Course Title: Comprehensive Adobe InDesign Training Duration: 10 Hours Session 1: Introduction to Adobe InDesign (1 hour) Overview of InDesign interface and tools Document setup: page size, margins, and columns Basic text formatting and paragraph styles Introduction to working with images and graphics Session 2: Advanced Text Formatting and Styles (1 hour) In-depth exploration of character and paragraph styles Advanced text composition techniques Managing text flow with threaded frames Incorporating special characters for typographic control Session 3: Mastering Images and Graphics (1 hour) Advanced image manipulation: resizing, cropping, and effects Text wrap options and integrating text with images Creating image frames and working with transparency Interactive elements: buttons and hyperlinks Session 4: Layout Design Techniques (1.5 hours) Grids and guides: precise alignment and spacing Working with layers for efficient design management Advanced object arrangement and distribution Utilizing master pages for consistent layout elements Session 5: Advanced Document Features (1.5 hours) Tables and data merge: organizing and automating data Interactive PDFs: forms, multimedia, and navigation Advanced print preparation: color management and preflighting Exporting for various digital and print outputs Session 6: Advanced Special Effects (1 hour) Creating drop shadows, gradients, and blending modes Working with typography on a path Advanced text and image effects Integrating Adobe Illustrator and Photoshop files Session 7: Project-Based Learning (1 hour) Participants work on a comprehensive project applying learned skills Instructor-guided project review and feedback Session 8: Tips, Tricks, and Time-Saving Techniques (1 hour) Productivity hacks and shortcuts Troubleshooting common issues and errors Best practices for efficient workflow and collaboration Session 9: Portfolio Building and Career Guidance (0.5 hour) Creating a professional portfolio showcasing InDesign projects Career advice and industry insights from the instructor Session 10: Q&A, Certification, and Course Completion (0.5 hour) Addressing participant questions and concerns Certificate of Completion distribution and course review Celebrating the completion of the Adobe InDesign training journey Upon completion of the Comprehensive Adobe InDesign Training course, participants will: Master Core Skills: Develop proficiency in essential InDesign tools, functions, and techniques for effective layout design. Advanced Text and Typography: Understand advanced text formatting, paragraph styles, and typographic controls for professional typography. Image Manipulation Expertise: Acquire skills in advanced image manipulation, text wrapping, transparency, and integration of multimedia elements. Advanced Layout Design: Learn precise layout techniques using grids, guides, layers, and master pages for consistency and visual appeal. Interactive Document Creation: Create interactive PDFs, forms, multimedia-rich content, and navigation elements for digital publications. Data Management and Automation: Master tables, data merge, and automation features for organized data presentation and streamlined workflow. Print and Export Proficiency: Understand color management, preflighting, and export settings for high-quality print and digital output. Special Effects and Integration: Apply advanced effects, gradients, blending modes, and integrate InDesign with Illustrator and Photoshop files seamlessly. Project-Based Expertise: Develop a comprehensive portfolio-worthy project, showcasing a range of InDesign skills and creativity. Efficient Workflow and Troubleshooting: Implement time-saving techniques, shortcuts, and troubleshoot common design challenges effectively. Career Readiness: Gain valuable insights into industry practices, portfolio building, and career guidance for pursuing opportunities in graphic design and desktop publishing. Versatile Learning Choices: Opt for either in-person sessions at our London center or engage in interactive online learning. Both options offer hands-on experience, detailed demonstrations, and ample chances for inquiries. Compatibility and Assistance: InDesign operates smoothly on Windows and Mac systems. Participants receive a comprehensive InDesign training manual for reference and an electronic certificate upon course completion. Additionally, enjoy lifelong email assistance from your InDesign instructor. Entry Requirements: No prior InDesign expertise is necessary. The training concentrates on InDesign 2023, relevant to recent software updates. Guarantees: We ensure exceptional value for your investment, guaranteeing your acquisition of essential skills and concepts during the training. Course Highlights: Master advanced typography techniques, including paragraph styles, character styles, and nested styles. Explore multi-page layout design, long document management, and advanced table formatting. Acquire skills to create and manipulate complex shapes, vector graphics, and custom illustrations. Learn efficient workflows for data merging, interactive documents, and digital/print output. Collaborate seamlessly with other Adobe Creative Cloud applications. Upon completion, receive a Certificate of Completion and access recorded lessons for self-paced learning. Expert Instruction: Learn from certified tutors and industry experts, gaining valuable insights, tips, and best practices for professional-level designs. Flexible Learning Options: Choose between in-person or live online sessions based on your schedule. Sessions are available Monday to Sunday, from 9 am to 8 pm, accommodating your convenience. Lifetime Support: Benefit from lifetime email support for continuous assistance. Our dedicated team is available to address your queries and challenges. Explore Adobe InDesign - Free Trial:  https://www.adobe.com/uk/products/indesign/free-trial-download.html

Who is this course for? SketchUp Night Training Courses. This course is designed for professionals and students interested in enhancing their SketchUp skills through evening sessions. Whether you're a beginner looking to learn the basics or an experienced user seeking advanced techniques, this course offers tailored instruction to suit various skill levels during evening hours. Click here for more info: Website 1-on-1 sessions. Mon to Sat between 9 am and 7 pm  Course Duration: 10 hours Method: 1-on-1 (In-person or Live Online) Design Your Own Template Craft custom templates 2D Geometry Essentials Construct fundamental 2D shapes (lines, arcs, circles, rectangles) Grasp the concept of geometric stickiness Exploring 3D Geometry Develop basic 3D shapes Master 3D geometric stickiness Visualize your model in 3D Effective Model Organization Organize your model effectively using layers Geometry Shaping Tools Shape geometry with the Push/Pull tool Manipulate geometry by moving entities Maintain coplanar geometry integrity Connect and generate complex forms Lock inferences for precision Expedite form generation Restore and refine surfaces Create and apply surfaces to your model Employ mirroring and array techniques Enhancing Visuals Apply materials for enhanced visuals Craft 3D text elements Utilize essential tools for creating and manipulating 3D structures Integration and Expansion Integrate component models from the 3D Warehouse Explore display options and styles Position and export models to Google Earth Model Efficiency Techniques Overcome stickiness challenges in your model Optimize modeling efficiency with component nesting Understand the impact of scaling on similar components Leverage groups and components for isolating geometry Efficiently manage components using the Component Browser 3D Warehouse Collaboration Access and share components via the 3D Warehouse Harness the power of dynamic components Master component inferencing and editing Combine and integrate components seamlessly Integration and Multimedia Import external sites into SketchUp Incorporate photographs into your projects Employ the Follow Me tool effectively Enhance your designs with the Materials Browser Collaborate with the 3D Warehouse community Fine-tune your model's style Interactive Presentations Create immersive scene-based walk-throughs Generate sections and animated scenes for compelling presentations Export and Integration Seamlessly export your work to AutoCAD and LayOut Learning Outcomes for Designers after this course: SketchUp Proficiency: Acquire mastery of essential 3D modeling and design tools. Advanced Modeling Skills: Apply intricate modeling techniques for architectural and interior components. Effective Space Planning: Organize interior spaces efficiently with space planning expertise. Architectural Precision: Create detailed architectural models and facades with precision. Custom Furniture Design: Craft bespoke furniture designs that enhance interior spaces. Texture Realism: Apply textures skillfully to achieve lifelike visualizations. Compelling Visual Presentations: Present design concepts with captivating visualizations. Effective Presentation Skills: Showcase ideas convincingly to clients and stakeholders. Professional Collaboration: Communicate seamlessly with industry professionals using SketchUp. Workflow Streamlining: Enhance project efficiency by streamlining design workflows for rapid iterations. Additional Benefits: Complimentary Portfolio Review Mock Interviews for Skill Enhancement Skills Acquired: Proficient SketchUp Mastery: Gain expertise in using SketchUp for 3D modeling, design, and visualization. Advanced Rendering Techniques: Learn to create realistic renders using plugins like V-Ray or Twilight Render. Efficient Workflow: Develop skills to streamline your design process and enhance productivity. Collaboration and Presentation: Explore techniques for collaborative work and compelling project presentations. Job Opportunities: Architectural Designer: Create detailed 3D models and visualizations for architectural projects. Interior Designer: Design and visualize interior spaces for residential and commercial clients. Landscape Architect: Develop 3D landscape designs and presentations for outdoor spaces. Freelance 3D Artist: Offer your services for various projects, from architectural visualization to product modeling. Visualization Specialist: Provide visualization services to real estate agencies, design firms, or marketing companies. Why Us? Personalized Training: Dive into SketchUp with exclusive coaching from experienced architects and designers. Enjoy 1-on-1, in-person sessions at (SW96DE) or participate in live online classes. Flexible Schedule: We're available Monday to Saturday from 9 am to 7 pm, ensuring learning fits into your busy life. Tailored Tutorials: Take home custom video tutorials crafted to enhance your SketchUp skills. Comprehensive Learning: Access a digital reference book for thorough revision, ensuring a deep understanding of every SketchUp concept. Continuous Support: Enjoy ongoing assistance via phone or email, even after the course ends, ensuring your continued success. Adaptable Syllabus: We customize the syllabus and projects to meet your specific needs, ensuring focused learning on what matters most to you. Official Certification: Certificate upon course completion, validating your SketchUp expertise. Why Choose Us? Individualized Support: Our courses, ranging from 10 to 120 hours, provide unwavering assistance at every stage. Personalized homework assignments and post-course support pave the way for mastering SketchUp with expert guidance. Personal Attention, No Crowded Classes: Experience the intimacy of one-on-one learning. Say goodbye to overcrowded classrooms, ensuring you receive the focused attention you deserve in a confident and comfortable environment. Financial Flexibility: Your educational journey shouldn't strain your finances. We offer a range of payment plans tailored to your needs. Explore the available options and embark on your SketchUp learning adventure today. Expert Instructors, Real-world Expertise: Our instructors, meticulously chosen for their industry expertise and passion for teaching, are dedicated to imparting invaluable SketchUp skills to eager learners.