1047 Courses in Cardiff delivered Online

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. 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? Microsoft Office 2013 Excel Advanced - Complete Video Course 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 Microsoft Office 2013 Excel Advanced - Complete Video Course 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. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Unreal Engine 4 is a comprehensive course that equips you with the skills to excel in 3D game development. You will master the intricacies of Unreal Engine 4, enabling you to create immersive game worlds and breathtaking visuals. The course addresses the common problem of bridging the gap between creativity and technical know-how, allowing you to bring your game ideas to life effortlessly. By joining this course, you'll unlock a world of opportunities in the gaming industry. The gaming industry is rapidly expanding, and skilled Unreal Engine 4 professionals are in high demand. This course ensures you are well-prepared to tackle the challenges of game development, making you a valuable asset to any game studio. The problem of lacking the technical skills to create captivating games will be solved, and you'll reap the benefits of a rewarding career in the gaming world. Learning Outcomes Gain proficiency in using Unreal Engine 4 for 3D game development. Create and organise scenes, add materials, and manage lighting. Understand advanced lighting techniques like atmospheric fog and god rays. Develop a comprehensive understanding of Unreal Engine Particle System. Create cinematic sequences and customize camera settings. Export projects in production quality and for further editing. Successfully complete a written assignment test.. Why choose this Unreal Engine 4 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Unreal Engine 4 course for? Aspiring game developers and designers. Individuals interested in 3D game development. Beginners looking to enter the gaming industry. Professionals seeking to enhance their skills. Anyone passionate about creating immersive virtual worlds. Career path Game Developer: £25,000 - £60,000 per year. 3D Game Artist: £25,000 - £45,000 per year. Level Designer: £25,000 - £55,000 per year. Game Producer: £30,000 - £70,000 per year. VR/AR Developer: £35,000 - £70,000 per year Prerequisites This Unreal Engine 4 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Unreal Engine 4 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unreal Engine 4 Module 01: Download Unreal Engine 00:03:00 Module 02: Epic Launcher Overview 00:05:00 Module 03: Create Your First Project in Unreal 00:13:00 Module 04: Create Folders and Organize Your Scene 00:03:00 Module 05: Open Different Viewports 00:03:00 Module 06: Dock and Undock Windows 00:03:00 Module 07: Save Your Scene 00:01:00 Module 08: Hide Scene Icons 00:02:00 Module 09: Summery F Key and ALT Key 00:02:00 Module 10: Drag and Drop Walls into the Scene 00:08:00 Module 11: Add Materials to the Walls 00:05:00 Module 12: Quick Look at Materials in the Material Editor 00:02:00 Module 13: Deleting All Lights Then Add Directional Light 00:03:00 Module 14: Contact Shadow 00:02:00 Module 15: Set Up Your First Point Light 00:04:00 Module 16: Set Up a Spotlight 00:03:00 Module 17: Add Rectangle Light 00:04:00 Module 18: Cool Light Setup 00:07:00 Module 19: Sphere Reflection Capture 00:03:00 Module 20: Skylight Lighting with HDRI 00:03:00 Module 21: Create the Sky 00:03:00 Module 22: Atmospheric Fog 00:01:00 Module 23: Exponential Height Fog 00:03:00 Module 24: God Rays 00:02:00 Module 25: Unreal Engine Particle System 00:05:00 Module 26: Create a New Level and Add a Character 00:04:00 Module 27: Preview of the Scene We Are Creating 00:01:00 Module 28: Create HDRI Environment 00:06:00 Module 29: Add Cinematic Camera to the Level 00:04:00 Module 30: Create a New Level Sequence 00:03:00 Module 31: Add Our Mannequin Character 00:04:00 Module 32: Camera Settings 00:10:00 Module 33: Depth of Field 00:05:00 Module 34: Camera Movement 00:06:00 Module 35: Second Camera 00:09:00 Module 36: Export Your Project in Production Quality 00:03:00 Module 37: Export Your Video for Further Editing 00:09:00 Assignment Assignment - Unreal Engine 4 00:00:00

Become a PCB design expert with EasyEDA, a powerful and user-friendly PCB design software. This course will teach you everything you need to know to design and create your own PCBs, from the basics of schematic capture to advanced routing techniques.

