3167 Microsoft courses in Ince-in-Makerfield delivered Online

Boost your administrative career with our Data Entry Administration & Office Admin Assistant Course, designed to sharpen your accuracy, organisation, and digital communication skills. Covering everything from data documentation and email writing to Microsoft Office and Power BI, this course offers structured content to build confidence and capability in a wide range of office-based responsibilities. Whether you're aiming to work in corporate support or manage day-to-day administrative duties, each module is designed to help you develop a polished, efficient, and professional approach to your role. From GDPR awareness to workplace productivity, negotiation, and business writing, you'll be guided through essential areas of office administration. The course also includes customer service training, minute taking, strategic business management, and much more—giving you insight into what today’s employers expect from office professionals. If you're looking to refine your administrative skill set with a focus on clarity, precision, and digital tools, this course offers a structured path forward, taught entirely online with flexibility in mind. Key Features: CPD Certified Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases This bundle consists of the following courses: Course 01: Efficient Data Entry Course Course 02: Basic Data Analysis Course 03: Data Documentation and Record Keeping Course 04: Data Analytics Course 05: Google Data Studio: Data Analytics Course 06: General Data Protection Regulation (GDPR) Awareness Course 07: Cyber Security Training Course 08: Workplace Confidentiality Course 09: Security Management Diploma Course 10: Executive PA (Admin, secretarial & PA) Course 11: Office Skills and Administration Course 12: Email Writing Course 13: Workplace Productivity Course 14: Corporate Compliance and Risk Management Course 15: Minute Taking Course 16: Touch Typing Course 17: Microsoft Office Course 18: Microsoft Power BI Course 19: Strategic Business Management Course 20: Business Analyst Training Course 21: Business Writing Course 22: Business Etiquette Course 23: Basic Business Finance Course 24: Facilities Management Diploma Course 25: Customer Service Training Course 26: Presentation skills Course 27: Hospitality Management and Front Office Operations Course 28: Workplace Professionalism Certificate Course Course 29: Negotiation Skills Course 30: Product Management Learning Outcomes: Master efficient data entry and documentation for accurate record-keeping. Analyse basic data to derive meaningful insights. Implement GDPR principles and ensure workplace confidentiality. Enhance office administration skills, including minute taking and touch typing. Develop strategic business management and business analysis capabilities. Improve presentation and email writing skills for effective communication. Accreditation All of our courses, including this course are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Course, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring office administrators and executive PAs. Individuals seeking to improve workplace productivity. Professionals interested in data analytics and documentation. Those aiming for careers in business management. Employees looking to enhance customer service skills. Career path Office Administrator Executive PA Data Analyst Compliance Officer Customer Service Manager Business Analyst Certificates Certificate of completion Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Certificate of completion Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

