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

38582 Courses in Cardiff delivered Online

Week 51 - How To Start Your Acting Career Without An Agent

By DontGoToDramaSchool

DontGoToDramaSchool - Teaching you the screen-acting techniques of the Hollywood stars. "Making quality, industry relevant drama training accessible to all." Don't waste your time and money going to traditional drama school. We teach you screen-acting not stage, at a time when streaming content is booming while theatres are being demolished. And costing a fraction of the price of traditional drama schools, start your training today. Don't wait for term time to begin.

Week 51 - How To Start Your Acting Career Without An Agent
Delivered Online On Demand
£9.99

Financial Investigator Complete Bundle - QLS Endorsed

By Imperial Academy

10 QLS Endorsed Courses for Financial Investigator | 10 Endorsed Certificates Included | Life Time Access

Financial Investigator Complete Bundle - QLS Endorsed
Delivered Online On Demand
£599

Computer Programmer QLS Endorsed Courses

By Imperial Academy

Computer Programming: Where Inspiration Meets Logic And Dreams Become Lines Of Code

Computer Programmer QLS Endorsed Courses
Delivered Online On Demand
£599

Counselling Complete Bundle - QLS Endorsed

By Imperial Academy

10 QLS Endorsed Courses for Counselling Complete | 10 Endorsed Certificates Included | Life Time Access

Counselling Complete Bundle - QLS Endorsed
Delivered Online On Demand
£599

Nursing Assistant Complete Bundle - QLS Endorsed

By Imperial Academy

10 QLS Endorsed Courses for Nursing Assistant | 10 Endorsed Certificates Included | Lifetime Access

Nursing Assistant Complete Bundle - QLS Endorsed
Delivered Online On Demand
£599

Estate Manager - QLS Endorsed Bundle

By Imperial Academy

10 QLS Endorsed Courses for Estate Manager | 10 QLS Endorsed Certificates Included | Life Time Access

Estate Manager - QLS Endorsed Bundle
Delivered Online On Demand
£550

OTHM Level 4 Diploma in Information Technology

By School of Business and Technology London

Getting Started OTHM Level 4 Diploma in Information Technology gives an overview of how the information technology sector can influence the scope of the learning environment in the present scenario. This course helps learners learn about the role of Information technology in business communication. The qualification helps the learner to understand the role of IT in productivity and profitability in high levels of business operations. Key Benefits The qualification will benefit learners to: To understand the role of IT in productivity and profitability in high levels of business operations. To attain the practical knowledge, skills, capabilities and competencies assessed in academic terms as equivalent to Higher National Certificates (HNC) and Year 1 of a three-year UK Bachelor's degree programme. To learn the fundamentals of cyber security, protection methods and how to manage a cyber-security attack. To attain a basic understanding of object-oriented programming languages and how to produce effective code. To gain a perspective on software development and the basic principles of algorithms. To create awareness of system analysis and design in an organisational context. To provide learners with an understanding of current web and mobile application design technology and the practices and tools used. To understand computer networking essentials and cloud technologies, their operating principles, protocols, standards, security considerations, and prototypes associated with this field. To understand the interaction between communications, knowledge and information. Completing the OTHM Level 4 Diploma in Information Technology provides learners with the opportunity for various academic progressions, including the OTHM Level 5 Diploma in Information Technology. Ofqual (Office of the Qualifications and Examinations Regulation) approves and regulates the qualification.   Key Highlights Do you want to avoid the recent technological know-how of Information Technology in Business Communication? Then, the OTHM Level 4 Diploma in Information Technology is the ideal starting point for your career journey. The program allows the learners to develop a broad base of knowledge and skills that will enable them to work in various roles in the IT industry. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our OTHM-approved tutors, who would be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The OTHM Level 4 Diploma in Information Technology can open many career pathways including, but not limited to: Application Analyst with an estimated average salary of £36,015 per annum Database Administrator, with an estimated average salary of £38,246 per annum Games Developer with an estimated average salary of £28,905 per annum Information Systems Manager, with an estimated average salary of £44,785 per annum IT Consultant with an estimated average salary of £37,485 per annum Systems Analyst, with an estimated average salary of £37,500 per annum Web Designer with an estimated average salary of £29,235 per annum About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. What is included? Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules Multiplatform accessibility through an online learning platform. This facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only). Assessment Time-constrained scenario-based assignments. No examinations. Entry Requirements Learners must be 18 years old or older. Relevant NQF/QCF/RQF Level 3 Diploma or equivalent. International students whose first language is not English must score 5.5 or above in the IELTS Examination or equivalent. Progression Learners completing the OTHM Level 4 Diploma in Information Technology will allow progress to: OTHM Level 5 Diploma in Information Technology. Why gain a OTHM Qualification? Industry-focused programmes which meet global standards. Programs reviewed by highly qualified experts in the relevant sector. Career enhancement through advanced knowledge and skills that meet 21st-century employer needs. Availability of globally approved centres for enrolling in the desired program. Availability of flexible study options. The OTHM Level 4 Diploma in Information Technology consists of 6 mandatory units for a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 480 Guided Learning Hours (GLH) for the completed qualification Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Programming Foundations Reference No : A/617/2265 Credit : 20 || TQT : 200 Unit I entitles basic understanding of Object-oriented programming languages and how to produce effective code. Unit I also helps the non-programming technical staff to gain an idea about software development. The course is language neutral and teaches general concepts. UNIT2- System Analysis and Design Reference No : F/617/2266 Credit : 20 || TQT : 200 Unit II focuses on developing learners' awareness of analysis and design in an organisational context. The unit also contains various techniques used within systems analysis and design and the methodologies used in the system development process. UNIT3- Web and Multimedia Applications Reference No : J/617/2267 Credit : 20 || TQT : 200 The unit aims to provide learners with an understanding of current design technology and the practices and tools used. The learner will develop the ability to create new websites and will gain advance skills in web development. UNIT4- Computer and Network Technology Reference No : L/617/2268 Credit : 20 || TQT : 200 The Unit enables the learners with knowledge of computer networking essentials, how they operate, protocols, standards, security considerations and the prototypes associated with a range of networking technologies. Learners will also explore a range of hardware and related software and will learn to configure and install these UNIT5- Software Development Reference No : R/617/2269 Credit : 20 || TQT : 200 Unit V introduces the learners about the fundamental concepts of programming by focusing on software development process. It also briefs about the tools that assist in this process. Learners are given the choice to use a programming language of their choice. UNIT6- Managing Business Information Reference No : J/617/2270 Credit : 20 || TQT : 200 Unit covers the influence of IT system in keeping a company up to date with communication and knowledge. Learners will understand the interaction between communications, knowledge and information. It also briefs how IT systems can be used as a management tool for collecting, storing, disseminating and providing access to knowledge and information. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

OTHM Level 4 Diploma in Information Technology
Delivered Online On Demand11 months
£843.45

CV Writing and Interview Tricks

4.8(9)

By Skill Up

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

CV Writing and Interview Tricks
Delivered Online On Demand51 minutes
£25

OTHM Level 6 Diploma in Accounting and Business

By School of Business and Technology London

Getting Started Accounting and finance play a crucial role in various businesses, ranging from large corporations to small companies. Many business managers are involved in accounting functions, even though they may not have formal managerial training. In today's complex business environment, there is a high demand for professionals who can work collaboratively across organizational boundaries and with diverse teams. The OTHM Level 6 Diploma in Accounting and Business is designed to provide learners with the necessary knowledge and skills to take on middle or senior managerial positions within an organization. This encompasses responsibilities such as overseeing financial matters, managing investments, risk management, conducting audits and assurance, and engaging in research. Key Benefits Gain an understanding of financial management principles. Acquire the skills to identify, assess, and mitigate various business risks. Develop and implement strategic financial plans that align with the organization's goals. Enhance managerial skills. Cultivate the ability to collaborate effectively within diverse, cross-functional teams.   Key Highlights If you're a practicing or aspiring financial manager looking to advance your career, then the Level 6 Diploma in Accounting and Business is the perfect starting point for your career development. We will ensure your access to first-class education needed to achieve your goals and dreams and to maximize future opportunities. Remember, the assessment for the qualification is based on assignments only, so you do not need to worry about taking any exams. With the School of Business and Technology London, you can complete the qualification at your own pace by choosing between online or blended learning from the comfort of your home. Learning materials, pathway materials, and study guides developed by our qualified tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide you with comprehensive tutor support through our dedicated support desk. If you opt for blended learning, you will also have the opportunity to enjoy live sessions with an assigned tutor, which you can book at your convenience. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. What is included? Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment Internally assessed by the center and externally verified by OTHM. Assignment-based assessment. No exams. Entry Requirements Relevant NQF/QCF/RQF Level 5 diploma or an equivalent recognized qualification. Learners over 21 years with management experience. Learners must be 18 years or older at the beginning of the course. English requirements: Must provide evidence of English language competency for learners from non-English-speaking countries.   Progression Relevant OTHM diploma qualifications at Level 7. This qualification is approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation). Therefore, learners are also eligible to pursue higher-level qualifications in their field. Why gain a OTHM Qualification? Quality, Standards and Recognitions- OTHM qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation); hence, the learners can be very confident about the quality of the qualifications as well. Career Development to increase credibility with employers- All OTHM qualifications are developed to equip learners with the skills and knowledge every employer seeks. The learners pursuing an OTHM qualification will obtain an opportunity to enhance their knowledge and grow key competencies to tackle situations and work on projects more effectively, which will, in turn, give learners the potential to get promotions within the workplace. Alternatively, it allows them to progress onto an MBA top-up/Bachelor's degree / Master's degree programme around the World. Flexible study options- All OTHM qualifications have a credit value, which tells you how many credits are awarded when a unit is completed. The credit value will indicate how long it will normally take you to prepare for a unit or qualification. Three different types of qualification are: The award is achieved with 1 - 12 credits The certificate is completed with 13 - 36 credits The diploma is completed with at least 37 credits Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- 1. Corporate and Business Law Reference No : L/617/4375 Credit : 20 || TQT : 200 The goal of this unit is to enhance learners' understanding of the fundamental principles of English Corporate and Business Law. This unit will enable learners to apply these concepts and principles in practical, real-life situations. UNIT2- 2. Business Performance Measurement Reference No : R/617/4376 Credit : 20 || TQT : 200 The primary objective of this unit is to foster a comprehensive understanding of performance management techniques in learners. They will have the opportunity to evaluate the systems used in both profit-driven and non-profit entities. Furthermore, learners will gain practical proficiency in reporting performance metrics and utilizing specialized cost and management accounting methods. UNIT3- 3. Financial Securities Markets Reference No : Y/617/4377 Credit : 20 || TQT : 200 The aim of this unit is to nurture learners' comprehension of investment theories, securities, and market analysis. Learners will also gain insight into the important laws and regulations that influence the financial services industry. UNIT4- 4. Audit and Assurance Reference No : D/617/4378 Credit : 20 || TQT : 200 The objective of this unit is to enhance learners' understanding of principles related to both internal and external auditing. Learners will examine the existing legal and professional mandates and assess the risks associated with the external auditing process. UNIT5- 5. Business Research Project Reference No : K/616/2735 Credit : 20 || TQT : 200 The purpose of this unit is to cultivate learners' research skills, which include formulating research questions, conducting independent research using appropriate methods, evaluating the research methodology employed, and effectively communicating their research findings. UNIT6- 6. Investment and Risk Management Reference No : H/617/4379 Credit : 20 || TQT : 200 The aim of this unit is to provide learners with an understanding of different trading and investment techniques and how they can be practically applied. In this unit, learners will also assess the risks associated with market trading and investment and examine strategies for risk reduction. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

OTHM Level 6 Diploma in Accounting and Business
Delivered Online On Demand11 months
£908.64

Microsoft Excel Advanced - In-company

By Microsoft Office Training

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

Microsoft Excel Advanced - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650