The case of accounting is similar to 'Behind every successful man, there's a woman' because 'Behind every successful business, there is a skilled accountant'. The accountant moves his/her wand to record, classify, summarise and interpret the financial condition and economic activities of a business. Accountants with their knowledge of finance, mathematics, statistics, and economics not only keep an eye on the books but also predict any future challenges. Moreover, accounting is the backbone of all businesses and that is why businesses spend a hefty amount of money on accountants. This makes this profession one of the most respected and safest professions as the demand is always high. Are you looking to start a new career or switch your career to accounting? If so, enrol in our comprehensively designed self-paced accounting bundle course. In our accounting bundle course, we will cover not only accounting but also tax, data analysis, business analysis, financial modelling, bookkeeping and so much more. So, what are you waiting for, join our Accountancy: Accountant & Tax course to start your learning journey. Along with this Accountancy: Accountant & Tax course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Accountancy: Accountant & Tax Bundle Consists of the following Premium courses: Course 01: Accounting and Tax Course 02: Team Management Course 03: Introduction to Accounting Course 04: Financial Modeling Using Excel Course 05: Data Analysis in Excel Level 3 Course Course 06: Business Analysis Level 3 Course 07: Level 2 Effective Minute Taking Course Course 08: Diploma in Sage 50 Accounts Course 09: Decision Making Course 10: Personal Hygiene Course 11: Professional Bookkeeping Course Learning Outcomes of our Course: Acquire knowledge of the tax system and how it works in the UK Get a detailed overview of tax on individuals and income tax Learn about national insurance management accounting Gain all the skills needed to submit a self-assessment tax return Explore both fundamentals of income tax and advanced income tax Gain an acute understanding of payee, payroll and wages Become fully aware of capital gain tax and value-added tax Get comprehensive knowledge of corporation and inheritance tax Understand double-entry accounting and financial analysis Learn about import and export and the tax involved Explore the career of a tax accountant in the UK Display knowledge of how to present financial information and financial modelling Get an overview of data analysis and business analysis Learn about bookkeeping and how to use Sage 50 accounts Enrol now in Accountancy: Accountant & Tax to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Accountancy: Accountant & Tax expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Courses Curriculum Here is the curriculum breakdown of the Accountant & Tax course: Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Advanced Income Tax Module 07: Payee, Payroll and Wages Module 08: Capital Gain Tax Module 09: Value-Added Tax Module 10: Import and Export Module 11: Corporation Tax Module 12: Inheritance Tax Module 13: Double Entry Accounting Module 14: Management Accounting and Financial Analysis Module 15: Career as a Tax Accountant in the UK Here is the list of additional courses that come with this course: Course 01: Presenting Financial Information Course 02: Introduction to Accounting Course 03: Financial Modeling Using Excel Course 04: Data Analysis in Excel Level 3 Course Course 05: Business Analysis Level 3 Course 06: Level 2 Effective Minute-Taking Course Course 07: Diploma in Sage 50 Accounts Course 08: Decision Making Course 09: Personal Hygiene Course 10: Professional Bookkeeping Course Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This self-paced course is suitable for anyone who: Is planning to become an accountant or looking for a similar career Has a profession that requires knowledge of accounting and taxes Wants to educate themselves about accounting and taxes Requirements This Accountancy: Accountant & Tax course has been designed to be fully compatible with tablets and smartphones. Career path By the end of this course, learners will be able to take the steps towards starting a new career. Here are a few career options they can opt for: Public Finance Accountant - £22,000 to £65,000 per annum Insurance Account Manager - £18,000 to £75,000 per annum Accounting Technician - £17,000 to £34,000 per annum Bookkeeper - £18,000 to £35,000 per annum Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Accounting and Tax) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Why choose 3ds max and After Effects Training Course (Live Online Only)? Join our personalized "3ds Max and After Effects Training Course (Live Online Only)" for a focused learning experience. Develop expertise in production environments, 3D modeling, texturing, lighting, animations, VFX and cinematography.  Check Our Website Duration: 10 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. 3ds Max and After Effects Motion Graphics Course Duration: 10 hours Course Outline: Introduction to 3ds Max Familiarize yourself with the 3ds Max interface Create 3D objects and scenes Learn about cameras, lighting, materials, and textures Basic Animation Principles in 3ds Max Understand keyframes and interpolation Create animation cycles for 3D objects Apply animation principles using the graph editor Advanced Animation Techniques in 3ds Max Master custom controllers and expressions Animate with inverse kinematics Create dynamic particle systems and simulations Exporting 3D Scenes to After Effects Prepare 3D scenes for export Import 3D scenes into After Effects Explore 3D layer properties Basic Compositing in After Effects Navigate the After Effects interface Use keyframes and animation curves Compositing 2D and 3D elements Apply effects and filters Advanced Compositing Techniques in After Effects Harness masks and mattes for precision Utilize 3D camera tracking Work with green screen footage Create stunning special effects Integrating 3D and Live-Action Footage in After Effects Match camera angles and movement Incorporate 3D camera data into After Effects Add shadows and reflections for realism Rendering and Outputting Animations Render 3D scenes from 3ds Max Utilize the After Effects render queue Output animations for different formats Motion Graphics Projects Create a basic motion graphics sequence Design an animated logo Craft an engaging animated title sequence Course Requirements: Computer with 3ds Max and After Effects installed Basic knowledge of computer operations Passion for motion graphics

Description: Here you go the next/another part after Microsoft Project 2016 for Beginners. This Microsoft Project 2016 Advanced is the ultimate next step designed for anyone who has completed the Microsoft Project 2016 beginner course, or experienced project managers ready to take their next project skills to the next level. By taking this Microsoft Project 2016 Advanced you will get comfortable on managing the project environment, working within task structures, generating views, and creating reports and much more. So, become an expert at Microsoft Project 2016 with this advanced course. Learning Outcomes: How to link projects, create and use resource pools, and baseline a project Working with custom fields, changing project options and extending projects with apps Change task list, create network diagram, manage critical path, use lag and lead, update project work, and analyze earned value Four different ways to generate project views including: using view commands, existing views, creating custom views, and formatting and sharing the timeline view Utilize existing, create custom and export visual 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? Microsoft Project 2016 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 Microsoft Project 2016 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. Managing the Project Environment Link Projects 01:00:00 Create and Use Resource Pools 01:30:00 Baseline a Project 00:00:00 Work with Custom Fields 01:30:00 Change Project Options 01:30:00 Extend Project with Apps 00:30:00 Managing Task Structures Change a Task List 01:30:00 Create a Network Diagram 00:45:00 Manage the Critical Path 00:15:00 Use Lag and Lead 00:30:00 Update Project Work 00:45:00 Analyze Earned Value 01:00:00 Generating Project Views Use View Commands 01:00:00 Use Existing Views 00:15:00 Create Custom Views 01:30:00 Format and Share the Timeline View 00:45:00 Producing Project Reports Use Existing Reports 00:30:00 Create Custom Reports 01:30:00 Export Visual Reports 01:00:00 Activities Activities - Microsoft Project 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Project 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Project 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Description The Diploma in Adobe XD Design course is designed to teach the all-in-one UX/UI solution - Adobe XD for developing a real-world iPhone app. Adobe XD is a UX/UI solution that helps you to design websites, mobile apps and others. The course covers the essential tools and features of Adobe XD so that you can able to apply the skills in your real-world project. You will learn to apply Paper Prototyping techniques and able to create Interactive Prototype. The course also shows you the procedures of opening sketch, Photoshop and Illustrator files with Adobe XD. Finally, you will learn to collaborate with other developers using Zeplin & Avocode. After completing the course, you will learn to use Adobe XD and create a real world App in Adobe XD by following iOS Design guidelines. Entry Requirement: Beginner Designers UX Designers UI Designers Graphic Designers Web Designers Mobile App Designers Developers or Coders Anyone who wants to design User Interfaces or Websites or Mobile Apps Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. 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. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. 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: 01 Promo Video 00:03:00 What Is Adobe XD 00:07:00 Download And Install Adobe Xd 00:03:00 Why Adobe XD Is So Awesome - Talkinghead 00:04:00 Updates And Upcoming Features Xd 00:03:00 Adobe XD Interface Welcome Screen 00:03:00 Adobe Xd Top Nav Bar 00:02:00 Adoe Xd Interface Toolbar 00:02:00 Properties Panel Adoe Xd Interface 00:03:00 Xd Mac And Win Differences 00:05:00 First Assignment Simple One 00:08:00 Module: 02 Artboards and grids 00:08:00 Tools in xd 00:05:00 Rectangle tool to create buttons 00:07:00 Background and object blur 00:03:00 Ellipse tool 00:02:00 Basics of pen tool 00:03:00 Pen tool to creat Icons 00:06:00 Line tool 00:01:00 Text-tool 00:03:00 Colors Palettes 00:04:00 Color Gradients in Xd 00:06:00 Coolors.io 00:04:00 Masks in xd 00:06:00 Character styles in Xd 00:05:00 Creating and reusing symbols 00:07:00 Repeat grid 00:09:00 Common Shortcuts 00:06:00 Shortcut keys part2 00:08:00 Nested symbols in xd 00:06:00 Module: 03 S03L01 block-level design 00:12:00 S0302 Sketching First Design Idea-block Level Paper 00:08:00 S0303 First Paper Prototype- Adding Details 00:04:00 S0304 Vertical Horizontal Prototypes T Proto 00:09:00 S0305 Level Of Fidelity and prototypes 00:00:00 S0306 adding details to your block design 00:08:00 S0307 using ui design patterns 00:04:00 S0308 creating signup ios screen EXERCISE 00:14:00 Module: 04 S0401 Design preparations 00:05:00 S0402 Color scheme and insprations 00:05:00 S0403 Solving UX problems of old app 00:04:00 S0404 Welcome Screen design 00:10:00 S0405 designing the login screen 00:14:00 S0406 login-activated 00:12:00 S0407 Signup Screen 00:07:00 S0408 dashboard design part 1 00:12:00 S0409 dashboard design part 2 00:11:00 S0410 Sidebar Navigation 00:09:00 S0411 actitivies screen 00:11:00 S0412 sync screen 00:08:00 S0413 sync status update 00:04:00 S0414 using grids to improve designs further 00:05:00 S0415 refining style guides 00:08:00 S0416 IOS Design guidelines 00:09:00 Module: 05 S0501 fixing tap targets 00:06:00 S0502 prototype login and signup screens 00:10:00 S0503 prototyping dashboards and other screens 00:11:00 S0504 sharing prototype with others 00:04:00 S0505 recording prototype on mac 00:02:00 S0506 design Inspect beta 00:04:00 Module: 06 S0601 why to export in 1x 2x 3x 00:09:00 S0602 Perfect example of 1x 2x 3x 00:03:00 S0603 export artboards to create mockups 00:08:00 S0604 batch export 00:06:00 Module: 07 S0701 Live Preview Your App On Iphone 00:02:00 S0702 Developer handoff with Zeplin 00:13:00 S0703 Developer Handoff using Avocode 00:14:00 S0704 open sketch-psd-illustrato import 00:08:00 Module: 08 XD updtaes april may 2018 00:04:00 1st Exercise Asssignment-1 00:03:00 Second Assignment-1 00:03:00 Third Last Assinment - Google Drive 00:03:00 Resources Resources - Diploma in Adobe XD Design 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 4 Days 24 CPD hours This course is intended for This course is for the Identity and Access Administrators who are planning to take the associated certification exam, or who are performing identity and access administration tasks in their day-to-day job. This course would also be helpful to an administrator or engineer that wants to specialize in providing identity solutions and access management systems for Azure-based solutions; playing an integral role in protecting an organization. The Microsoft Identity and Access Administrator course explores how to design, implement, and operate an organization?s identity and access management systems by using Microsoft Entra ID. Learn to manage tasks such as providing secure authentication and authorization access to enterprise applications. You will also learn to provide seamless experiences and self-service management capabilities for all users. Finally, learn to create adaptive access and governance of your identity and access management solutions ensuring you can troubleshoot, monitor, and report on your environment. The Identity and Access Administrator may be a single individual or a member of a larger team. Learn how this role collaborates with many other roles in the organization to drive strategic identity projects. The end goal is to provide you knowledge to modernize identity solutions, to implement hybrid identity solutions, and to implement identity governance. Prerequisites SC-900T00: Microsoft Security, Compliance, and Identity Fundamentals AZ-104T00 - Microsoft Azure Administrator 1 - Explore identity in Microsoft Entra ID Explain the identity landscape Explore zero trust with identity Discuss identity as a control plane Explore why we have identity Define identity administration Contrast decentralized identity with central identity systems Discuss identity management solutions Explain Microsoft Entra Business to Business Compare Microsoft identity providers Define identity licensing Explore authentication Discuss authorization Explain auditing in identity 2 - Implement initial configuration of Microsoft Entra ID Configure company brand Configure and manage Microsoft Entra roles Configure delegation by using administrative units Analyze Microsoft Entra role permissions Configure and manage custom domains Configure tenant-wide setting 3 - Create, configure, and manage identities Create, configure, and manage users Create, configure, and manage groups Configure and manage device registration Manage licenses Create custom security attributes Explore automatic user creation 4 - Implement and manage external identities Describe guest access and Business to Business accounts Manage external collaboration Invite external users - individually and in bulk Demo - manage guest users in Microsoft Entra ID Manage external user accounts in Microsoft Entra ID Manage external users in Microsoft 365 workloads Implement and manage Microsoft Entra Verified ID Configure identity providers Implement cross-tenant access controls 5 - Implement and manage hybrid identity Plan, design, and implement Microsoft Entra Connect Implement manage password hash synchronization (PHS) Implement manage pass-through authentication (PTA) Demo - Manage pass-through authentication and seamless single sign-on (SSO) Implement and manage federation Trouble-shoot synchronization errors Implement Microsoft Entra Connect Health Manage Microsoft Entra Health 6 - Secure Microsoft Entra users with multifactor authentication What is Microsoft Entra multifactor authentication? Plan your multifactor authentication deployment Configure multi-factor authentication methods 7 - Manage user authentication Administer FIDO2 and passwordless authentication methods Explore Authenticator app and OATH tokens Implement an authentication solution based on Windows Hello for Business Deploy and manage password protection Configure smart lockout thresholds Implement Kerberos and certificate-based authentication in Microsoft Entra ID Configure Microsoft Entra user authentication for virtual machines 8 - Plan, implement, and administer Conditional Access Plan security defaults Plan Conditional Access policies Implement Conditional Access policy controls and assignments Test and troubleshoot Conditional Access policies Implement application controls Implement session management Implement continuous access evaluation 9 - Manage Microsoft Entra Identity Protection Review identity protection basics Implement and manage user risk policy Monitor, investigate, and remediate elevated risky users Implement security for workload identities Explore Microsoft Defender for Identity 10 - Implement access management for Azure resources Assign Azure roles Configure custom Azure roles Create and configure managed identities Access Azure resources with managed identities Analyze Azure role permissions Configure Azure Key Vault RBAC policies Retrieve objects from Azure Key Vault Explore Microsoft Entra Permissions Management 11 - Plan and design the integration of enterprise apps for SSO Discover apps by using Microsoft Defender for Cloud Apps and Active Directory Federation Services app report Configure connectors to apps Design and implement app management roles Configure preintegrated gallery SaaS apps Implement and manage policies for OAuth apps 12 - Implement and monitor the integration of enterprise apps for SSO Implement token customizations Implement and configure consent settings Integrate on-premises apps with Microsoft Entra application proxy Integrate custom SaaS apps for single sign-on Implement application-based user provisioning Monitor and audit access to Microsoft Entra integrated enterprise applications Create and manage application collections 13 - Implement app registration Plan your line of business application registration strategy Implement application registration Register an application Configure permission for an application Grant tenant-wide admin consent to applications Implement application authorization Manage and monitor application by using app governance 14 - Plan and implement entitlement management Define access packages Configure entitlement management Configure and manage connected organizations Review per-user entitlements 15 - Plan, implement, and manage access review Plan for access reviews Create access reviews for groups and apps Create and configure access review programs Monitor access review findings Automate access review management tasks Configure recurring access reviews 16 - Plan and implement privileged access Define a privileged access strategy for administrative users Configure Privileged Identity Management for Azure resources Plan and configure Privileged Access Groups Analyze Privileged Identity Management audit history and reports Create and manage emergency access accounts 17 - Monitor and maintain Microsoft Entra ID Analyze and investigate sign-in logs to troubleshoot access issues Review and monitor Microsoft Entra audit logs Export logs to third-party security information and event management system Analyze Microsoft Entra workbooks and reporting Monitor security posture with Identity Secure Score

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing