3331 Design courses in Linlithgow delivered Live Online

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Join us on Thu Nov 07 2024 at 10:00:00 GMT for an exciting online event focused on enhancing your leadership skills. Whether you are an established leader or just starting out, this session is designed to boost your confidence and help you lead with clarity and purpose.

Duration 1 Days 6 CPD hours This course is intended for Certification Preparation for Platform App Builder is ideal for administrators, system integrators, and independent software vendors (ISVs) with an interest in sharpening the development, deployment, and administrative skills required to succeed in becoming a Salesforce Certified Platform App Builder Overview Architect and manage the correct data model based on business requirements. Configure application security. Define business logic and process automation declaratively. Design user interfaces. Customize applications for mobile use and Lightning. Deploy applications. Are you ready to take the next step in your career by becoming a Salesforce Certified Platform App Builder? By covering the details around the exam objectives, this course will help hone your knowledge of Salesforce application lifecycle management and the declarative and programmatic solutions available to you through guided scenarios, lecture, and discussion. Salesforce Fundamentals Capabilities of core CRM objects Boundaries of declarative customizations Use cases for programmatic customizations Security Restricting and extending object, record, and field access Determining appropriate sharing solutions Data Modeling and Management Determining an appropriate data model Relationship types and impact on record access, user interface, and reporting Considerations for changing field types Considerations of the schema builder Considerations for importing and exporting data Use cases of external objects Reporting Creating reports Report types Dashboards User Interface Customization options Custom buttons, links, and actions Declarative options for incorporating Lightning Components Mobile Declarative customizations available for the Salesforce1 user interface Business Logic and Process Automation Record types Formula fields Roll-up summary fields Validation rules Approval processes Workflow Visual workflow Process builder Automating business processes Ramifications of field updates and potential for recursion App Deployment Application lifecycle Sandboxes Change sets Unmanaged and managed packages Determining an appropriate deployment plan Wrapping Up Test preparation Practice exam

Duration 1 Days 6 CPD hours Overview Understand problems and the creative problem solving processIdentify types of information to gather and key questions to ask in problem solving Identify the importance of defining a problem correctlyIdentify and use four different problem definition toolsWrite concrete problem statementsUse basic brainstorming tools to generate ideas for solutionsEvaluate potential solutions against criteria, including cost/benefit analysis and group votingPerform a final analysis to select a solutionUnderstand the roles that fact and intuition play in selecting a solutionUnderstand the need to refine the shortlist and redefine itUnderstand how to identify the tasks and resources necessary to implement solutionsEvaluate and adapt solutions to reality This workshop will give students an overview of the creative problem solving process, as well as key problem solving tools that they can use every day. Skills such as brainstorming, information gathering, & analyzing data will be covered during class. Getting Started Workshop Objectives The Problem Solving Method What is a Problem? What is Creative Problem Solving? What are the Steps in the Creative Solving Process? Case Study Module Two: Review Questions Information Gathering Understanding Types of Information Identifying Key Questions Methods of Gathering Information Case Study Module Three: Review Questions Problem Definition Defining the Problem Determining Where the Problem Originated Defining the Present State and the Desired State Stating and Restating the Problem Analyzing the Problem Writing the Problem Statement Case Study Module Four: Review Questions Preparing for Brainstorming Identifying Mental Blocks Removing Mental Blocks Stimulating Creativity Case Study Module Five: Review Questions Generating Solutions (I) Identifying Mental Blocks Removing Mental Blocks Stimulating Creativity Case Study Module Five: Review Questions Generating Solutions (II) The Morphological Matrix The Six Thinking Hats The Blink Method Case Study Module Seven: Review Questions Analyzing Solutions Developing Criteria Analyzing Wants and Needs Using Cost/Benefit Analysis Case Study Module Eight: Review Questions Selecting a Solution Doing a Final Analysis Paired Comparison Analysis Analyzing Potential Problems Case Study Module Nine: Review Questions Planning Your Next Steps Identifying Tasks Identifying Resources Implementing, Evaluating, and Adapting Case Study Module Ten: Review Questions Creating a Performance Plan Planning the Follow-Up Meeting Celebrating Successes Identifying Improvements Case Study Module Eleven: Review Questions Wrapping Up Words from the Wise Lessons Learned

Ear Care, Ear Syringing, Wax removal

Duration 3 Days 18 CPD hours This course is intended for Professionals who want unparalleled creative freedom, productivity, and precision for producing superb 3D modeling. Overview Navigate the AutoCAD user interfacesUse the fundamental features of AutoCADUse the precision drafting tools in AutoCAD to develop accurate technical drawingsPresent drawings in a detailed and visually impressive way In this course, you will learn to navigate the AutoCAD user interfaces and use the fundamental features of AutoCAD. You will learn to use the precision drafting tools in AutoCAD to develop accurate technical drawings. Getting Started with AutoCAD Starting the Software User Interface Working with Commands Cartesian Workspace Opening an Existing Drawing File Viewing Your Drawing Saving Your Work Basic Drawing & Editing Commands Drawing Lines Erasing Objects Drawing Lines with Polar Tracking Drawing Rectangles Drawing Circles Undo and Redo Actions Projects - Creating a Simple Drawing Create a Simple Drawing Create Simple Shapes Drawing Precision in AutoCAD Using Running Object Snaps Using Object Snap Overrides Polar Tracking at Angles Object Snap Tracking Drawing with Snap and Grid (Optional) Making Changes in Your Drawing Selecting Objects for Editing Moving Objects Copying Objects Rotating Objects Scaling Objects Mirroring Objects Editing with Grips Projects - Making Your Drawing More Precise Schematic Project: Electronics Diagram Architectural Project: Landscape Mechanical Project (with Polar & Tracking) Mechanical Project: Surge Protector Mechanical Project: Satellite Organizing Your Drawing with Layers Creating New Drawings With Templates What are Layers? Layer States Changing an Object's Layer Advanced Object Types Drawing Arcs Drawing Polylines Editing Polylines Drawing Polygons Drawing Ellipses Analzying Model and Object Properties Working with Object Properties Measuring Objects Projects - Drawing Organization & Information Architectural Project Mechanical Project Civil Project Advanced Editing Commands Trimming and Extending Objects Stretching Objects Creating Fillets and Chamfers Creating Arrays of Objects Inserting Blocks What are Blocks? Working with Dynamic Blocks Inserting Blocks Inserting Blocks using the Tool Palettes Inserting Blocks using the DesignCenter Inserting Blocks using the Content Explorer Projects - Creating More Complex Objects Mechanical Project 1 - Plate Mechanical Project 2 - Gasket Mechanical Project 3 - Plate Mechanical Project 4 - Rocker Arm Architectural Project 1 - Floor Plan Architectural Project 2 - Floor Plan Civil Project - Parking Lot Setting Up a Layout Printing Concepts Working in Layouts Creating Layouts Creating Layout Viewports Guidelines for Layouts Printing Your Drawing Printing Layouts Print and Plot Settings Projects - Preparing to Print Mechanical Project Architectural Project Text Working with Annotations Adding Text in a Drawing Modifying Multiline Text Formatting Multiline Text Adding Notes with Leaders to Your Drawing Creating Tables Modifying Tables Hatching Hatching Editing Hatches Adding Dimensions Dimensioning Concepts Adding Linear Dimensions Adding Radial and Angular Dimensions Editing Dimensions Projects - Annotating Your Drawing Mechanical Project Architectural Project 1 Architectural Project 2 Civil Project Additional course details: Nexus Humans AutoCAD Level 1 - Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AutoCAD Level 1 - Essentials course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for individuals who want to gain basic and intermediate knowledge of working on AutoCAD Overview Upon successful completion of this course, students will be able to create basic and intermediate drawings utilizing the AutoCAD software In this course, you will learn to navigate the AutoCAD user interfaces and use the fundamental features of AutoCAD. You will learn to use the precision drafting tools in AutoCAD to develop accurate technical drawings. Utilizing the AutoCAD Software Startup Screen The Application Menu The AutoCAD User Interface AutoCAD Options [OP] Saving the Drawing ?Places? for Quicker Access of Drawings Wheel Mouse Tidbits The Governing Body of Workspaces Ribbon Management Layer Properties Manager Assigning a Linetype to a New Layer Off vs. Freeze Practical Features of Layer Walk Creating a Layer State Freezing Individual Layers with Layer Freeze Layer Lock Creating Drawings with AutoCAD Accuracy Measuring a Distance Measuring an Area Creating Basic Objects Object Selection Options Basic Editing Commands Polar Tracking Editing Polylines Variable Width Polyline Command Aliases Move and Copy with ?CTRL? Customizing Rollover Tooltips Cycle Through Stacked Objects Additional Selection Options Stretch Midpoint Between Two Points [M2P] Snap From Hatch Stuff Additional course details: Nexus Humans AutoCAD Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AutoCAD Essentials course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Learn how to channel your inner activist, increase your resilience, communicate directly and be happy not to take no for an answer.

Learn how to create a digital and data transformation strategy, using system thinking.

So often change fails because of our own pursuit of perfection. Learning to love imperfect change will improve your resilience and help you deliver positive change.