4124 Analyst courses

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Overview This comprehensive course on Data Analysis and Forecasting in Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Analysis and Forecasting in Excel comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Analysis and Forecasting in Excel. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis and Forecasting in Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 31 lectures • 04:43:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

Overview This comprehensive course on Excel Data Analysis for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Data Analysis for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Data Analysis for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel Data Analysis for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 11 lectures • 01:11:00 total length •Tracing Formulas: 00:04:00 •Using the Scenario Manager: 00:07:00 •Goal Seek: 00:03:00 •Solver: 00:03:00 •Data Tables: 00:11:00 •Data Analysis Tools: 00:16:00 •Forecast Sheet: 00:02:00 •Sumif, Countif,Averageif, Sumifs, and Countifs formulas: 00:09:00 •If, And, Or, and Nested If formulas: 00:16:00 •Resource - Excel Data Analysis for Beginner: 00:00:00 •Assignment - Excel Data Analysis for Beginner: 00:00:00

Untapped Agility - 3 Leadership Moves to Transform Your Transformation Agile transformations are supposed to make organizations modern. competitive. and relevant. But in the well-intentioned effort to move into the future. change leaders find themselves frustrated by pushback. limited impact. poor practices. and unfair criticism. What's going on?This breakthrough presentation cuts through the 'quick fix' hype of agile theory and explains a recurring transformational pattern that unpacks what holds organizations back: The BOOST is the initial gains from logical first steps; the BARRIER is the unavoidable roadblock that must come next; the ReBOUND is the way forward to further gains by leaning against the concept of the original boost. With these counter-intuitive rebounds in mind. this energetic talk explores three leadership moves that can be used to unblock stalled agile transformations.No. your transformation is not a failure. It turns out the buy-in. the talent. the alignment. and the growth you need to break through are already in front of you; it's all simply hidden under the surface. Undiscovered. Unutilized. Untapped. What you will Learn Key Takeaways: How labelling agile anti-patterns actually impedes the journey How to take the next step past a transformation barrier How to reframe transformation barriers into adjustments

The FBI Case Management System: The Story of Waterfall Failure and Agile Success Learn how the FBI successfully transformed to Agile processes after multiple Waterfall attempts in a case study that showcases a $300 million transformation of one of its biggest and most critical projects ever. Too often we are taught theoretical processes that sound great but don't truly back up the promise with data and experience. This presentation is a case study of how big government failed, failed and then succeeded. You too can you learn from these mistakes and then go forwards and succeed. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

The Intersection of Agile and Culture Most accept that agile methods and practices work but how do you apply them at scale without stifling the creativity, autonomy, and energy of your teams? Listen as Aaron Bjork describes the importance of organizational culture in scaled agile implementations. Aaron will share stories from his experiences at Microsoft and provide practical advice for how to intersect agile and culture in your organization and teams. Key takeaways: Learn why culture and agile are not mutually exclusive. Learn practical ways to strengthen the agile mindset on your teams. Learn ways to identify where culture is interfering with agile adoption. Learn what has/hasn't worked during Microsoft's agile transformation.

When is Your Agile Transformation Done? After over a decade of agile transformations. many organizations have several years of agile experience of agile are naturally looking for signs that the change is complete. Attention turns to the level of skill or maturity an organization needs in order to declare the transformation a success. As a result. models of agile maturity have emerged that promise to somehow measure how agile you are.The good news is that agile. by definition. should be iteratively delivering value from the moment a transformation starts. Looking back. your ability to deliver has already changed immeasurably. You are already faster. more focused. and delivering a product with higher quality. The bad news is that you have only just started your journey. Change itself has changed. as Gary Hamel said. What looks mature today will be 'bare essentials' tomorrow.Using the concept of Wardley Maps. we will talk about what agile maturity looks like today. and where agile maturity will go in the future. We will learn how iterative value delivery is the price to pay to move along the experience curve. The more frequently you deliver value. the faster you move along the experience curve. By introducing a model of increasing agility. you will be able to map out the path of your transformation. filling in any gaps that you may have and beginning to understand what direction your transformation may take you in the future. What you will Learn Key Takeaways: Differentiate between maturity models and development models. and apply the right model in the right situation Learn how to apply Wardley Mapping to your agile transformation strategy

The Do's and Don'ts of Scaling Agile At some point your organization is going to start thinking about scaling Agile. But when is the right time to do this? If you have teams that are challenged, scaling too soon will just make small problems bigger problems. There is also the challenge of deciding how to scale. There is a plethora of scaling frameworks available, each with their own advantages and disadvantages, but which one is right for you? How do you decide? This session will help you make sense of the choices, timing and elephant traps involved with scaling Agile. Key Takeaways: Understand why scaling agile is needed. Gain insight in the key challenges of scaling agile

Developing People and Shaping Culture With People Operations (HR) Organizational agility is critical for corporate survival in today's dynamic global economy. Cultural evolution to the adoption of Agile values, principles, and mindset is essential to long-term success and survival.HR (and an HR function) is best equipped to support cultural evolution to Agility and continued long-term sustainability. Unfortunately, HR is not usually considered early on in an Agile transformation when they can be one of the biggest impacts and allies to the success of Agile transformations.This session will explore how HR teams can help seed and nurture the Agile mindset within a transforming organization. We will discuss some of the specific activities HR can and should participate in to support a long-term investment in organizational agility.Let's not forget about HR - one of the best qualified and much needed partners for the journey to agility. Oh, and HR can go Agile too, by the way! This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies.

Developing People and Shaping Culture With People Operations (HR) Organizational agility is critical for corporate survival in today's dynamic global economy. Cultural evolution to the adoption of Agile values, principles, and mindset is essential to long-term success and survival.HR (and an HR function) is best equipped to support cultural evolution to Agility and continued long-term sustainability. Unfortunately, HR is not usually considered early on in an Agile transformation when they can be one of the biggest impacts and allies to the success of Agile transformations.This session will explore how HR teams can help seed and nurture the Agile mindset within a transforming organization. We will discuss some of the specific activities HR can and should participate in to support a long-term investment in organizational agility.Let's not forget about HR - one of the best qualified and much needed partners for the journey to agility. Oh, and HR can go Agile too, by the way! This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies.