396 Courses in Belfast delivered Live Online

Getting Started An MBA is a significant milestone for senior managers and aspiring directors, as it combines essential theoretical knowledge with practical skills needed to lead teams and achieve tangible results effectively. Typically pursued after gaining several years of professional experience, an MBA offers numerous benefits, such as enhanced career prospects, a high professional reputation, and an expanded business network. The programme provides access to a global network, a diverse student community, promising career opportunities, and a rigorous academic curriculum. The MBA Advanced Entry route is tailored for individuals with relevant hands-on management experience, a recognised Postgraduate Diploma (PgD) in management, or a comparable qualification. The programme is designed for individuals aspiring to advance their careers in senior management.  The programme comprises two phases; the first is the Level 7 Diploma in Strategic Management and Leadership, awarded by OTHM and delivered by the School of Business and Technology London. The second phase is the MBA Advanced Entry, delivered by the London Graduate School and awarded by the University of Buckingham. School of Business and Technology London partners with the London Graduate School to promote this programme. Throughout the programme, students receive support from the academic team, including a dedicated supervisor to guide them through the Consultancy Project Report module. Once the diploma phase is completed, the MBA Advanced Entry route typically takes 6 to 9 months. Upon successful completion, students are awarded the degree of Master of Business Administration from the University of Buckingham. They also have the option to attend the graduation ceremony held in the UK, commemorating their achievements. The programme aims to provide students with comprehensive support and valuable opportunities for personal and professional growth, ensuring they make the most of their investment in their future. About Awarding Body Buckingham is unique. It is the only independent University in the UK with a Royal Charter and probably the smallest, with around 2,700 students (approx 1,600 on campus). The University campus is well known for being one of the most attractive locations in the region. The Great Ouse River, home to much wildlife, winds through the heart of campus. Each student mixes with over 100 other different nationalities, so being at Buckingham is just like being in a mini global village. These contacts, acquaintances and friendships carry on long after life at Buckingham is over. Ranked Top 10 for Student Satisfaction Ranked Top 10 for Graduate Prospect Recognised by World Education Services (WES) OTHM Qualifications are approved and regulated by Ofqual (Office of Qualifications and Examinations Regulation) and recognised by Qualifications Wales. OTHM qualifications have achieved a reputation for maintaining significant skills in various job roles and industries like Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. OTHM serves the progression option with several UK universities that acknowledges the ability of learners after studying Level 3-7 qualifications to be considered for advanced entry into corresponding degree year/top-up and Master's/top-up programmes. Regulated by ofqual.gov.uk Recognised by World Education Services (WES) Assessment Assignments and Projects No Examinations Entry Requirements To be eligible for the MBA , you must meet the following criteria: A Bachelor's degree or an equivalent higher qualification. Submission of a copy of your valid photo ID to verify your identity. A Statement of Purpose outlining your motivations, career aspirations, and reasons for pursuing the MBA. An updated Curriculum Vitae (CV) demonstrating a minimum of two years of work experience at the graduate level, either in a managerial or professional capacity. By meeting these application requirements, you will take the initial steps towards joining the MBA programme, enabling you to enhance your managerial and leadership skills significantly. English Requirements A pass in English at the A level. Completion of a Bachelor's degree programme conducted and assessed in English. An overall score of 6.5 or higher in the International English Language Testing System (IELTS) with a minimum score of 6.0 in each component. A Test of English as a Foreign Language (TOEFL) score of 72 or higher, with a minimum of 18 in reading, 17 in listening, 20 in speaking, and 17 in writing. This includes scores from the Home Edition of TOEFL. In addition to the requirements above, all applicants must participate in a live virtual interview with a staff member from the London Graduate School. Progression An MBA graduate can pursue a fruitful career in many industries. MBA can open career opportunities in various sectors such as banking and financial services, investment banking, management consulting, insurance, hospitality, media, information technology (IT) and marketing. An MBA is often a pathway to promotion or a career change as you will gain a professional reputation and develop essential skills in the sector you choose to pursue. 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. Structure Phase 1 - OTHM Level 7 Diploma in Strategic Management and Leadership Programme Structure Strategic Management Unit Reference Number : A/616/2724 TQT : 200 Credit : 20 This unit aims to enhance learners' grasp of strategic and change management models. It also focuses on their capacity to evaluate strategic plans, suggest alternatives, formulate implementation strategies, and guide organizational transformations. Strategic Leadership Unit Reference Number : R/617/5012 TQT : 200 Credit : 20 This unit offers a comprehensive grasp of leadership principles and practices. It empowers individuals with the necessary knowledge, skills, and attributes to excel as an effective team player and leader. It encourages proactivity in driving innovation and improvement to shape organizational strategy and business planning. Strategic Human Resource Management Unit Reference Number : F/616/2725 TQT : 200 Credit : 20 This unit aims to foster learners' comprehension of how adept strategic management of human resources aligns with achieving organizational objectives in diverse contexts. Learners will assess the impact of strategic human resource management and the implementation of leadership and management theories for organizational advancement. Advanced Business Research Methods Unit Reference Number : J/616/2726 TQT : 200 Credit : 20 This unit seeks to cultivate learners' proficiency in crafting research proposals for various types of academically oriented management research. It fosters a critical understanding of the philosophical, practical, and ethical dimensions of study within the business environment. Strategic Financial Management Unit Reference Number : L/616/2727 TQT : 200 Credit : 20 This unit aims to empower learners with the practical application of financial principles in organizational management. It encompasses the utilization of analytical techniques, theories, and models of management accounting. Additionally, it involves evaluating budgetary processes, suggesting funding sources, and assessing investment alternatives. Supply Chain and Operations Management Unit Reference Number : R/616/2728 TQT : 200 Credit : 20 This unit aims to cultivate learners' comprehension of effective supply chain and operations management in competitive markets. This will be achieved by analysing case studies and real-world industry scenarios. Learners will gain insight into operational processes, techniques, and planning and control systems.   Phase 2 - MBA Advanced Entry Programme Structure Research Methods Consultancy Project Report Delivery Methods The programme comprises two phases; the first is the Level 7 Diploma in Strategic Management and Leadership awarded by OTHM and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The programme is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the MBA Advanced Entry delivered by London Graduate School, awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. 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.

