1699 Courses delivered Online

Develop your graphic design skills and learn the professional Photoshop tools and techniques Looking to become a highly skilled Photoshop expert? Explore multiple graphic design training sessions and learn special Photoshop skills that’ll let you spread your creative wings. Here’s a Photoshop course full of valuable knowledge and tips that will help you edit and produce professional-grade images, photos, vectors and graphics by practicing with exciting tasks and exercises. The course is available for people with little or no experience in professional design and want to get their skills to a high level quickly. You can study at your own pace, anytime, anywhere; all you need is an internet connection. The flexibility of the course makes it easy to fit into your schedule and let you study stress-free from day one. You will master the Photoshop and learn everything about its interface and editing tools as well as how to use more advanced functions. Whether you want to use Photoshop for personal projects or integrate it into your professional work, this course has everything you need. Our expert will give you the tips on how to use Photoshop efficiently and will take you from beginner to pro. After taking the course, you will be completely comfortable navigating Photoshop and producing high-quality creative content. You will feel confident with your newfound ability to create astounding graphics with Photoshop. The Photoshop course explains everything in a simple, easy to follow format. Within it, you will find easy ways to use the vast array of tools available. You will learn from an expert with extensive professional Photoshop experience. Get creative! Start today! Join this comprehensive Photoshop course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Claude Simmons Photoshop expert Learn from an industry-leading expert in the digital creative sector!  You will learn from a Photoshop pro with over 10 years of experience using the program in a professional capacity. The course instructor has worked with many global brands and will share his expertise on how to enhance your photos, create graphics and develop professionally. Our course expert is passionate about simplifying the creative process and inspiring you to produce visually pleasing content using Adobe Photoshop. He will share the top tips and tricks on how to deliver consistently high-quality content for your projects without breaking a sweat. Claude will guide you from the very basics to the complex tools, so you become proficient in all areas of Photoshop. Sign up today to learn from one of the top creatives in the industry. Overview of the course:   – VIDEO PRESENTATIONS –   1. Practical knowledge about using Photoshop for both fun and professional purposes Getting to grips with the graphic designer knowledge, including: composition, UX, using colors, typography, formats, styles and more! You will learn how to choose best tools for a professional effect, both hardware and software. 2. Step-by-step video guides for complete skill enhancement Learn about Adobe cloud environment and Photoshop image and photo enhancing capabilities, work space, file formats and color modes.   – PRACTICAL PART –   Training videos and video tutorials In the course you can find in-depth tutorials that will help you discover all useful functions including retouch and photomontage. With this comprehensive and intensive course you will gain new skills quickly, so that you can implement them right away.   – REPETITIONS AND TESTS –   1. Repetition of acquired knowledge and tests Throughout the course, you will have 5 repetitions and 5 tests that will allow you to consolidate your knowledge. 2. Final test Passing the final test means that you have the knowledge and skills needed to use Photoshop at a professional level.   – EXERCISES AND TASKS – Design preparation and workshop Efficient use of Photoshop interface Designing with basic tools Creating retouches and photomontages Advanced designing with expert features   – BONUS MATERIALS – Photoshop tips and tricks guide Compendium of image formats Layout templates Thematic combinations (themes) Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor Why join the Kemp Center’s Photoshop course?Using digital creative platforms is a must in today’s world. Learning how to use Photoshop and gaining creative skills will give you an advantage, both professionally and while working on your passion projects. Photoshop can give you that extra edge. Stand out from others by showing you can create the thing that everyone wants – engaging graphic content.While learning Photoshop can enhance your career, it’s also very fun! You can use the program to retouch images, create compositions with graphics and text or create your own funny GIFs. Whatever you want to do, Photoshop has features to help you bring your creative visions to life. So don’t wait up, and start getting creative today!Our Photoshop course is comprehensive and covers all the basics but also teaches about Photoshop’s advanced features. After completing the course, you will become a confident graphic designer and, once you’re familiar with the interface, you can release your creative imagination.This course is for both beginners and more advanced users and you can decide yourself how deep you want to go with it.The course package contains extensive material presented in an engaging format. You will have a lot of fun going through the course on state of the art Kemp Center platform. You will learn and play by using specific examples, spaced repetitions and varied practical exercises. Taking the Photoshop course is a fun, affordable way to learn how to create and edit photos and graphics. Whatever your creative project is, Photoshop can do it. From creating image templates, mood boards or photo collages to designing your own 2D or 3D art, you will be able to do it all!Claude Simmons, Photoshop expert

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: Create and manage the layout of paragraphs Create and manage multi-level numbered paragraphs Effectively insert, use and manage section breaks Create and manage columns Find, create and apply styles Create and update a table of contents from styles Work with styles to manage formatting Work with sums in tables and use table headings Input and edit text using AutoText Work with SmartArt graphics Link to other files using paste special 1 Managing paragraph layout Controlling paragraph layouts with indents Creating and managing paragraph hanging indents 2 Numbering paragraphs Creating a new multi-level numbered paragraph Managing existing multi-level numbered paragraphs 3 Inserting columns Creating columns from existing paragraphs Setting up columns Managing columns 4 Document section breaks Controlling document layout using section breaks Managing page orientation using section breaks Managing page numbering using section breaks 5 Using styles Applying quick styles Finding existing styles Creating and saving styles Modifying styles Creating a table of contents from styles Updating a table of contents 6 Using quick parts Saving content to quick parts Modifying saved quick parts Inserting content using AutoText Editing AutoText entries Inputting text using AutoCorrect 7 Advanced table features Sorting table columns Running sums in tables Repeating table headings at top of page Importing Excel content in tables Using table properties 8 Creating a mail merge Creating letters, labels and emails Merging addresses from external files Using Outlook's address book to merge Merging to email 9 SmartArt graphic Visually communicate content with SmartArt Choosing a SmartArt graphic Inputting into SmartArt Modifying and formatting SmartArt graphics 10 Linking to other files Linking to files using paste special Linking an Excel chart to a document Managing linked content from Word

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: Create custom shows to personalise presentations for individual clients Make the Slide Master work collectively with slide layouts and themes Seamlessly interact with external content using links Work with advanced animations and transitions, and video/audio tools 1 Themes and Masters Add a Design theme to a presentation Make changes to the Slide Master Delete layouts from the slide master Saving a slide master with themes as a template 2 Advanced graphics and diagrams Drawing, duplicating and resizing shapes Grouping, aligning and stacking shapes and graphics Using SmartArt for diagrams and organisation charts 3 Graphs and charts Inserting and formatting a chart Linking an Excel chart to a slide Linking Excel tables to a slide Animating charts 4 Video, Custom animation and Hyperlinks Adding and editing video Animating pictures and drawings Hyperlink to another Slide or Website Compressing and optimising media 5 Presenting Reuse slides Hide slides Rehearsing timings Enabling a presentation to run continuously

Description Do you want to master the world's best photo editing software? Or are you new to Adobe Photoshop CC? Then enrol the Adobe Photoshop CC Foundation course and begin your acquaintance with the course. The course is for the learners who have little or no knowledge about the photo editor. You will start your journey from the beginning. You will be familiar with the user interface and know how to open and create an image in Adobe Photoshop. The course introduces you to the essential tools, brushes and other features so that you can able to decide which tools to select while editing. Additionally, the course illustrates the concepts of colour schemes and guides you on how to use the colors efficiently. The procedures of adding text and text styles, working with Layers, adjusting Layers, customizing the workspace, moving and transforming Pixels, cropping images, etc. will be covered in the course. Finally, the course shows you how to print, convert and export files from Photoshop. Shortly, the course gives you a general understanding of the application so that you can proceed with the advanced skills. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Photoshop CC Masterclass - Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Photoshop CC Masterclass - Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Adobe Photoshop CC Beginner Introduction Introduction FREE 00:03:00 Introduction to Photoshop Introduction to Photoshop 00:05:00 Understanding Types of Documents 00:04:00 Understanding Resolution 00:04:00 Creating New Documents 00:06:00 Using Artboards 00:05:00 Using CC Templates 00:03:00 Utilizing the Search Feature 00:02:00 Customizing the Workspace Using Workspace Presets 00:02:00 Moving, Closing, and Opening Panels 00:06:00 Understanding Document Views 00:06:00 Using the History Panel 00:06:00 Working with Layers Why Layers 00:02:00 Using Layers 00:07:00 Creating Fill Layers 00:05:00 Applying Blending Modes 00:04:00 Using Layer Styles 00:09:00 Discovering the Properties Panel 00:08:00 Understanding Selections Creating Basic Selections 00:09:00 Using the Lasso Tools 00:08:00 Understanding the Quick Select Tools 00:07:00 Editing the Quick Mask 00:04:00 Saving Selectionsv 00:04:00 Moving Selections to Layers.mp 00:03:00 Understanding and Using Color Understanding Color Modes 00:10:00 Creating Swatches 00:06:00 Using Masks and Advanced Layers Applying Layer Masks 00:00:00 Deleting Layer Masks 00:01:00 Organizing Layers 00:03:00 Merging Layers 00:02:00 Flattening Layers 00:02:00 Working with Layer Comps 00:06:00 Using Adjustment Layers Using Image Adjustments 00:07:00 Understanding Adjustment Layers 00:10:00 Using Layer Masks with Adjustment Layers 00:03:00 Cropping Images Using the Crop Tool 00:05:00 Using the Crop Tool to Add Canvas 00:02:00 Moving and Transforming Pixels Using Free Transform 00:04:00 Working with Other Transform Options 00:03:00 Flipping Pixels 00:01:00 Adding Text and Text Styles Using the Type Tool 00:10:00 Discovering Typesetting 00:08:00 Formatting Text 00:09:00 Creating Type on a Path 00:03:00 Warping Type 00:03:00 Using Styles on Type 00:08:00 Applying Special Effects Using Layer Styles 00:05:00 Working with Patterns 00:03:00 Applying Filters 00:04:00 Creating Pixels with Filters 00:06:00 Exporting from Photoshop Printing in Photoshop 00:03:00 Converting to CMYK 00:04:00 Converting to Other File Types 00:13:00 Using File Info 00:09:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Intermediate Start Here Introduction FREE 00:03:00 Painting and Using Brushes Painting with Brushes 00:09:00 Using the Brushes Panel 00:06:00 Defining Custom Brushes 00:04:00 Saving Tool Presets 00:02:00 Using the History Brush 00:03:00 Using Vector Tools Working with Vector Shapes 00:10:00 Creating Custom Shapes 00:02:00 Using the Pen Tool 00:07:00 Discovering Paths 00:04:00 Understanding Vector Masks 00:03:00 Using Vector Objects and Spot Colors 00:06:00 Using Libraries What is the CC Library 00:02:00 Adding and Deleting Assets in the Library 00:03:00 Sharing Assets 00:02:00 Creating New Libraries 00:03:00 Sharing a Library 00:02:00 Advanced Special Effects Using the Blur Filters 00:06:00 Applying the Distort Filters 00:03:00 Creating a Pixelated Look 00:02:00 Stylizing Effects 00:02:00 Using Liquify 00:05:00 Using Smart Filters 00:04:00 Working with Smart Objects 00:03:00 Loading a Texture into Type 00:04:00 Working with RAW Images What is a Raw Image 00:05:00 Processing Raw Images 00:12:00 Opening a JPEG File in Raw 00:06:00 Retouching Basics Developing a Strategy for Retouching 00:04:00 Using Retouching Tools 00:10:00 Using the Dust and Scratches Filter 00:04:00 Applying Sharpening 00:08:00 Working with Face Aware Liquify 00:06:00 Automating Tasks Using Actions 00:03:00 Creating Actions 00:07:00 Using Droplets 00:05:00 Using the Image Processor 00:05:00 Creating an HDR Image 00:07:00 Creating a Panoramic Image 00:07:00 Integration with other Adobe Software Using PSD Files in InDesign 00:04:00 Using PSD Files in Illustrator 00:03:00 Using PSD Files in Dreamweaver 00:04:00 Understanding Color Management Why Color Management 00:03:00 Calibrating a Monitor 00:04:00 Calibrating a Printer 00:03:00 Loading Profiles into PSDs 00:02:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Advanced Introduction Introduction FREE 00:03:00 Processing Raw Images What is the RAW Format 00:04:00 Understanding White Balance 00:05:00 Setting Exposure 00:07:00 Working with Color and Clarity 00:03:00 Working with Adobe Camera Raw Updating Adobe Camera Raw 00:01:00 Using the Before and After Views 00:05:00 Resetting the Sliders 00:01:00 Understanding the Workflow Options 00:04:00 Setting the Camera Raw Preferences 00:03:00 Working with the Tools Understanding the White Board Tool 00:03:00 Using the Color Sampler 00:01:00 Working with the Targeted Adjustment Tool 00:02:00 Cropping Images 00:03:00 Applying Straightening 00:01:00 Using the Spot Removal Tool 00:05:00 Applying the Red Eye Tool 00:03:00 Understanding the Adjustment Brush 00:04:00 Using the Graduated Filter 00:02:00 Applying the Radial Filter 00:02:00 Rotating Images 00:01:00 Using Advanced Exposure Settings and Sharpening Using Curves 00:03:00 Understanding Sharpening and Noise 00:03:00 Creating Grayscale Images 00:03:00 Using Split Toning 00:03:00 Managing Corrections and Effects Enabling Lens Profiles 00:03:00 Using Effects 00:02:00 Adding Grain 00:02:00 Applying Post Crop Vignette 00:02:00 Using Camera Calibration 00:03:00 Saving Presets 00:02:00 Applying Snapshots 00:02:00 Creating Image Adjustments Using Adjustment Layers 00:02:00 Painting Layer Masks 00:05:00 Discovering Plugins for Photoshop What are Plugins 00:04:00 Using the Nik Collection 00:08:00 Using HDR Pro Effex 00:06:00 Using On1 Effects 00:04:00 Exploring Workflows Introudcing the Workshop Videos 00:04:00 Processing a Landscape Image 00:13:00 Processing a Macro Image 00:09:00 Processing a City 00:11:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Follow your dreams by enrolling on the Microsoft Excel Masterclass course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel Masterclass will help you arm yourself with the qualities you need to work towards your dream job. Study the Microsoft Excel Masterclass training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel Masterclass course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Microsoft Excel Masterclass course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel Masterclass course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Microsoft Excel Masterclass course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Excel Masterclass course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel Masterclass course. The Microsoft Excel Masterclass course is designed by industry experts and is tailored to help you learn new skills with ease.  The Microsoft Excel Masterclass is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Excel Masterclass when it suits you. Access the Microsoft Excel Masterclass course modules from any internet-enabled device, including computers, tablets, and smartphones. The Microsoft Excel Masterclass course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel Masterclass now and start learning instantly! What You Get Out Of Studying Microsoft Excel Masterclass With Janets: Receive a digital Certificate upon successful completion of the Microsoft Excel Masterclass course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Microsoft Excel Masterclass training course is delivered through Janets' online learning platform. Access the Microsoft Excel Masterclass content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel Masterclass course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Microsoft Excel Masterclass course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel Masterclass course. After successfully passing the Microsoft Excel Masterclass course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel Masterclass qualification. Certification All students who successfully complete the Microsoft Excel Masterclass course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Excel Masterclass course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Microsoft Excel Masterclass is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel Masterclass course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Microsoft Excel Masterclass is open to all students and has no formal entry requirements. To study the Microsoft Excel Masterclass course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Microsoft Excel Masterclass is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel Masterclass and gain an industry-recognised qualification that will help you excel in finding your ideal job.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for intermediate business and requirements analysts who are looking to improve their business case development and presentation skills. This course is also a great fit for project managers and product owners who work closely with business analysts or who perform some form of business case work themselves. Overview Understand the role of the business analyst within the business case process Understand the main professional associations and standards that support business analysts in the industry Discuss the benefits of business case creation Explore how to define the business need Describe the role of the business analyst in supporting the enterprise to determine how to optimally invest in the right project initiatives Explain how to identify stakeholders and the significance to the pre-project activities Discuss the importance of analyzing the enterprise Describe and explore the activities performed to assess the current business environment Explain how a business analyst describes a ?future? state environment including how to identify gaps in enterprise capabilities Present and explore how to define the scope of a solution Describe the activities performed and techniques used to determine viable solution options Explore various techniques for evaluating solution options including feasibility and risk analysis Thoroughly understand the purpose of conducting a feasibility assessment Discuss and practice a number of business analysis techniques that support the business case process Explore the components of a business case Describe how the business case supports decision makers in making go/no-go decisions Demonstrate how to assemble the output from pre-project activities into a well-structured business case Present techniques for presenting business cases to top level managers and obtaining buy-in Discuss methods for preparing for challenges during business case delivery Students learn the steps to effective business case development and support your strategic business recommendations with sound budgeting and financial back-up. The one course you need to make high-impact recommendations and receive full management support for your ideas. Introduction Module Learning Objectives What is Business Analysis Polling Question International Institute of Business Analysis BABOK© Guide Components Project Management Institute Business Analysis for Practitioners: A Practice Guide BABOK© Guide Knowledge Areas Benefits of Business Analysis Polling Question A Business Analyst can Influence Project Success Factors Challenges of Business Analysis Polling Question Purpose of a Business Case Exercise 1a: What Should a Business Case Include Define the Business Case Elements What to Look Out For Who is Involved Exercise 1b: Review Business Case Outline Module Learning Objectives Pre-Project Activities & the Business Analyst Module Learning Objectives The Definition of a Business Analyst The Role of a Business Analyst Responsibilities of a BA BA Role vs. PM Role Business Analysis vs. Systems Analysis Business Analysis Competencies Polling Question Business Analyst Role and Stakeholders Exercise 2a: Review the Case Study What is a Stakeholder? The Importance of Stakeholders Stakeholder Identification Tips for Identifying Stakeholders Other Stakeholder Tips Stakeholder Identification/Analysis Exercise 2b: Identify Roles and Responsibilities Stakeholder Map Stakeholder Matrix & Onion Diagrams A Stakeholder Map Onion Diagram Exercise 2c: Why do we Need to Understand the Enterprise? Why Study the Enterprise? What is Enterprise Architecture? What is Strategy Analysis? About Strategy Analysis Purpose of Strategy Analysis When to Perform Strategy Analysis Strategic Planning Module Summary The Needs Assessment Process Module Learning Objectives Business Need Defined Define Business Need The Needs Assessment Process Problem or Opportunity Exercise 3a: Problem/Opportunity Identification Understanding Why Situation Statements Business Need and Current State Determine the Stakeholders Polling Question Goals and Objectives Polling Question Exercise 3b: Give 3 Examples of Business Goals Define Business Need Techniques Exercise 3c: Identify the Business Need Definition of Strategy Analysis When Business Strategy is not Driving Project Definition Typical Project Profile The Executive Paradox Solution to the Paradox Exercise 3d: Describe 3 Outcomes You Would Expect from the Case Study The Four ?Ares? Understand How to Create a Business Model Business Model Example Exercise 3e: Create a Business Model The Business Case Approach Financial and Strategic Measurement Tools Module Summary Determining the Required Capabilities & Defining Solution Scope Module Learning Objectives Business Need and Current State Purpose of Analyzing the Current State Analyzing Current Capabilities and Process Capabilities Defined Techniques for Analyzing the Current State Define the Future State Techniques for Defining the Future State Assess Capability Gaps Stakeholders Involved when Reviewing Capability Gaps Discussion: Assessing New Capabilities Defining Solution Scope Determining Scope Boundary How to Define Solution Scope Defining Solution Scope Project Scope and Product Scope Scope Modeling Techniques Used to Define Scope Define Scope Boundaries Modeling Scope: Context Diagram Exercise 4a: Create a Context Diagram from the Case Study Communicating Solution Scope to Stakeholders Stakeholders Participating in Scope Activities Exercise 4b: Discuss Managing Expectations Module Summary Assessing Feasibility & Proposing Solution Options Module Learning Objectives Financial Analysis Purpose of Financial Analysis Costs versus Benefits Financial Models Timing for Assessing Financial Benefits Risk Assessing Risks Risk Process Exercise 5a: Identifying Risks Risk Analysis Capturing and Categorizing Risks Risk Strategies Tolerance for Risk Determining Solution Options Solution Option Process Determining and Analyzing Solution Options Brainstorming Conducting an Outcomes Focused Brainstorming Session Stakeholders Involved in Determining Solution Options Exercise 5b: Determining Solution Options Feasibility Analysis Discussion: Ranking Solution Options Discussion: Recommending the Most Viable Option Exercise 5c: Assess the Most Viable Options Solution Approach Definition Exercise 5d: Review the Business Case Templates Module Summary Packaging & Presenting the Business Case Module Learning Objectives Circumventing a Business Case Documenting the Business Case Value of the Business Case Process Business Case Components Business Case Techniques Build a Convincing Business Case Discussion: Identifying Decision Criteria Exercise 6a: Supporting a Go/No Go Decision Packaging the Business Case Planning Business Case Delivery Discussion: Planning Stakeholder Buy-in Information and Communication Needs in the Business Case Process Presenting your Business Case Exercise 6b: Anticipating and Responding to Challenges Module Summary Course Wrap Up Course Summary Questions Additional Resources Thank You Additional course details: Nexus Humans BA03 - Writing Effective Business Cases training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BA03 - Writing Effective Business Cases course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Do you want to create outstanding apps with SwiftUI? Moreover, are you eager to build up your professional portfolio and show up in your next job interview with confidence? This complete iOS application development course is designed to teach you how to become an advanced multiplatform app developer using Apple's native user interface framework: SwiftUI.

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Excel 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Microsoft Excel 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00