25711 Management courses in Formby delivered Online

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Why Join Digital Marketing Training Course at Osborne Training Osborne Training is well Recognised for quality Regular Lectures led by Industry Expert Tutors Unlimited Access to the State of the Art Virtual Learning Campus Exclusive Access to High quality study materials Flexible payment option available Join Digital Marketing Training course as Pure Online or Blended with Classroom Delivery Access to Digital Marketing Internship for 3 months at the end of the training Unlimited Tutorial Support from expert tutors Get a Student Discount Card from NUS* Get a Free Tablet PC for limited period* Practical Hands-on Projects, Practical focused Assignments and Group-work for greater skills enhancement and understanding real life issues for real life problems Once you complete the bookkeeping course, you will get a certificate from Osborne Training confirming your professional Digital Marketing Qualifications. What jobs could I qualify for? Senior Digital Marketing Manager Digital Marketing Coordinator Executive Digital Marketing Strategist Digital Marketing Consultant In these roles, you could earn on average more than £40,000 annually (source: Reed Salary Checker, UK). Moreover, many go on to become successful (Millionaire sometime) entrepreneur by offering Digital Marketing services or formulating successful Digital Marketing Strategy for their own business. Digital Marketing Qualifications Digital Marketing Qualifications at Osborne Training are developed in Association with Google. Osborne Training offers Total Digital Marketing Course which combines all major skills required to be a successful Digital Marketeer and you also have option to join a complementary Internship at the end of your course. In joining the Total Digital Marketing Course at Osborne Training, you will make one of the greatest decision of your career and can look forward to a successful career in digital marketing. Digital Marketing Course Overview Total Digital Marketing Course covers major areas of Digital Marketing to make you completely ready for the digital era. The Digital Marketing course comes with optional Internship at the end of the training making you highly employable. Practical focused and hands-on approach of the training method helps you to be ready to offer real life solutions for real life problems. Digital Marketing Training Course Content Basics of marketing Marketing In Digital Era All About Web Search Engine Optimization Search Engine Marketing Affiliate Marketing Social Media Marketing Email marketing and nurturing (inbound) Mobile app marketing Content marketing Web, mobile and app analytics Growth Hacking Creating robust digital marketing strategy

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

