77 Trainers Course courses

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

Mastering 3ds Max and Photoshop Training Course. earn 3D design, modeling, and rendering with 3ds Max, and seamlessly integrate Photoshop skills. Expert instructors guide you in enhancing images and creating stunning renderings. Our 3ds Max course is designed to help you learn basic and advanced architectural visualisation. Click here for more info: Website Duration: 20 hours Approach: 1-on-1, Customized and Flexible pacing. Session Flexibility: Design your own timetable at your convenient hour between 9 am and 7 pm, Mon to Sat. 20-Hour Comprehensive Training in 3ds Max and Photoshop. Course Breakdown: Module 1: Introduction to 3ds Max (6 hours) Familiarization with 3ds Max's interface and workspace Navigation and basic modeling tools usage Creation and manipulation of primitive objects Object modification with modifiers for specific effects Materials, textures, and basic lighting techniques Introduction to rendering 3D scenes Module 2: Intermediate 3ds Max Techniques (6 hours) Advanced modeling with splines and polygons Camera creation and animation for realistic perspectives Character rigging and animation using bones Particle systems for visual effects and dynamic simulations Designing landscapes and outdoor scenes Exploration of advanced lighting and rendering methods Module 3: Introduction to Photoshop for 3D Artists (4 hours) Understanding Photoshop interface and essential editing tools Seamless integration of 3D models and textures between 3ds Max and Photoshop Creation and editing of textures and materials for realistic surfaces Post-production and compositing techniques to enhance 3D renders Module 4: Advanced Photoshop Techniques for 3D Artists (4 hours) Custom brush and texture creation for artistic elements Non-destructive editing using layer masks and adjustment layers Advanced compositing for seamless 3D element integration Crafting photorealistic textures and materials for impressive visuals Module 5: Project-Based Learning (4 hours) Application of learned techniques to a real-world project 3D modeling, texturing in Photoshop, and final image rendering Instructor feedback for project refinement Presentation of completed projects, showcasing acquired skills. Attendees will learn to craft intricate 3D models using Autodesk 3ds Max, mastering primitive objects, splines, and polygons for complex designs. Advanced Rendering Techniques: Participants will acquire skills in texturing, material application, lighting strategies, and rendering tools, crafting visually striking and lifelike 3D environments. Animation Prowess: Students will delve into object and character animation, simulation of perspectives with cameras, and the dynamic use of particle systems for visual effects and simulations. Essential Photoshop Proficiency: Attendees will gain vital Photoshop skills for post-processing, compositing 3D renders, and creating realistic textures, enhancing the quality of their 3D projects. Hands-On Project Engagement: Through practical projects, participants will receive expert feedback, honing their skills and demonstrating their expertise in real-world applications. Creative Problem-Solving Abilities: Attendees will cultivate creative thinking and problem-solving skills, enabling them to manifest their unique artistic visions in their 3D projects. Skills Acquired: Participants in the Mastering 3ds Max and Photoshop Training Course will gain advanced proficiency in 3D modeling, texturing, lighting, and rendering using 3ds Max. Additionally, they will master digital image manipulation, graphic design, and photo editing techniques using Photoshop. Key skills include: Advanced 3D Modeling and Rendering in 3ds Max Expert Texturing and Lighting Techniques Digital Image Manipulation and Retouching in Photoshop Graphic Design and Visual Communication Skills Job Opportunities: Upon completion, individuals can pursue a range of exciting career opportunities, including: Senior 3D Artist Game Developer Architectural Visualization Specialist Graphic Designer Visual Effects Artist This course equips participants with the expertise needed for roles in animation studios, game development companies, architectural firms, advertising agencies, and more, providing a pathway to thriving careers in the creative industry. Advantages of joining this program: Thorough education: Excel in 3ds Max and Photoshop for high-quality visual effects and motion graphics at a professional level. Certified mentors and industry specialists: Receive instruction from seasoned professionals for expert direction. Interactive online sessions: Engage from any location; no need for travel. Lesson recordings: Access recorded sessions for revision and reinforcement. Long-term email assistance: Receive ongoing support even after the course completion. Complimentary career guidance: Gain valuable industry insights to boost your career prospects. Download Adobe Photoshop Download Autodesk 3dsmax

Photoshop Training Course Basics to Advanced designed for individuals of every skill level, ranging from beginners to advanced image editing professionals. Immerse yourself in the realm of potent image manipulation tools at our school in London. Personalized Photoshop courses either at our facility or directly at your location. Click here for more info: Website Duration: 20 hours. Method: Personalized 1-on-1. Schedule: Customize your learning with pre-booked sessions available Monday to Saturday, from 9 am to 7 pm. Course Title: Mastering Photoshop: From Basics to Advanced Proficiency Course Duration: 20 hours Module 1: Introduction to Photoshop (2 hours) Understanding the Photoshop interface Navigating tools and panels Basic keyboard shortcuts for efficient workflow Introduction to different file formats and their uses Module 2: Essential Tools and Techniques (3 hours) Selection tools and techniques for precise editing Working with layers: management and blending modes Understanding brushes, gradients, and patterns Introduction to basic filters and their applications Module 3: Image Editing and Retouching (4 hours) Color correction and adjustment layers Advanced retouching techniques: Healing Brush, Clone Stamp, and Content-Aware tools Removing backgrounds and unwanted elements Restoring old or damaged photographs Module 4: Advanced Photo Manipulation (3 hours) Compositing multiple images seamlessly Advanced blending modes and layer effects Creative use of masks and clipping paths Special effects: lighting, shadows, and reflections Module 5: Text and Typography (2 hours) Working with text layers and formatting options Creating custom typography and text effects Utilizing layer styles for creative text designs Text manipulation along paths and shapes Module 6: Web and UI Design (3 hours) Designing web banners, buttons, and interfaces Slicing and optimizing images for the web Creating interactive prototypes and mockups Exporting assets for web and app development Module 7: Print Design and Prepress (2 hours) Understanding color modes: CMYK vs. RGB Setting up documents for print: bleed, margins, and resolution Designing print materials: brochures, business cards, and posters Preparing files for professional printing Module 8: Project-Based Learning (1 hour) Applying learned techniques to real-world projects Instructor-led project: creating a digital artwork or advertisement Feedback and critique session for skill refinement Final presentation of completed projects Upon completion, you will: Master Photoshop Skills: Gain proficiency in fundamental and advanced Photoshop techniques, enabling professional-level image editing and creative design. Enhance Creativity: Develop creative problem-solving abilities, enabling innovative and visually appealing design solutions. Job Opportunities: Graphic Designer: Craft compelling visual content for ads, websites, and marketing materials. Photo Retoucher: Edit and enhance photographs to meet professional standards. Digital Artist: Create digital artwork and illustrations for various purposes. Web/UI/UX Designer: Design user-friendly interfaces and engaging online experiences. Marketing Content Creator: Generate eye-catching promotional visuals and social media content. Video Editor: Enhance video footage and create engaging video content for online platforms. Professional Adobe Photoshop Training in London - On-Site & Live Virtual Classes Being the industry-leading image editing software, Photoshop empowers users to manipulate images, enhance colors, and create visually striking designs. Its extensive toolkit allows for intricate adjustments, retouching, and even editing videos, graphic design, and 3D imagery. Enroll in our Photoshop course to establish a strong foundation in creative visuals, focusing on essential skills like image adjustment, composition, and common troubleshooting. For a more in-depth understanding, our Advanced course delves into advanced techniques such as color fills, text and layer styling, and creating web-ready artwork. Explore our masterclass options for advanced training and deeper insights. Both beginner courses are available in physical classrooms and online, providing flexible learning opportunities.   Holistic Design Education: Comprehensive training across diverse design fields. Industry-Experienced Instructors: Learn from seasoned professionals in the field. Flexible Learning: Accommodating schedules for busy professionals and students. Practical Projects: Hands-on projects for real-world design experience. Career-Focused Skills: Acquire industry-relevant skills for professional growth. Cutting-Edge Facilities: Access state-of-the-art technology and facilities. Personalized Training: Tailored programs to suit individual learning needs. Networking Opportunities: Connect with design professionals for valuable connections. Innovation Exploration: Explore creative trends and emerging technologies. Ongoing Support: Continuous assistance and post-course guidance.

Develop your machine polishing skills. Ideal for those wanting to learn a specific machine polishing style, our Introduction to Machine Polishing for Professionals one-day course is a perfect starting point to get you using machine polishers in a safe, controlled environment. If you already use machines for correction work, it's an opportunity to reset your skills, pick up practical tips and advice, and increase your efficiency with either a different style or one you have used, but were never comfortable with. Develop your technique in a controlled scenario and the ability to make mistakes and learn, with instructor-led training selecting from a huge range of machines, and become proficient in machine polishing all types of surfaces. Learn defect assessment and solutions, lighting, compound technology, machine handling, and efficiency tips for professional results. Our one-day introduction to machine polishing for professionals course is ideal for those who have either; Have never needed to pick up a machine before Have always used only one type of machine Have restricted themselves to entry-level machines and basic techniques, and are now looking to upgrade or improve on a specific style; be it rotary, long throw DA or forced drive. Machines covered on these days could include the Rupes LHR 15/21, Flex XFE, XCE, rotary machines from sleek Flex PE14, through to heavier Makita models, and a further selection from over 23 machines we hold in-house or any machine you choose to bring yourself - just let us know on the day what you would prefer to concentrate on. For those already holding some experience who want to try their hand with different machines whilst improving overall techniques we also run this as a one-day Intermediate course with Flex, or for an overview of several machine types you can look at our Advanced Machine Polishing course over two days. Introduction to Machine Polishing doesn't just concentrate on the hardware though. Also covered in the course are: Surface defects and contamination. Efficiency and productivity methods. Preparation and decontamination stages. 'Reading' the paint. Defect identification. Paint thickness measurements using Magnetic Resonance, Eddy Current, and Ultrasonic gauges. The 'Polish/Don't Polish' decision. Introduction to Pad and Compound types and selection. Finishing techniques. Dressing, Sealant/Wax choices, and presentation. Health and Safety The aim of this course is to make you comfortable with using a machine polisher style over a range of scenarios, to enable you to further practice and perfect the technique required for full competency. Course Length 1 Day (0930-1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Open to all Refreshments or Lunch Refreshments included

Outspoken Cycles Park Tool School courses are aimed at home mechanics who wish to have an in-depth knowledge of their bikes as well as those individuals required to maintain bikes for friends, schools, clubs, businesses and other organisations. The 4 Day Advanced course teaches you advanced mechanical skills following the Park Tool Big Blue Book of Bicycle Repair syllabus in order to help you gain the confidence to take on bicycle repairs involving various manufacturers and systems. Completion of assessment leads to the award of a certificate. You are encouraged to work on your own bike. Please be aware for some elements of the course certain bikes may not be suitable, however, there are also a number of classroom bikes to work on where necessary. We can provide a classroom bike if you’re unable to bring your own.  Course Detail Over four days you will cover: Workshop Practices (Health and Safety, Safe use of tools, PPE, etc.) Tyres & Tubes (Inspection, sizing, systems, puncture repair) Cassettes & Freewheels (types, compatibility, wear, removal and installation) Hub Service (full strip down and rebuild, different systems) Gears and Cabling (identify issues, re-cable, set up and adjustment) Headsets (a-Head and Quill types, strip down and reassemble) Wheel Truing (spoke replacement, introduction to truing, demo wheel construction and lacing) Frame Assessment & Preparation (damage, tools, frame preparation etc.) Bike Setup (choosing the right size bike, saddle height, basic bike fit) Cranksets & Bottom Brackets (different types discussed, removal and replacement) Rim & Disc Brakes (mechanical disc and rim brake set up and adjustment, demo of hydraulic brake bleed) Price The course costs £500 inc VAT. This includes Park Tool Big Blue Book of Bicycle Repair and the use of all tools and equipment while on course.  If you’re a Cambridge Cycling Campaign member, we offer a 15% discount to support the good work that they do. Please email us for access to your coupon code. Refunds for courses are only given under exceptional circumstances and never within 7 days of the advertised course. In the unlikely event we have to make the difficult decision to cancel a course, participants will be offered a refund or the option to reschedule. Please read our terms and conditions for full details. Pre-requisites Course participants must be 18 years old or above. We may be able to accommodate younger participants 16+, we accept these on a case by case basis based on prior experience. Please contact us to discuss. Participants should have a good knowledge of the key content outlined in the Basic: Ride With Confidence and Intermediate courses before booking the Advanced course as this level of knowledge is assumed by the instructor on the day. There will be a brief refresher, but if you are unsure do get in touch to discuss. Course Timings, Assessment, Location & Travel Courses run 9am-4pm over four days, or 9:30am – 4:30pm for weekend courses. Courses take place in our dedicated training workshop at our offices in Cambridge. We have an abundance of bike racks, and we are close to Cambridge North Station. There is limited parking on site on a first-come-first-served basis and we are close to parking at Cambridge North Station. There is some limited on-road parking (at owners risk). You may also park for free at the Milton Park & Ride, which is only a short 15 minute cycle to our workshop.  Further details If you have any further questions, please do please get in touch to discuss. For more information, please read our Terms & Conditions. I would like to say a big thank you to all the teachers for the knowledge they have given me, I’ve loved learning it – Simon Spry, PTS Advanced Participant July 2022

This course shows you how to apply various approaches and algorithms to solve business problems through AI and ML, follow a methodical workflow to develop sound solutions, use open-source, off-the-shelf tools to develop, test, and deploy those solutions, and ensure that they protect the privacy of users. This course includes hands-on activities for each topic area.

Enhance your valeting team's skills for high-quality results. Valeting for Business Stage 2 follows on from Stage 1 by going into deeper levels of preparation and decontamination and introducing machine polisher enhancement and minor correction to their skillset. perfect for attending to used and re-sale vehicles, maintenance of higher use fleets, and new cars which arrive in need of a little extra work prior to handover. Get your valeting team to a standard to deal with minor paint defects, interior issues, and machine polishing work in-house - both hyper-efficiently and safely. Enhance your team's skills for high-quality results your customers will love. Valeting for Employees Stage 2 follows on from Stage 1 by going into deeper levels of preparation and decontamination and introduces machine polisher enhancement and minor correction to their skillset. Perfect for those attending to used and re-sale vehicles, maintenance of higher use fleets, and dealerships delivering new cars which can arrive in need of a little extra work prior to handover. Get your valeting team to a professional standard to deal with minor paint defects, interior issues, and machine polishing work in-house - both hyper-efficiently and safely. The course day includes; Health and safety discussion and a run-through of vital inspections and checks prior to work. Advanced chemical and decontamination skills and knowledge. Pre-polishing preparation - clay bars, solvent cleaners and mechanical decontamination. Machine polishing skills, and the health and safety requirements for their usage. Interior odour removal and deep cleaning techniques. Stone chip and small area scratch removal and refinement. Please note: Stage 1 must be completed before Stage 2, though they can be booked on consecutive days. With the combined Stage 1 and 2 certification, attendees will be able to address various valeting requirements and can complete quite complex jobs efficiently, and satisfactorily in-house. This will reduce the need to call in specialists, and enhance vehicle turnaround times through greater workflow and competence. Claim back your costs! Students will hold a UKDA accredited certificate in Stage 2 Valeting for Business, and as we are a Government Registered Learning Provider, you can be assured of the highest quality of training. As, in most cases, HMRC considers vocational training to be for the benefit of the business and a legitimate business expense, course costs can usually be recouped against company taxes, and a full VAT invoice is provided for reclamation.   Course Length 1 Day (0930-1600) Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Completion of Level 1 Certification UKDA Certified

Invest in your staff, invest in your business. Valeting for Businesses Stage 1 is the ideal course set for employers of valeting teams or individuals, small and large, to improve the efficiency, safety and knowledge of their in-house valeting operation, increasing end-customer satisfaction and reducing the need for remedial work for errors and issues caused by poor technique. Combined with Stage 2, students receive a leaner version of our Level One Detailing course without the emphasis on self-employed business skills. It focuses instead on core skills employers need in a valeting team; Efficiency, Safety, Consistency, and Results. Invest in your staff, invest in your business. Valeting for employees is the ideal course set for employers of valeting teams or individuals, small and large; such as car sales, dealerships, car rental agencies or fleet operators. The aim of the course is to improve the efficiency, health & safety, and knowledge of their in-house valeting operation. Combined with level 2, students receive a leaner version of our Level One detailing course, without the emphasis on self-employed business and marketing skills. It focuses instead on core skills employers need in a valeting team; Efficiency Safety Consistency and Results It can be taken by one managing member or a whole team, and is perfect for any experience - from new-starter to long-time member of staff. The day starts with a look at chemical knowledge and safety to ensure all employees know the precautions and potential effects of the chemicals they are using in their work - both to themselves and the materials they are working on. Coupled with general safety at work regulations and delivered by a certified instructor, this will ensure your due diligence and compliance are covered and educate attendees on the importance of chemical safety. We then move on to the practical element, working through all the stages of a consumer-preferred safe wash and interior valet, from inspection through to protection applications, all in the most time-efficient manner possible to deliver showroom results, with demonstration and involvement in all stages and time management to ensure a constant and predictable workflow. By the end of the Stage 1 day, attendees will be well versed in all aspects of basic valeting skills and can either return to implement their new skill set or progress to Stage 2 to enhance the value further. Courses can be attended by up to 6 employees at a time, and for 3+ attendees the day can be run remotely at your own premises, subject to a few additional costs. For courses of 6+ attendees, please contact us to discuss your requirements so that we can accommodate adequate instructor-to-student ratios. Claim back your costs! Students will hold a UKDA accredited certificate in Stage 1 Valeting for Business, and as we are a Government Registered Learning Provider, you can be assured of the highest quality of training. As, in most cases, HMRC considers vocational training to be for the benefit of the business and a legitimate business expense, course costs can usually be recouped against company taxes, and a full VAT invoice is provided for reclamation. Course Length 1 Day (0930-1600) Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Certificate UKDA Certified

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 This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 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. 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included