• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

442 Ada courses in Leicester delivered Live Online

SketchUp Course With Layout and V-Ray

By ATL Autocad Training London

Why Opt for SketchUp Course With Layout and V-Ray? Learn SketchUp with Layout and V-Ray for professional 3D modeling, detailed modeling, and high-quality rendering. Essential for architects and designers for creating visualizations and precise presentations. Check our Website When can I Enrol? 1-on-1 training. Mon to Sat 9 am and 7 pm Book over the Phone 02077202581. Training Duration: 10 hours. You have the flexibility to split these hours over multiple days. Training Method: In-person or live online. Course Outline: SketchUp, Layout, and V-Ray - 10-Hour Training Module 1: Introduction to SketchUp (1 Hour) SketchUp Interface: Explore the basics of the SketchUp user interface. Navigation and View Tools: Learn how to navigate and manipulate 3D space. Module 2: SketchUp Fundamentals (1 Hour) Drawing and Modeling: Begin creating 3D objects and structures. Editing Tools: Manipulate and modify objects efficiently. Module 3: Advanced SketchUp Techniques (1 Hour) Components and Groups: Understand component and group organization. Layers and Scenes: Organize your model and create dynamic views. Module 4: SketchUp for Architectural Design (1 Hour) Architectural Modeling: Explore architectural modeling techniques. Interior Design: Apply SketchUp to interior space design. Module 5: Landscape Design with SketchUp (1 Hour) Landscape Modeling: Use SketchUp for outdoor environment design. Terrain and Topography: Model terrain and natural landscapes. Module 6: Introduction to Layout (1 Hour) Layout Basics: Get familiar with the Layout interface. Setting Up Viewports: Begin using viewports for presenting your SketchUp models. Module 7: Creating Layout Documents (2 Hours) Document Setup: Set up and customize your layout documents. Inserting SketchUp Models: Import SketchUp models into Layout viewports. Dimensioning and Labeling: Add dimensions and labels to your layout documents. Module 8: Presentation and Export (1 Hour) Styling and Rendering: Enhance your SketchUp models for presentations. Exporting and Printing: Learn how to export and print your Layout documents. Module 9: Introduction to V-Ray (1 Hour) V-Ray Interface: Get acquainted with the V-Ray user interface. Materials and Lighting: Learn the basics of materials and lighting in V-Ray. Module 10: Advanced V-Ray Rendering (1 Hour) Advanced Materials: Explore advanced material creation and customization. Realistic Lighting: Master V-Ray lighting techniques for photorealistic renders. By the end of this 10-hour course, you'll have a comprehensive understanding of SketchUp for 3D modeling, Layout for professional documentation, and V-Ray for rendering, empowering you to create stunning 3D designs and presentations. Upon completing this course, you will: Master SketchUp: Create 3D models with precision and creativity. Layout Proficiency: Produce professional design documentation. V-Ray Rendering Skills: Craft photorealistic visualizations. Advanced Techniques: Explore advanced modeling and rendering. Project Experience: Apply skills to real-world projects. Job Opportunities: Architectural Designer Interior Designer Landscape Designer CAD Technician 3D Modeler Rendering Specialist Visualization Artist Layout Specialist Freelance Designer Urban Planner Learning Objectives: Mastering SketchUp with Layout: Learn to create precise 2D floor plans, elevations, and construction documents using SketchUp's Layout tool. Advanced Rendering with V-Ray: Dive into V-Ray to create photorealistic renders, enhancing your visualizations with lighting, textures, and realistic materials. Collaborative Design: Develop skills for collaborative project planning and presentation, enabling effective communication with clients and teams. Job Opportunities: Architectural Visualization Specialist: Create detailed architectural visualizations and presentations for clients and marketing purposes. Interior Designer: Design interior spaces, produce detailed layouts, and create realistic renders for residential and commercial projects. 3D Visualization Artist: Work in the gaming or animation industry, creating 3D models and environments. Freelance Rendering Expert: Offer specialized rendering services to architectural firms, interior designers, or real estate developers. Layout Designer: Specialize in creating professional 2D layouts and construction documents for architectural projects. Why Choose Us? Tailored One-on-One Training: Personalized coaching from industry experts, in-person or online, Monday to Saturday. Customized Tutorials: Enhance skills with exclusive video tutorials designed for your learning journey. Comprehensive Resources: Access a digital reference book for thorough concept revision. Free Ongoing Support: Enjoy continuous assistance via phone or email even after the course ends. Flexible Syllabus: Adapted to your needs for focused and efficient learning. Official Certification: Ccertificate upon course completion. Why Us? Supported Individual Learning: Unwavering support with personalized homework and post-course assistance. Personalized Attention: Experience one-on-one learning, fostering a confident and comfortable environment. Financial Flexibility: Choose from various payment plans tailored to your budget. Expert Instructors: Learn from industry experts dedicated to your success.

SketchUp Course With Layout and V-Ray
Delivered in London or OnlineFlexible Dates
£348

SketchUp Night Training Courses

By ATL Autocad Training London

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.

SketchUp Night Training Courses
Delivered in London or OnlineFlexible Dates
£348

Deep Rest: A 3 Month Yoga Nidra Meditation Journey for Neurodivergent Parents & Caregivers

By Butterfly Minds

You deserve a space to rest and recharge This 3-month supported journey combines live Yoga Nidra meditation sessions, weekly check-ins, and gentle self-care practices designed to nourish your mind, body, and soul. I believe that Yoga Nidra is one of the best meditations for neurodivergent parents. When you're navigating your own unique experiences such as sensory sensitivities, the demands of parenting, and adapting to everyday situations you can end up feeling drained and overwhelmed. Yoga Nidra is a deeply restorative meditation that help you release mental, emotional, and physical stress and tension that you are carrying. It is said that 30 minutes of Yoga Nidra meditation is equivalent to 2-4 hours of sleep! A 3 month programme to reduce overwhelm and increase your energy I believe that Yoga Nidra is one of the best meditations for neurodivergent parents. When you're navigating your own unique experiences such as sensory sensitivities, the demands of parenting, and adapting to everyday situations you can end up feeling drained and overwhelmed. Yoga Nidra is a deeply restorative meditation that help you release mental, emotional, and physical stress and tension that you are carrying. It is said that 30 minutes of Yoga Nidra meditation is equivalent to 2-4 hours of sleep! Yoga Nidra or ‘yogic sleep’ is a form of guided meditation practiced lying down. It is a deeply restorative practice that can help you relax, recharge your energy, and improve your sleep. The practice guides you through specific techniques to help you feel rested and refreshed. Meditation can help with parenting too! Yoga Nidra meditation helps you feel more relaxed and provides a quiet space for you to simply be. That means you can feel more patient, as you won't be carrying as much stress, while going through the ups and downs of parenthood. And create a calmer mental space which will allow you to look after your own needs and continue supporting your whole family. With refreshed energy! That's why I created this Deep Rest programme to help you balance your energy! What's Included? X3 Live Yoga Nidra Sessions 1 monthly online meditation and reflection call via GoogleMeet Audio Meditation: Allowing you to continue with your rest practice between our live sessions Private Telegram Support: Weekly check-ins via messages and/or voice notes Weekly Reflection Prompts: Deepen your experience and track your emotional wellbeing Bonus Lifetime access to my Self-Care Bundle (people usually pay £97 for this): Gentle mindfulness, yoga, and journaling practices that you can return to anytime. This is for you if... You’re a neurodivergent parent or caregiver who feels exhausted by stress and the demands of parenting/caregiving. You’re looking for a for a private meditation experience. You’re ready to explore the transformative practice of Yoga Nidra. This is not for you if: You prefer a group setting. You’re looking for a single session, rather than a sustained, supportive journey of self-care. You’re not able to dedicate time to a deep, personal Yoga Nidra experience paired with ongoing support for lasting impact. Are you ready to increase your energy and create a calmer mind? *Available for wherever you are in the world, except the USA and Canada, due to my insurance.

Deep Rest: A 3 Month Yoga Nidra Meditation Journey for Neurodivergent Parents & Caregivers
Delivered OnlineFlexible Dates
£170 to £497

Successfully Managing and Exceeding Your Customers' Expectations

By Beyond Satisfaction - Customer service Training

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on managing expectations successfully.

Successfully Managing and Exceeding Your Customers' Expectations
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Microsoft Powerpoint Introduction (live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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 in company 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

Microsoft Powerpoint Introduction (live online classes)
Delivered OnlineFlexible Dates
£275

Dealing with uncertainty & change - 1 Day Online Workshop

By Haptivate

Explore practical neuroscience-backed tools to help you thrive in challenging circumstances.

Dealing with uncertainty & change - 1 Day Online Workshop
Delivered OnlineFlexible Dates
£249

Microsoft Word Intermediate (live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' 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 in company 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. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. Career path Career path Microsoft Office 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

Microsoft Word Intermediate (live online classes)
Delivered OnlineFlexible Dates
£275

Microsoft Project Advanced (live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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 Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office 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

Microsoft Project Advanced (live online classes)
Delivered OnlineFlexible Dates
£275

Microsoft Project Introduction (live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

Microsoft Project Introduction (live online classes)
Delivered OnlineFlexible Dates
£275

Microsoft Excel Intermediate - Online classroom

By Microsoft Office Training

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 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. 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. 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

Microsoft Excel Intermediate - Online classroom
Delivered OnlineFlexible Dates
£275