Advanced Microsoft Excel Training Course on Bookkeeping Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Catch up with Dr Katie Lihou (University of Bristol), Phillipa Page (NADIS) and Matt Colston (ELANCO) for discussions around blowfly control. A review of the blowfly life cycle along with preventative management strategies and appropriate chemical use was discussed by Matt from ELANCO. Phillipa described effective treatments of clinically affected sheep to minimise compromised sheep welfare. Dr Lihou discussed the costs associated with prevention and treatment of clinical cases of blowfly using cost/benefit analysis modelling. The webinar was a useful refresher ahead of the blow fly season to ensure that knowledge is up to date for improved client and customer engagement. This event concluded with a Q&A session. This webinar, aimed at Vets, SQPS and farmers, was hosted by NADIS in association with Elanco. Dr Katie L Lihou, PhD, BSc Katie completed her PhD at the University of Bristol on the prevalence and distribution of livestock ectoparasites in the UK, in the department of Veterinary Parasitology and Ecology. Before her PhD, she studied 3 years of Veterinary Medicine, before moving into Biology. Katie is now a post-doctoral researcher working in the Bristol Vaccine Centre on infectious disease epidemiology and modelling. Phillipa Page, BVSc BSc MRCVS Phillipa qualified from Liverpool Vet School in 2006 and started her first job in Neath, South Wales in a mixed practice. Following a short time as a locum dairy vet in Devon she then joined Wood Vet group in 2009 as a large animal vet. Her work was predominantly dairy but she had a special interest in sheep and developed the sheep side of the practice. In 2016 she then moved to specialize in sheep veterinary work with Flock Health Ltd. This involves a mixture of consultancy flock health work, farmer and vet CPD training and collaboration with retailers, processors and pharmaceutical companies and industry levy bodies. Phillipa was part of the co design groups for the DEFRA Animal Health and Welfare Pathway and Endemics disease program. Phillipa also works with NADIS (National Animal Disease Information Service) as the sheep lead on the Blowfly, parasite control, online health planning and disease alerts information. She has been a board member on the British Cattle Veterinary Association and the Sheep Veterinary Society and is the current conference organiser for the Sheep Veterinary Society and the current Junior Vice President. Phillipa co authored and published a book ‘Sheep Keeping’ as part of the professional small holders series by 5M Publishing and the chapter ‘Lameness’ in Differential Diagnosis in Sheep. 2022 Herriot Publications. She is involved with research and works on regular contributions to publications and is currently working towards a Diploma of the European College of Small Ruminant Health and Production. Outside of work she is a tenant farmer of 100 acres. Together with her husband and two boys she farms a flock of 300 commercial ewes and has a farm shop. Matt Colston, BVM & S, CertSHP, MRCVS Matt graduated from the R(D)SVS in Edinburgh in 1986. He then spent five years working in a mixed practice in Fife and the Borders before taking up a two-year demonstrator’s position (shared between R(D)SVS and SAC (Edinburgh Genetics), concentrating on equine reproduction and artificial breeding in small ruminants. He later obtained the Cert.SHP qualification before returning to general practice in Penrith, where he has worked since 1997. In November 2013, Matt joined Novartis Animal Health as a Veterinary Technical Advisor for the Farm Animal Team. When Novartis was acquired by Elanco, he continued in this role with the company. Also, Matt currently serves as the Chairman of Moredun Foundation's North of England Regional Board.

Catch up with Dr John Graham Brown (University of Liverpool), Phillipa Page (NADIS) and Matt Colston (ELANCO) on their discussion around liver fluke control in sheep. Dr Graham Brown works with NADIS and SCOPS to calculate and predict the parasite and fluke forecast for the year ahead. He discusses the risks posed for this year and specific farm risks to consider for your farm. Matt and Phillipa discuss testing, management and treatment options for effective control on your farm. This event concluded with a Q&A session. This webinar was hosted by NADIS in association with Elanco. Dr John Graham-Brown, BVSc, MSc, PhD, MRCVS John graduated from the University of Liverpool in 2010. As part of his studies, he also completed a master’s degree in Veterinary Parasitology. Having spent some time in mixed practice in Wales, John returned to Liverpool in 2012 to complete a PhD investigating liver fluke infection in cattle under the supervision of Professor Diana Williams. Since 2016, John has been working as a researcher and lecturer at the university investigating a range of parasitic diseases of livestock and domestic animals in the UK and abroad. John is also currently collaborating with the national animal disease information service (NADIS) to develop and produce their monthly parasite forecasts. Phillipa Page, BVSc BSc MRCVS  Phillipa qualified from Liverpool Vet School in 2006 and started her first job in Neath, South Wales in a mixed practice. Following a short time as a locum dairy vet in Devon she then joined Wood Vet group in 2009 as a large animal vet. Her work was predominantly dairy but she had a special interest in sheep and developed the sheep side of the practice. In 2016 she then moved to specialize in sheep veterinary work with Flock Health Ltd. This involves a mixture of consultancy flock health work, farmer and vet CPD training and collaboration with retailers, processors and pharmaceutical companies and industry levy bodies. Phillipa was part of the co design groups for the DEFRA Animal Health and Welfare Pathway and Endemics disease program. Phillipa also works with NADIS (National Animal Disease Information Service) as the sheep lead on the Blowfly, parasite control, online health planning and disease alerts information. She has been a board member on the British Cattle Veterinary Association and the Sheep Veterinary Society and is the current conference organiser for the Sheep Veterinary Society and the current Junior Vice President. Phillipa co authored and published a book ‘Sheep Keeping’ as part of the professional small holders series by 5M Publishing and the chapter ‘Lameness’ in Differential Diagnosis in Sheep. 2022 Herriot Publications. She is involved with research and works on regular contributions to publications and is currently working towards a Diploma of the European College of Small Ruminant Health and Production. Outside of work she is a tenant farmer of 100 acres. Together with her husband and two boys she farms a flock of 300 commercial ewes and has a farm shop. Matt Colston, BM & S, CertSHP, MRCVS Matt graduated from the R(D)SVS in Edinburgh in 1986. He then spent five years working in a mixed practice in Fife and the Borders before taking up a two-year demonstrator’s position (shared between R(D)SVS and SAC (Edinburgh Genetics), concentrating on equine reproduction and artificial breeding in small ruminants. He later obtained the Cert.SHP qualification before returning to general practice in Penrith, where he has worked since 1997. In November 2013, Matt joined Novartis Animal Health as a Veterinary Technical Advisor for the Farm Animal Team. When Novartis was acquired by Elanco, he continued in this role with the company. Also, Matt currently serves as the Chairman of Moredun Foundation's North of England Regional Board.

Elite EA/PA Forum We are delighted to announce that the Elite EA/PA Forum for Australia & New Zealand will be on the 25th of September 2025. Our workshop aims to: Enhance your influence and impact by mastering assertive communication, negotiation, and self-advocacy skills. Stay composed and solution-focused in high-pressure situations with practical tools for crisis management and clear decision-making. Embrace evolving technology by understanding how AI and automation can streamline your role and boost efficiency. Future-proof your career by building strategic value, resilience, and adaptability in an ever-changing professional landscape. Keynote Address with Q&A from the audience: What to expect from Sam's Keynote: With over 30 years supporting leaders at the highest levels, Sam Cohen brings a wealth of insight, experience, and stories (the kind she can share) to the stage. From 18 years serving within The Royal Household - including as Deputy Private Secretary and Press Secretary to Her late Majesty Queen Elizabeth II - to working with The Duke and Duchess of Sussex, running the Prime Minister’s Office at Downing Street, and serving as Chief of Staff to the global CEO of Rio Tinto, Sam’s career is a masterclass in discretion, diplomacy, and delivering at the top. In this exclusive keynote, Beyond the Role, Sam will explore how Executive Assistants don’t just support leaders - they shape leadership, drive strategy, and build legacy from behind the scenes. Join us for this rare opportunity to hear from someone who’s been at the epicentre of power - and bring your questions! The keynote will include a live Q&A, where you can ask Sam about her remarkable career, leadership insights, and how to truly excel in high-performance environments. (Don’t ask her what the Queen kept in her handbag - she’s not telling.) Sam Cohen Career Bio: Sam Cohen has spent the last 30 years working to support leaders in the public and private sectors. Sam spent 18 years serving The Royal Household, as Deputy Private Secretary to Her late Majesty Queen Elizabeth II and Press Secretary to The Queen. Sam also served as Private Secretary to The Duke and Duchess of Sussex. Following this time, Sam worked as Director of the Prime Minister’s Office at Downing Street under Boris Johnson and, most recently, was Chief of Staff to the global CEO at Rio Tinto. Source: ABC News - YouTube Channel. Facilitator - AM: The Future-Proofed Assistant: Speak Up, Stand Out & Shape Your Career Path How to reimagine your Assistant role in 2025 and beyond - How the EA role is evolving (and what Executives now expect) & why Assistants who think like strategists will be indispensable Assertiveness as an Assistant – The key to retaining your role & the difference between being ‘helpful’ and being ‘heard’ Self-Advocacy as a Career Growth Strategy – The importance of advocating for your career development, workload boundaries and recognition Own Your Professional Future - Map your career development. Whether you're an EA for life or looking to a role beyond in the future, this is for you. Ruth Kilah Career Bio: Ruth is an international executive career coach and founder of Hoxton Hyde – Executive Career Coaching & Mentoring, delivering 1:1 and group programs for experienced Executive Assistants. She specialises in helping EAs step into higher-level roles, increase their income, and expand their professional impact. With 14 years’ experience supporting C-suite executives in Australia and the UK, Ruth brings deep industry insight and a strategic approach to career development. She empowers Assistants to gain clarity on their next move, adopt a strategic mindset, communicate their value effectively, and lead their own growth conversations with confidence. A former EA turned Stakeholder Relations and Project Manager, Ruth launched Hoxton Hyde in 2018 after spotting a clear gap in the market for tailored coaching for career-driven EAs. She is a recognised member of the World Administrators Alliance and a respected thought leader in the EA space, regularly sharing insights via LinkedIn and Instagram. Ruth is also a certified fitness and wellness coach, passionate about helping Assistants achieve long-term career fulfilment through intentional development and well-being. Panel: Crisis Mode: What to do when everything goes wrong Master a step-by-step approach to prioritising and problem-solving under pressure. Strengthen emotional resilience and calm decision-making during unexpected disruptions. Learn how to communicate clearly and lead from behind in high-stress situations. Emma-Kate Bos Bio Emma-Kate works alongside the CEO at Squadron Energy, one of Australia’s leading renewable energy companies. With over 28 years of experience in Executive Assistant and Operational roles supporting business leaders in professional services, politics, membership industries, sporting and not-for-profit organisations, Emma-Kate has a deep understanding of business support roles and has managed large teams of assistants and receptionists. She is passionate about developing and mentoring team members Emma-Kate holds an Associate Degree in Law, Mini MBA and Certificate in Public Relations. Sepi Nowlands Sepi has also worked as an EO for Deloitte and spent 18 years previously as an Executive Assistant at the ATO, Law Council of Australia, Grains Research and Development Corporation and Air Services Australia. Holly Clareburt Hollie Clareburt is an experienced Executive Assistant, currently supporting the Managing Director of Microsoft New Zealand and the Chief Partner Officer. Known for her professionalism and discretion, she excels in providing high-level support in fast-paced, executive environments. Prior to Microsoft, Hollie was Executive Assistant to the Chief of Corporate & Enterprise Systems at BECA, and previously supported the CEO at SKY News New Zealand. Her career reflects a strong track record of reliability, organisation, and executive partnership. Facilitator - PM: Justin Kabbani AI & Automation: How Technology is Changing the Assistant’s Role Understand the latest AI tools reshaping administrative and operational support. Identify which tasks can be streamlined or delegated using automation. Reframe your role by leveraging technology to add strategic value and stay future-ready. Who will attend this event? Executive Assistant (EA) Personal Assistant (PA) Virtual Assistant (VA) Legal Secretary Legal Executive Assistant Administrative Assistant Office Manager Health Care Office Manager Chief of Staff Additional roles may be relevant depending on role responsibilities, along with development opportunities. This workshop is open to females, male including trans women/males and non-binary professionals. Group Rate Discounts: To discuss our group rates in more detail, please email support@elite-forums.com and provide the following: Group Number (How many would like to attend) Event Date (If numerous dates, please advise if we are splitting attendees across multiple dates) Attendee Contact details (Or request our Group Rate Document. Complete and return - we'll sort the rest.) Group discounts are on request - see below group rate discount brackets: 🧩 You just need one piece to come together - to unlock your Elite Potential. 🔑