1544 Running courses delivered Online

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 Certificates Certificates Certificate of completion Digital certificate - Included

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

YouTube Masterclass Certification There are more than 300 hours of video transferred to YouTube consistently, making it a hard market to break into, in the event that you have dreams or goals of running a fruitful YouTube channel. It takes a misleadingly enormous measure of difficult work to get your channel going, to make quality recordings and to draw in a wide enough crowd to guarantee that your endeavors pay off and that your substance sticks out. It is very cutthroat, and you need significantly something beyond extraordinary substance, to flourish - you need to realize how to get your substance seen by whatever number individuals as could be expected under the circumstances. This course expounds on the best way to fabricate and keep an effective YouTube channel. It starts by giving you a short prologue to the things that you need to have set up, before you can begin making content. The course proceeds onward to examine the most ideal manners by which to make content, guaranteeing that your thoughts age meetings are effective. Then, we survey manners by which to get your video seen by the broadest conceivable crowd. At long last, the course gives you tips and data on the most proficient method to make your recordings beneficial. You will Learn: The three bits of gear that you need, to begin About screen goal and suggested sizes The contrasts between quality, amount and consistency, and why each of these are significant How thumbnails can represent the deciding moment your video's perspectives Tips on making the best thumbnail, to pull in a greater crowd Step by step instructions to pull in sponsors to your substance Advantages of Taking this Course: Finding out about the three general classifications of substance Figuring out how to figure out what sort of substance is ideal Understanding the job that site improvement plays in your prosperity Figuring out how to compose titles and depiction that assist your video with accomplishing a high pursuit positioning Seeing more about YouTube's promoter strategies

Undertaking Management Foundation (Small Projects) Certification Notwithstanding the significance of undertaking the executives, numerous working environments don't invest energy putting resources into limited scope project the board. More modest activities are then left without somebody in control, which just welcomes problem and disorder. Venture the executives guarantees that everything goes easily, including the turn of events and conveyance of the item to the customer. Powerful administration can likewise reduce expenses and forestall sat around by zeroing in on a definitive objective and finding a way ways to get it going. At the point when a group is left without initiative, things can before long get unfocused and confused. This course gives you a strong establishment in project the board, zeroing in on little ventures. We really expound on the overall advances you need to take, giving you significant data you can use to begin overseeing projects successfully. The course starts by talking about how to characterize and design the task. Then, we talk about the means you need to take to finish the undertaking, including how to keep the venture running great and on schedule. We additionally survey the significance of adaptability in project the executives. At long last, we let you realize how to buy programming programs that you can use to make project the executives a lot simpler. You will Learn: How little activities are diverse to huge scope ones The means engaged with viable little venture the executives The best an ideal opportunity to set your financial plan Step by step instructions to plan your undertaking The characteristics you need to learn for your undertaking to run easily Advantages of Taking this Course Figuring out how to make a reason proclamation and why this is significant Understanding the elements you need to consider when setting your degree Figuring out how to assemble a group that can be effective Understanding the significance of possibility time Figuring out how to track down the best undertaking the executives programming to assist with activities of this scale

Introduction to Kennel and Cattery Management Certification For an animal lover, there is no better way to earn a living than spending it with the critters you adore. This makes kennel and cattery management a very attractive career choice for so many across the UK. Having a solid understanding of both the business aspect of running a business as well as health and hygiene topics will give you the perfect start to your new career. Training in this area is something you can use throughout your life. This course tells you what you need to know about kennel and cattery management, dividing the information across two modules. The first reviews the business side of things, covering your role at the kennel or cattery and introducing you to the various types of facilities you may encounter. Our second module covers the animal health and hygiene topics you need to be familiar with in order to properly look after the animals in your care. You Will Learn: The specific tasks kennel and cattery managers are responsible for Information about commercial or boarding kennels or catteries The difference between a breeding kennel and a hobby kennel Information about the three main pieces of legislation you need to be familiar with How to comply with your local authority's record keeping requirements Benefits of Taking This Course: For those thinking about a career in animal care, learn more about what you can expect from management If you currently work with animals, gain additional skills and knowledge you can use to ask for a promotion or raise If you are a pet owner, learn more about how the kennels and catteries you bring your pets to are run Volunteers at kennels and catteries can learn more about accepting increased responsibilities If you are thinking about breeding cats or dogs, learn more about how to keep the animals safe and well cared for

Conveying Useful Feedback in a Corporate Setting Certification Giving input is needed at each level of the corporate chain. Each worker, from the individual who is at the most minimal evaluation to the CEO should give criticism to their staff or partners consistently. Realizing how to convey this criticism in a compelling and helpful manner is a fundamental piece of running, overseeing, administering or even working in an effective association. Realizing how to propel yourself as well as other people through criticism consistently prompts more prominent benefits, just as a more joyful and more beneficial working environment. This course expounds with respect to how to give criticism in a viable manner, guaranteeing that your endeavors are generally welcomed by those in your working environment. We start by discussing the benefit of offering input to the entirety of your staff individuals. We at that point proceed onward to discussing how you can fabricate an input rich corporate culture, paying little mind to what your association's set of experiences turns out to be. At last, we diagram the means that you should take, to convey viable input. You will Learn: The reasons why you should give your representatives input A comprehension of why both positive and negative input are vital to the effective activity of an association How much worth your representatives escape your legit input Instructions to build up an input rich culture in your association Instructions to convey input that will be generally welcomed, paying little heed to who your beneficiaries end up being Advantages of Taking this Course Figuring out how to convey criticism that will be generally welcomed and, consequently, followed up on Understanding the three fundamental reasons with regards to why criticism is vital to an association Learning the significant job that trust and security play in an association Realizing what the commendation sandwich is and how to utilize it to your advantage Understanding why you should be certain that the arrangement of input as the standard in your organization is the lone manner by which you can succeed