Getting Started The programme's primary objective is to deliver practical and realistic solutions to business-related strategic challenges backed by appropriate references to theoretical and conceptual analysis. Globalisation means that effective and fair management of people is more vital than ever. In a turbulent, rapidly changing business environment, the demand for HR professionals who can strategically manage and develop staff potential - whilst overcoming issues such as redundancy, flexible working and the recent challenges of furloughed staff and social distancing - has never been more fundamental to business success. The programme meets the career enhancement needs of human resource (HR) managers, advisers, and administrators. The programme comprises two phases; the first is the Level 7 Diploma in Human Resource Management, awarded by OTHM and delivered by the School of Business and Technology London. The second phase is the MA in Human Resource Management (Advanced Entry), delivered by the London Graduate School and awarded by the University of Buckingham. School of Business and Technology London partners with LGS to promote this programme. Upon completing the programme, students are awarded an MA in Human Resource Management from the University of Buckingham. Additionally, students can attend the graduation ceremony held in the UK, celebrating their achievements. About Awarding Body Buckingham is unique. It is the only independent University in the UK with a Royal Charter and probably the smallest, with around 2,700 students (approx 1,600 on campus). The University campus is well known for being one of the most attractive locations in the region. The Great Ouse River, home to much wildlife, winds through the heart of campus. Each student mixes with over 100 other different nationalities, so being at Buckingham is just like being in a mini global village. These contacts, acquaintances and friendships carry on long after life at Buckingham is over. Ranked Top 10 for Student Satisfaction Ranked Top 10 for Graduate Prospect Recognised by World Education Services (WES) OTHM Qualifications are approved and regulated by Ofqual (Office of Qualifications and Examinations Regulation) and recognised by Qualifications Wales. OTHM qualifications have achieved a reputation for maintaining significant skills in various job roles and industries like Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. OTHM serves the progression option with several UK universities that acknowledges the ability of learners after studying Level 3-7 qualifications to be considered for advanced entry into corresponding degree year/top-up and Master's/top-up programmes. Regulated by ofqual.gov.uk Recognised by World Education Services (WES) Assessment Assignments and Project No Examinations Entry Requirements A Bachelor's degree or an equivalent higher qualification. A copy of a valid photo ID for identification purposes. A well-written Statement of Purpose should outline the student's motivations, career goals, and reasons for pursuing the MA in Human Resource Management. An updated Curriculum Vitae (CV) that highlights at least two years of work experience at the graduate level in either a managerial or professional capacity. By submitting these necessary documents, applicants can take the initial step towards joining the MA in Human Resource Management programme and furthering their expertise in the field of HR. English Requirements A pass in English at the A level. Completion of a Bachelor's degree programme taught and assessed in English. An overall score of 6.5 or higher in the International English Language Testing System (IELTS), with a minimum score of 6.0 in each component. A Test of English as a Foreign Language (TOEFL) score of 72 or higher, with a minimum of 18 in reading, 17 in listening, 20 in speaking, and 17 in writing. In addition to the above requirements, all applicants will be required to participate in a live virtual interview with a staff member from the London Graduate School. 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. Structure Phase 1 : OTHM Level 7 Diploma in Human Resource Management Programme structure Strategic Human Resource Management Unit Reference No : J/618/1339 TQT : 200 Credit : 20 This unit aims to enhance learners' comprehension of how proficient strategic management of human resources contributes to attaining organizational goals across diverse environments. Learners will grasp the process of evaluating both external and internal factors impacting an organization and how these contextual elements inform the development of an effective HR strategy. The unit also delves into how strategic human resource management contributes to gaining competitive advantage and fostering organizational expansion. Engagement of Employees and Organisational Learning Unit Reference No : A/618/1340 TQT : 200 Credit : 20 This unit seeks to cultivate learners' comprehension of current issues in employee engagement, organizational learning, and people management and development. Learners will scrutinize and assess the aims and goals of human resource management. They will engage in the design and execution of HR action plans aimed at enhancing employee engagement and organizational performance. Leadership Development and Performance Management Unit Reference No : F/618/1341 TQT : 200 Credit : 20 This unit endeavours to foster strategic leadership and management competencies in learners. It encompasses understanding the pivotal role of leadership and management in augmenting teamwork, proficient communication, and organizational performance. The content aligns with the requisites of roles and competencies pertinent to a strategic level. Global Resourcing, Talent and Reward Management Unit Reference No : F/618/1341 TQT : 200 Credit : 20 This unit seeks to cultivate learners' comprehension of the principles and applications of resourcing, global talent management, and performance and reward management within corporate settings. It entails theoretical and practical insights into recruitment, selection, employee retention, dismissal, and other facets of global talent management. Additionally, learners will explore various strategies for effective reward and performance management within a global context. Managing Employment Relations and Employment Law Unit Reference No : F/618/1341 TQT : 200 Credit : 20 This unit aims to foster a solid understanding of the fundamental principles that govern the management of employment relations. Learners will delve into the realms of employee relations and employment law, with a special emphasis on legislation surrounding recruitment and selection, as well as the protective measures afforded to various types of organizations. Business Research Methods Unit Reference No : T/508/0626 TQT : 200 Credit : 20 This unit seeks to cultivate learners' comprehension of research principles, encompassing the crafting of research proposals, conducting literature reviews, proper referencing, employing data collection techniques like interviews and surveys, designing effective questionnaires, utilizing statistical analysis tools like SPSS, handling qualitative data, and using methodologies for drawing well-founded conclusions from the analyzed data.   Phase 2 - MA in Human Resource Management (Advanced Entry) Programme structure Research Methods Consultancy Project Report Delivery Methods The programme comprises two phases; the first is the Level 7 Diploma in Human Resource Management, awarded by OTHM and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The programme is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the MA in Human Resource Management (Advanced Entry), delivered by the London Graduate School and awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. 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.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Women in Banking Leadership Workshop Workshop Overview: Unleash your potential - The Banking and Financial Services industry is a constantly changing sphere that calls for emerging leaders to adapt and grow in order to thrive and succeed. Often those wanting to take the next step in the field find it hard to see their full value and potential, slowing their progress in a world full of opportunities. Emerging leaders will need to understand their professional values and know how to cultivate a growth mindset to stand out and fulfil their career desires.  This interactive virtual workshop will provide emerging leaders within the field the skills to understand the strengths that they are able to bring to the corporate table to confidently unleash their potential. It will particularly benefit those who aspire to move beyond early management to broader leadership roles. Kat will guide attendees to unlock their potential through releasing self-doubt, connecting to their unique contribution and forming a confident, strategic leader that will drive an organisation to success. Our Aims for the Workshop: Navigate key challenges and change in fast-paced work-places Understand the value of embracing complexity, uncertainty and diversity Negotiate diversity and inclusion biases, enablers and blocker Topic 1 Define your leadership style What are the capabilities, attributes and skills of an influential leader? What is your unique contribution? Is this congruent with your personal brand? Align your leadership strengths and values with the expectations and culture of your organisation. Topic 2 Leading with Emotional Intelligence (EQ) Understand your EQ and its impact on the way you are perceived as a leader Leverage your EQ in the workplace both in person and online Embrace qualities of empathy and authenticity to become a better leader Topic 3 Interactive Panel Q&A Discussion: Open Q&A with Senior Female leaders within the banking sector. Please see below the panel and biographies of each panellist. Topic 4 How to be known as a strategic leader Understand the uplevel from management to leadership and how to articulate your strategy How to translate broad leadership tools and tactics into practical, personalised results Move from transactional to transformational leadership Topic 5 Strengthen your resilience and resolve What is stress and how do you “show-up” on a bad day? Bounce back from challenging situations and predicaments Effectively manage conflict and turn negativity into an opportunity Who will attend? Emerging Leaders looking to step into management roles Current Leaders looking to progress into senior management roles This workshop is open to any woman who works in the banking sector that wants to take her next step in their career; women include trans women and non-binary people who are comfortable in a female-centred group. Group Rate Discounts 2-3 people, 7% discount 4+ people, 20% discount We have two group rates which you can take advantage of depending on the size of the group you wish to book: Option 1️⃣ Groups between 2 & 3 are eligible for the 7% Discount. Please use this code at checkout: GROUP 2+  Option 2️⃣ For groups of over 4+ attendees, the eligible discount is 20%. Please use this code at checkout: GROUP 4+  Where do I add the discount code?  Your Facilitator Kat Hutchings Kat coaches Executives and senior leaders in scale businesses to develop their leadership capability, build high-performing teams and create a culture that motivates and delivers. She works with them to identify their unique contribution and lead in a way that's aligned with who they are. Clients that work with Kat connect to their sense of purpose and how they contribute to the organisation. This creates a ripple effect through their team as they step into more powerful and impactful leadership. Kat coaches for insight - because a single insight can inspire action that changes everything.  Client outcomes include improved sales performance, successful delivery of change & transformation programmes and greater employee engagement & wellbeing.  Kat is an accredited Professional Executive Coach with the Association for Coaching and a Master NLP Practitioner. She has studied neuroscience, mindfulness and resilience, often bringing these insights to her coaching and training.  Combined with her experience as a leader in Financial Services, Kat’s clients find her to be commercially minded, knowledgeable and positively challenging. Her background as a corporate banker means Kat is quickly able to understand the context, including a firm’s strategy, vision and drivers. As a former Head of Coaching for the London & South East region of a FTSE 100 organisation, Kat is also well versed in leadership development programmes – their design, delivery and embedding through coaching. Outside of her coaching work, Kat spends lots of time with her husband and 2 young children. She enjoys trying different wines, talking to interesting people, having new experiences and buying flowers. THE PANEL The final panel is coming soon ⏳

Elevate your role as a non-finance manager by learning to interpret financial information and analysis and learn how your actions directly impact the company's bottom line.

Microsoft Excel® in Depth (Virtual) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Our bespoke Xero Training sessions are designed to get your Xero working properly & showing you the correct information, and to save you time for the important things... Get Xero set up properly, working as it should, error free Fix all of your Xero issues, once & for all Learn how to deal with your transactions correctly Use reporting to understand how your business is performing Gain confidence using Xero Save oodles of time on your accounting every single day with our bespoke Xero Training!

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE