8492 CLO courses

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

Level 3 & 4 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 5 CPD Courses | Lifetime Access

Course Overview outline updating. please contact us in the meantime to discuss your requirement. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes outline updating. please contact us in the meantime to discuss your requirement. Format F2F or Virtual Delivery Mode Closed Cohort or Occasional Limited Public Schedule Duration 1 Day Target Audience Business professionals, leaders & executives intending to drive and embed change.

Course Overview Effective use of technology in adaptive organisations is critical for innovation, collaboration and efficiency. By reflectively examining the patterns and pitfalls of technology usage, individuals can identify how they can best harness the latest tools and platforms to increase the quality and effectiveness of their effort. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Examine the current technology landscape -Identify bottlenecks and issues with current tools & processes -Collectively explore new tools and platforms -Prioritise & plan adoption of new technology Format F2F or Virtual Delivery Mode Closed Cohort Duration 4 Hrs Target Audience Business professionals, leaders & executives looking to drive innovation through creative use of technology in complex or ambiguous contexts.

Course Overview The adaptive communication course provides individuals with the ability to modify their communication style within volatile or ambiguous situations in order to effectively convey complex information and ideas. This involves understanding the perception and context of the audience and adapting language, tone, and delivery to drive evolving business outcomes. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Empathise with the perspectives and objectives of your audience -Apply active listening techniques -Adjust tone and language to suit the communication preference of your audience -Use assertive communication methods to deliver for impact Format F2F or Virtual Delivery Mode Closed Cohort Duration 4 Hrs Target Audience Business professionals, leaders & executives looking to effectively communicate in highly volatile or ambiguous environments.

Course Overview The adaptive leadership course focuses on helping leaders within organisations to navigate complex and uncertain situations, often involving significant change, by effectively applying and mobilising the disciplines, competencies and skills within the Adaptive Organisation Framework. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Explain the current organizational challenges that require adaptability -Describe the core disciplines, competencies and skills of the adaptive organization framework -Identify the relative strengths and weaknesses of their team in terms of adaptability -Build a roadmap to uplift adaptability within a department or team Format F2F or Virtual Delivery Mode Closed Cohort Duration 4 Hrs Target Audience Leaders & executives aiming to uplift adaptability as a capability within their departments or teams.

Course Overview The course is aimed at helping individuals become more proactive and confident in taking necessary actions towards achieving a goal or solving complex or ambiguous problems as opposed to reacting to events. It helps participants manage risk and the fear of failure. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Define what initiative is and why it is essential -Identify an opportunity or issue -Apply flexible decision-making techniques -Weigh up the risks and consequences -Articulate the value of an idea Format F2F or Virtual Delivery Mode Closed Cohort or Occasional Limited Public Schedule Duration 4 Hrs Target Audience Business professionals, leaders & executives aiming to increase their initiative in times of uncertainty, ambiguity or complexity.

Course Overview Organisational adaptability is most likely to be achieved and ingrained into culture when it is effected at an individual level. This course provides a neuroscience-informed framework for individuals to develop mindset, skills, and habits that prefigure adaptability in response to changing business requirements and environment. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Explain the current organizational challenges that require adaptability -Identify strategies to personally manage adversity -Use outward thinking approaches to explore opportunities -Apply proactive and collaborative methods to embrace and manage change Format F2F or Virtual Delivery Mode Closed Cohort or Occasional Limited Public Schedule Duration 4 Hrs Target Audience Business professionals, leaders & executives aiming to enhance their own adaptability to complex or ambiguous contexts.

Course Overview Organisational skills refer to the ability to effectively plan, organize, and manage one's time, tasks, and resources in order to achieve specific goals. We introduce a post-agile approach that leverages the benefits of the agile methodology whilst addressing its limitations. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Analyse current habits and routines -Prioritise time schedule and daily tasks -Optimise communications to increase focus and productivity -Use effective planning tools to regularly plan and prioritise tasks and projects Format F2F or Virtual Delivery Mode Closed Cohort or Occasional Limited Public Schedule Duration 4 Hrs Target Audience Business professionals, leaders & executives aiming to enhance their personal effectiveness by developing their self organisational skills

Course Overview This course will provide individuals with a process for analysing and evaluating new information, ideas, or situations in a logical and objective manner in order to form judgements, make decisions, and solve problems, centred around evolving business outcomes. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Define what critical thinking is and why it is essential -Examine biases and logical fallacies that interfere with decision-making -Identify emotional versus rational thinking methods -Apply structured decision-making processes to arrive at logical conclusions Format F2F or Virtual Delivery Mode Closed Cohort Duration 4 Hrs Target Audience Business professionals, leaders & executives aiming to sharpen their critical thinking skills in complex or ambiguous contexts.