HTML and CSS Certification Level 1HTML5 is a useful web-programming language that allows you to create feature-rich apps that can run on a wide variety of devices. HTML5 combines the awesome power and flexibility of HTML4 along with multi-media rich features, and you are no longer at the mercy of Apple's iOS or Google's Android when you develop your own apps. In fact, after using HTML5, you can actually design your own app and promote it on the open web. It's easier to develop apps with HTML5 as the programming language provides flexible cross-platform compatibility.Important topics covered in the course include:The video course on HTML5 teaches beginners (who may have no prior knowledge of HTML) the programming basics and explains other features throughout subsequent videos. Some of the topics covered include: How to choose the correct text editor and browser for running HTML5 and how to open a new file and type in basic code The concept of tags and how to include website text between the correct tags and how to nest tags in the right manner How to preview your website as you develop it and using the correct syntax in code How to use basic CSS files and commands to help your website content look better How to create lists, links and tables and incorporate the instructions correctly in HTML5 code How to use form and input tags to accept information from the user Lab test exercises to test your skills after every video tutorial Benefits of studying the course: You can test your skills by doing the practice tests provided in the course Your knowledge of the basics can enable you to learn more advanced levels of HTML5 You can start developing your own apps by using HTML5 code without depending on Google and Apple Even those with zero programming knowledge can do this course and learn the terms and basics

Tackling Sensitive Workplace Conversations Certification An unpreventable and unavoidable piece of dealing with any working environment or driving any group is managing tough spots. Having delicate work environment discussions with anybody, paying little heed to their position or the motivation behind the discussion, isn't something that anybody anticipates. Lamentably, neglecting to have these basic discussions can misfire, prompting tense circumstances, rehashed botches and expanded work environment dramatization. Having discussions seeing delicate themes is similarly as imperative to keeping your work environment running easily as taking care of the bills and employing talented staff individuals. This course expounds on touchy work environment discussions, perceiving that they are so difficult to have and how upsetting they can cause you to feel heretofore. We start by examining four explicit issues that frequently emerge in working environments, alongside a couple of ideas on the most proficient method to begin these discussions. Then, we give you the data that you need, to enough plan for these discussions and clarify why you ought to never talk about a touchy point without planning. At long last, we examine the best areas in your office to have these sorts of discussions and clarify why you should zero in on security. You Will Learn: Data in regards to the four most basic delicate themes Tips on the most proficient method to propose these points, alongside models Why you need to plan for these discussions ahead of time Readiness tips and preventative guidance on the most proficient method to make these discussions more powerful Where you ought to have touchy discussions to guarantee protection Advantages of Taking this Course Figuring out how to viably deal with your staff with less pressure Learning the instruments that you need to deal with touchy discussions on all themes Understanding the significance of tuning in, while having these discussions Understanding the significance of timing, while having these discussions Realizing who you ought to circle back to after your delicate discussion

Why not book a 1-2-1 bespoke online session, where you and I can edit some of your images together via Zoom. Alternatively, we can edit some of my images and you can see and learn how I brings my images to life. I have 25 years of Editing skills that I'd love to share with you. You can let me know what you would like to get from our session and what editing software you would like to cover and get things rolling.  Online 1-2-1 Post Processing Tuition  I (Simon) started my editing career back in 2006 while travelling through Peru and picked up a copy of Adobe's Photoshop. The program was overwhelming. Today I can edit an image from start to finish in just minutes. That’s what I want to share with you. Simple, clear and powerful editing tips that work. Don't struggle alone. Book a session now and find out just how far we can take you. You'll be amazed how easy it can be with the right tuition. You can book a 1-2-1 online session for yourself or even purchase a voucher as a gift for a friend or family member. It makes a great and unusual gift. And, I promise they will love it!  Included  > 1-Hour Online Session *or multiples of (covering anything you would like to learn and understand. We will chat before your session so we can cover those topics) > Access to ongoing support and tutorage via our private Students facebook Group  Excluded  > Adobe CC Subscription > Lumenzia (This plugin is highly recommended if you would like to learn about luminosity masks - 2hr recommended) > Laptop and accessories (microphone is essential, A webcam is optional but a good idea)  Required  > Adobe CC Subscription and the software pre-installed on your computer. > Access to a working copy of Adobe Lightroom and Adobe Photoshop. (I recommend running the latest versions in order to get the most from our session)

Jumpstart your cleaning career with our online course! 🌟 From fundamentals to advanced business strategies, learn about cleaning techniques, equipment, and managing a successful cleaning business. Perfect for enhancing skills or launching your own venture. Enroll now to transform cleanliness into your success! ✨ #CleaningSkills #BusinessGrowth #OnlineCourse