***24 Hour Limited Time Flash Sale*** Accountancy at QLS Level 5 Diploma Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Accountancy at QLS Level 5 Diploma Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Accountancy at QLS Level 5 Diploma bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Accountancy at QLS Level 5 Diploma Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Accountancy at QLS Level 5 Diploma Career Bundle: Course 01: Accountancy at QLS Level 5 Diploma Course 02: Managerial Accounting Training Course 03: Applied Accounting Course: Mastering Financial Management Course 04: Payroll: Payroll Management Course 05: Xero Accounting - Complete Training Course 06: Sage 50 Accounts Course 07: Making Budget & Forecast Course 08: Cost Control Process and Management Course 09: Anti-Money Laundering (AML) Course 10: Corporate Finance: Working Capital Management Course 11: Level 4 Diploma Accounting and Business Finance Course 12: Financial Modelling for Decision Making and Business plan Course 13: Financial Accounting Course 14: Tax Accounting Diploma Course 15: Commercial Law Course 16: Introduction to VAT Online Training Course 17: Microsoft Excel Training: Depriciation Accounting Course 18: Concept of Charity Accounting Course 19: Understanding Financial Statements and Analysis Course 20: Finance Assistant Training: Level 1 & 2 Certification Course 21: Negotiation Skills Certificate Course 22: Document Control Course 23: Advanced Diploma in Microsoft Excel Course 24: Online Time Management Training Course 25: Risk Assessment & Management With Level 7 in Strategic Learning & Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Accountancy at QLS Level 5 Diploma today and take the first step towards achieving your goals and dreams. Why buy this Level 7 in Strategic Learning & Development? Free CPD Accredited Certificate upon completion of Level 7 in Strategic Learning & Development Get a free student ID card with Level 7 in Strategic Learning & Development Lifetime access to the Accountancy at QLS Level 5 Diploma course materials Get instant access to this Accountancy at QLS Level 5 Diploma course Learn Accountancy at QLS Level 5 Diploma from anywhere in the world 24/7 tutor support with the Accountancy at QLS Level 5 Diploma course. Start your learning journey straightaway with our Accountancy at QLS Level 5 Diploma Training! Accountancy at QLS Level 5 Diploma premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Accountancy at QLS Level 5 Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Accountancy at QLS Level 5 Diploma course. After passing the Accountancy at QLS Level 5 Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Accountancy at QLS Level 5 Diploma course is ideal for: Students seeking mastery in Level 7 in Strategic Learning & Development Professionals seeking to enhance Accountancy at QLS Level 5 Diploma skills Individuals looking for a Level 7 in Strategic Learning & Development-related career. Anyone passionate about Level 7 in Strategic Learning & Development Requirements This Accountancy at QLS Level 5 Diploma doesn't require prior experience and is suitable for diverse learners. Career path This Accountancy at QLS Level 5 Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Duration 2 Days 12 CPD hours This course is intended for This is an Intermediate PowerBI course geared for experienced users who wish to leverage the tool's more advanced capabilities Overview This course is about 50% hands-on lab and 50% lecture, designed to train attendees in essential PowerBI data handling functions and reporting skills, coupling the most current, effective techniques with the soundest practices. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses. Working in a hands-on learning environment led by our expert facilitator, students will learn how to: Create Advanced Power BI Reports Advanced understanding of the data schemas and extracting data Perform advanced transformations of data or any data schema Utilize time-phased data in the creation of complex analyses Create new measures using DAX Filter data using row-level security Create and deploy content packs Use Power BI to integrate with line-of-business applications Next Level Power BI for Experienced Users is a two day, course that provides attendees already experienced with Microsoft Power BI basics with a hands-on exploration of intermediate and beyond level features. This course is geared for attendees ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise?s other line-of-business tools. Get Project Online Data Select and mine relevant tables with ODATA Advanced ODATA data mining Importing other data formats Advanced Editing of data queries Advanced Data Transformations Managing table relationships Creating & using data hierarchies Creating custom columns and measures and metrics for filtering and reporting Creating Power BI Reports Using advanced visualizations Configuring drill-down Modifying visual interactions Importing and creating custom visuals Configure Power BI Security Creating Dashboard and row-level security Utilizing Filtering using row-level security Publishing Reports and Dashboards Building Mobile Reporting Creating and deploying content packs Configuring natural language query

In the UK, the starting salary for jobs involving data entry is normally between £25,000 and £28,000 annually. But in a junior position, you might make between £40,000 and £50,000 if you have some experience. Furthermore, if you work in a senior job and have a lot of expertise, you may make over £65,000. Our Data Entry training equips you with precise knowledge and abilities to become a Data Entry specialist. If you have a strong knack for accuracy, the ability to work under pressure, and outstanding keyboarding skills, you might want to choose a job in data entry. A job in data entry can lead you into many other areas because companies from a variety of industries hire for these Data Entry Administrator roles. You will have improved your employability and equipped yourself with the skills you need to keep ahead of the competition by the time you finish this Data Entry course. Additionally, by making your resume stand out to potential employers, the course will offer it a little extra edge over the competition. Thus, why do you delay? Enroll right now in the course! Key Features: This Data Entry Clerk Course is CPD Certified Free Certificate Developed by Specialist Lifetime Access Course Curriculum: Data Entry Clerk Level 3 Advanced Diploma Module 01: Basic Data Input and Key Tools Module 02: Entering Data Using Microsoft Word Module 03: Data Input with Microsoft Excel Module 04: Enhanced Data Input Methods and Tools Module 05: Best Practices for Data Input Accuracy Module 06: Developing Your Data Input Career and Portfolio Learning Outcomes: Data Entry Clerk Level 3 Advanced Diploma Understand data entry fundamentals and essential tools for efficiency. Demonstrate proficient data entry skills using Microsoft Word. Apply advanced data entry techniques proficiently in Microsoft Excel. Utilize advanced tools for efficient and accurate data entry tasks. Implement best practices to ensure accuracy in data entry work. Develop a professional portfolio and strategies for advancing data entry career. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data Entry Clerk Level 3 Advanced Diploma course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Data Entry Clerk Level 3 Advanced Diploma. Moreover, this course is ideal for: Individuals seeking advanced data entry skills. Professionals aiming to enhance data entry proficiency. Students aspiring to pursue a career in data entry. Anyone interested in improving data entry accuracy and efficiency. Individuals looking to build a career in administrative roles. Requirements There are no requirements needed to enrol into this Data Entry Clerk Level 3 Advanced Diploma course. We welcome individuals from all backgrounds and levels of experience to enrol into this Data Entry Clerk Level 3 Advanced Diploma course. Career path After finishing this Data Entry Clerk course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Data Entry Clerk are: Database Administrator - £25K to £35K/year Data Entry Clerk - £18K to £25K/year Administrative Assistant - £18K to £23K/year Office Administrator - £20K to £25K/year Data Analyst - £22K to £30K/year Executive Assistant - £25K to £35K/yr Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced Training on Windows 10 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced Training on Windows 10 Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Training on Windows 10 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced Training on Windows 10 Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Training on Windows 10 ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced Training on Windows 10 there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced Training on Windows 10 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced Training on Windows 10 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Advanced Training on Windows 10 was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced Training on Windows 10 is a great way for you to gain multiple skills from the comfort of your home. Advanced Training on Windows 10 Lesson 01: Overview 00:01:00 Lesson 02: Managing Start-Up Speed 00:02:00 Lesson 03: Managing Open Applications 00:02:00 Lesson 04: Managing Your Hard Drive Space 00:03:00 Lesson 05: Managing Your Hard Drive Space - Storage Sense 00:01:00 Lesson 06: Managing Frozen Applications 00:02:00 Lesson 07: Managing Your PC Remotely Part 1 00:03:00 Lesson 08: Managing Your PC Remotely Part 2 00:02:00 Lesson 09: Managing Desktop Notifications - Focus Assist 00:02:00 Lesson 10: Linking Your Mobile Device 00:01:00 Lesson 11: Managing Your Backups and Restore Points 00:02:00 Lesson 12: Managing Your Default Applications 00:03:00 Lesson 13: Managing Your Workspace 00:02:00 Lesson 14: Microsoft Edge - Write Notes 00:02:00 Lesson 15: Managing Edge - Dot Menu 00:02:00 Lesson 16: Managing Edge - Settings Menu Link 00:02:00 Lesson 17: Managing Edge With Cortana 00:02:00 Lesson 18: Managing Default Applications with Edge 00:02:00 Lesson 19: Managing Lost Windows 00:02:00 Lesson 20: Conclusion 00:02:00

Give a compliment to your career and take it to the next level. This CV Writing and Interview Skills Training Will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this CV Writing and Interview Skills Training Bundle will help you stay ahead of the pack. Throughout the CV Writing and Interview Skills Training Programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this CV Writing and Interview Skills Training Course, you will get 11 premium courses, an originalHardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This CV Writing and Interview Skills Training Bundle Consists of the following Premium courses: Courses are included in this CV Writing and Interview Skills Training Bundle? Course 01: Certificate in CV Writing and Interview Skills Course 02: Office Skills Course 03: Virtual Interviewing for HR Course 04: Minute Taking Essentials Level 2 Course 05: Course 06: Document Control Course 07: MS Word Diploma Course 08: Microsoft Excel Level 3 Course 09: PowerPoint Diploma Course 10: Microsoft Teams Course 11: Public Speaking and Presentation Skill Course Enrol now in CV Writing and Interview Skills Training 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 CV Writing and Interview Skills Training Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this CV Writing and Interview Skills Training. It is available to all students, of all academic backgrounds. Requirements Our CV Writing and Interview Skills Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having this CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. 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 (Certificate in CV Writing and Interview Skills) 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.

***24 Hour Limited Time Flash Sale*** English for Literacy and Language Teaching Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive English for Literacy and Language Teaching Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our English for Literacy and Language Teaching bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in English for Literacy and Language Teaching Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this English for Literacy and Language Teaching Career Bundle: Course 01: English Literature Course 02: An Introduction to British and American Literature Search Course 03: Comparative Literature Course 04: Medieval History Course 05: Social Science Diploma Course 06: Level-3 English Grammar Course Course 07: English: Spelling, Punctuation, and Grammar Course 08: Essay Writing in English Course 09: Creative Writing Course: Writing Storybooks For Children Course 10: Creative Writing Course - Fiction Course 11: Creative Writing Course - Novel Course 12: Novel Writing and Publishing Course 13: 200 Common English Idioms and Phrases Course 14: Content Management Course 15: Copyediting & Proofreading Course 16: Information Management Course 17: Data Management Training Course 18: Document Control Course 19: ICT: Information and Communication Technology Course 20: GDPR Course 21: Administrative Management Course 22: Data Entry Administrator Course 23: New Functions in Microsoft Excel Course 24: Functional Skills IT Course 25: Complete Communication Skills Master Class Course 26: Goal Setting Course 27: Touch Typing Course 28: Computer Operating System and Troubleshooting Course 29: Microsoft Access Databases Forms and Reports Course 30: ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! With English for Literacy and Language Teaching, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in English for Literacy and Language Teaching today and take the first step towards achieving your goals and dreams. Why buy this English for Literacy and Language Teaching? Free CPD Accredited Certificate upon completion of English for Literacy and Language Teaching Get a free student ID card with English for Literacy and Language Teaching Lifetime access to the English for Literacy and Language Teaching course materials Get instant access to this English for Literacy and Language Teaching course Learn English for Literacy and Language Teaching from anywhere in the world 24/7 tutor support with the English for Literacy and Language Teaching course. Start your learning journey straightaway with our English for Literacy and Language Teaching Training! English for Literacy and Language Teaching premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the English for Literacy and Language Teaching is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the English for Literacy and Language Teaching course. After passing the English for Literacy and Language Teaching exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This English for Literacy and Language Teaching course is ideal for: Students seeking mastery in English for Literacy and Language Teaching Professionals seeking to enhance English for Literacy and Language Teaching skills Individuals looking for a English for Literacy and Language Teaching-related career. Anyone passionate about English for Literacy and Language Teaching Requirements This English for Literacy and Language Teaching doesn't require prior experience and is suitable for diverse learners. Career path This English for Literacy and Language Teaching bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist

Duration 2 Days 12 CPD hours This course is intended for The audience for this course is an AWS Sysops Administrator Associate or equivalent. This person has one to two years of experience in AWS deployment, management, and operations. Students taking this course are interested in learning how Azure is different from AWS, and how Azure is administered. Students may also be interested in taking the AZ-103 Microsoft Azure Administrator certification exam, or the AZ-900 Azure Fundamentals exam. This two-day course is designed for AWS Sysops administrators interested in learning how Azure is administered. In this workshop which combines lecture with hands-on practical exercises and discussion/review, you will be introduced to Azure Administration, Azure Networking, Azure Compute, Azure Storage, and Azure Governance. During the workshop, you will apply this knowledge - building end-to-end architecture that demonstrates the main features discussed. Azure Administration In this module, you?ll learn about the tools and principle concepts needed to administer Azure. Topics include: Resource Manager, Resource Groups, Azure Portal, Azure CLI, Azure Templates, Cloud Shell, Azure Marketplace, and Azure PowerShell. Azure Networking In this module, you?ll learn about Azure networking features. Topics include: Azure Regions, Virtual Networks and Subnets, IP Addressing, Network Security Groups, Virtual Network Peering, VNet-to-VNet Connections, ExpressRoute, Load Balancers, and Network Watcher. Azure Compute In this module, you?ll learn about configuring and monitoring Azure virtual machines. Topics include: Azure Virtual Machines, Creating Virtual Machines, Virtual Machine Sizes, Virtual Machine Disks, Availability Zones, Availability Sets, Windows VM Connections, Linux VM Connections, Azure Monitor, and Azure Alerts. Azure Storage In this module, you?ll learn about Azure storage features and implementation. Topics include: Storage Accounts, Blob Storage, Blob Performance Tiers, File Shares, File Sync, Data Box, Content Delivery Network, Shared Access Signatures, and Service Endpoints. Azure Identity In this module, you?ll learn about Azure identity solutions. Topics include: Azure Domains, Role-based Access Control, Azure Active Directory, Multi-Factor Authentication, Azure AD Identity Protection, and Azure Policy. Additional course details: Nexus Humans AZ-010T00 Azure Administration for AWS SysOps 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 AZ-010T00 Azure Administration for AWS SysOps 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.

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel