• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5666 Courses

Data Analysis In Excel

5.0(1)

By Course Gate

Data Analysis In Excel is suitable for anyone aspiring to or already working in this field or simply want to learn deeper into data analysis. You will be able to add this qualification to your CV by downloading your certificate instantly without any cost. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into the bite-size module for your convenience. You can study at your own pace or become accredited within hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. This Data Analysis In Excel aims to introduce Data Analysis in Excel 2016. You'll learn the best way to enter and organize data, sort and map data, perform calculations with simple functions, format the appearance of your data and cells, and build charts and PivotTables for data analysis. You will know how to validate data, search and remove invalid data. The course covers Lookup information using VLOOKUP, and INDEX-MATCH, data forecasting and cleansing, providing external and 3D references and inserting sparklings, so that you have a great foundation in the world's most popular spreadsheet programme. Finally, you will learn different features to visualise or analyse your data in the most convenient way, which allows you to take the right business decisions for your company Who is this Course for? Data Analysis In Excel is 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 Data Analysis In Excel 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Data Analysis In Excel
Delivered Online On Demand4 hours 58 minutes
£11.99

Business Applications

By Nexus Human

Duration 4.5 Days 27 CPD hours This course is intended for This course is intended for individuals who want to gain basic knowledge of business skills. Overview Upon successful completion of this course, students will be able to communicate and work effectively in a business environment. In this course, students will learn about all different aspects of business skills needed be effective in an office environment. Accessing PDF Documents Open a PDF Document Browse a PDF Document Creating & Saving PDF Documents Create and Save a PDF Document from an Existing Document Create a PDF Document from a Web Page Combine Multiple PDF Documents Navigating Content in a PDF Document Perform a Search in a PDF Document Search Multiple PDF Documents Work with Bookmarks Create Links and Buttons Modifying PDF Documents Manipulate PDF Document Pages Edit Content in a PDF Document Add Page Elements Reviewing PDF Documents Add Comments and Markup Compare PDF Documents Initiate and Manage a Review Converting PDF Files Reduce the File Size of a PDF Document Optimize PDF Files Convert and Reuse PDF Document Content Customizing the Acrobat XI Pro Workspace Customize the Toolbars Customize the Tool Sets Creating PDFs from Technical Documents Create PDF Documents Using Autodesk AutoCAD Measure Technical Drawings Enhancing PDF Documents Embed Multimedia Enhance PDF Document Accessibility Securing PDF Documents Manage the Security of PDF Documents Validate PDF Documents Creating Interactive PDF Forms Create a PDF Form Compile and Manage PDF Form Data Finalizing PDF Files for Commercial Printing Apply Color Management Settings Preview Printed Effects Perform Preflight on a PDF Document Create PDF/X, PDF/A, and PDF/E Compliant Files Create a Composite and Color Separations Accessing & Navigating SharePoint Team Sites Access SharePoint Sites Navigate SharePoint Sites Working with Documents, Content, & Libraries Upload Documents Search for Documents and Files Working with Lists Add List Items Modify List Items Configure List Views Filtering and Grouping with List Views Configuring Your SharePoint Profile Update and Share Your Profile Information Share and Follow SharePoint Content Creating a Blog Integrating with Microsoft Office Access and Save SharePoint Documents with Microsoft Office Manage Document Versions through Office 2013 Accessing SharePoint Data from Outlook 2013 Working Offline & Remotely with SharePoint Synchronize Libraries, Sites, and MySite and Working Offline Working from a Mobile Device Creating a New Site Create a Site Change the Look and Feel of Your SharePoint Site Adding & Configuring Libraries Configure Document Library for Your SharePoint Team Site Configure the Site Assets Library for Your SharePoint Site Add and Configure a Wiki for Your SharePoint Site Adding & Configuring Lists Add an Announcement List Add and Configure a Task List Add and Configure Contact and Calendar Lists Add and Configure a Blog Subsite Add and Configure a Custom List to your SharePoint Site Customize List Forms Configuring Site Settings, Navigation, & Search Configure Site Search Options Configure Site Administration Settings Configure Site Organization and Navigation Assigning Permissions & Access Rights Sharing Sites and Setting Site Permissions Secure Lists, Libraries, and Documents Configure Content Roll-Up, Summary Links, & Site Map Add and Configure the Content Search Web Part Add and Configure the Relevant Documents Web Part Identifying Nouns, Pronouns, & Verbs Identify Nouns Identify Pronouns Identify Verbs Identifying Adjectives & Adverbs Use Adjectives Use Adverbs Indentifying Prepositions, Conjunctions, and Interjections Use Prepositions Use Conjunctions Use Interjections Identifying Rules Monitor Sentences Monitor Modifiers Avoid Common Errors Identifying Correct Punctuation Use Parentheses Correctly Use Commas, Semicolons, and Quotation Marks Use Numbers, Symbols, and Capitalization Correctly Identifying Sentence Fragments, Run-Ons, and Comma Splices Identify Sentence Fragments Identify Run-ons, Comma Splices, and Solutions Improving Word Choices Identify Commonly Misused Words Identify Synonyms, Antonyms, and Homonyms Building Effective Sentences Identify the Goal Consider the Audience Consider the Context Editing Effectively Use Correct Spelling Achieve Clarity Avoiding Hypercorrections Avoid Hypercorrections Achieve Simplicity Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives Working with Words Spelling Grammar Creating a Cheat Sheet Constructing Sentences Parts of a Sentence Punctuation Types of Sentences Creating Paragraphs The Basic Parts Organization Methods Writing Meeting Agendas The Basic Structure Choosing a Format Writing the Agenda Writing E-Mails Addressing Your Message Grammar and Acronyms Writing Business Letters The Basic Structure Choosing a Format Writing the Letter Writing Proposals The Basic Structure Choosing a Format Writing the Proposal Writing Reports The Basic Structure Choosing a Format Be guided by the: The purpose of the report The seniority of your readers Writing the Report Other Types of Documents Requests for Proposals Projections Executive Summaries Business Cases Proofreading & Finishing A Proofreading Primer How Peer Review Can Help Printing and Publishing Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations E-Mail Basics E-mail characteristics Writing online versus on paper Understanding the advantages and disadvantages of e-mail Understanding the cultural significance of e-mail E-mail programs Using an e-mail program to send e-mail When to use e-mail Communicating by e-mail Understanding when to avoid using e-mail Writing an e-mail message Using the MAIL acronym E-Mail Policies Company policies Avoiding improper e-mail messages Ensuring employee compliance to e-mail policies Copyright laws, viruses, and liability Avoiding copyright infringement Avoiding viruses Identifying e-mail liability E-Mail Features & Security Features of an e-mail program Using attachments Using priority labels and signature files Features of an e-mail program Using attachments Using priority labels and signature files Discussing e-mail program options Securing e-mail Usi Additional course details: Nexus Humans Business Applications 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 Business Applications 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.

Business Applications
Delivered OnlineFlexible Dates
Price on Enquiry

Control and Administration of Medication

By IOMH - Institute of Mental Health

Overview of Control and Administration of Medication Join our Control and Administration of Medication course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Control and Administration of Medication course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Control and Administration of Medication course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This Control and Administration of Medication Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Control and Administration of Medication. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Control and Administration of Medication course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Control and Administration of Medication is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Control and Administration of Medication course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Control and Administration of Medication Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Introduction to Control and Administration of Medication Introduction to Control and Administration of Medication 00:16:00 Module 02: Legislation and Regulations Legislation and Regulations 00:20:00 Module 03: Medication Safety Medication Safety 00:18:00 Module 04: Safe Handling of Medication Safe Handling of Medication 00:18:00 Module 05: Safe Administration of Medication Safe Administration of Medication 00:15:00 Module 06: Prescribing Medication Safely Prescribing Medication Safely 00:16:00 Module 07: Different Types of Medication Different Types of Medication 00:18:00 Module 08: Supply, Storage and Disposal Supply, Storage and Disposal 00:15:00 Module 09: Documentation and Record Keeping Documentation and Record Keeping 00:17:00

Control and Administration of Medication
Delivered Online On Demand2 hours 33 minutes
£11

Machine Learning with Python

5.0(10)

By Apex Learning

Overview This comprehensive course on Machine Learning with Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Machine Learning with Python comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Machine Learning with Python. It is available to all students, of all academic backgrounds. Requirements Our Machine Learning with Python is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications 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. Course Curriculum 4 sections • 21 lectures • 01:34:00 total length •Introduction to types of ML algorithm: 00:02:00 •SVM - Python Implementation: 00:06:00 •Introduction to types of ML algorithm: 00:02:00 •Importing a dataset in python: 00:02:00 •Resolving Missing Values: 00:06:00 •Managing Category Variables: 00:04:00 •Training and Testing Datasets: 00:07:00 •Normalizing Variables: 00:02:00 •Normalizing Variables - Python Code: 00:03:00 •Summary: 00:01:00 •Simple Linear Regression - How it works?: 00:04:00 •Simple Linear Regreesion - Python Implementation: 00:07:00 •Multiple Linear Regression - How it works?: 00:01:00 •Multiple Linear Regression - Python Implementation: 00:09:00 •Decision Trees - How it works?: 00:05:00 •Random Forest - How it works?: 00:03:00 •Decision Trees and Random Forest - Python Implementation: 00:04:00 •kNN - How it works?: 00:02:00 •kNN - Python Implementation: 00:10:00 •Decision Tree Classifier and Random Forest Classifier in Python: 00:10:00 •SVM - How it works?: 00:04:00

Machine Learning with Python
Delivered Online On Demand1 hour 34 minutes
£12

Data Analysis and Forecasting in Excel

5.0(10)

By Apex Learning

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

Data Analysis and Forecasting in Excel
Delivered Online On Demand4 hours 43 minutes
£12

Excel Data Analysis for Beginner

5.0(10)

By Apex Learning

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

Excel Data Analysis for Beginner
Delivered Online On Demand1 hour 11 minutes
£12

Practical and Passionate Product Ownership

By IIL Europe Ltd

Practical and Passionate Product Ownership Agile product ownership is arguably the most important work leading to successful product outcomes. Product owners need to be inventive, yet intensely focused; collaborative, yet decisive; far-sighted, yet detail-oriented. Learn key practices, aptitudes, and attitudes of successful product owners. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Practical and Passionate Product Ownership
Delivered Online On Demand30 minutes
£15

Complete Microsoft Excel

4.7(26)

By Academy for Health and Fitness

Are you looking to improve your current abilities or make a career move? Our unique Complete Microsoft Excel Course might help you get there! Expand your expertise with high-quality training - study the Complete Microsoft Excel and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Complete Microsoft Excel online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Complete Microsoft Excel course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The Complete Microsoft Excel course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the Complete Microsoft Excel course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Why Prefer this Complete Microsoft Excel Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Complete Microsoft Excel course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: >> Complete Microsoft Excel << Module 01: Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Module 02: Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Module 03: Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Module 04: Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Module 05: Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Module 06: Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Module 07: Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 08: Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Module 09: Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Module 10: Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Module 11: Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Module 12: Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Module 13: Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Module 14: Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Module 15: Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Module 16: Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Module 17: Creating Sparklines and Mapping Data Create Sparklines MapData Module 18: Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Module 19: Excel Templates Excel Templates Assessment Process Once you have completed all the modules in the Complete Microsoft Excel course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Complete Microsoft Excel
Delivered Online On Demand11 hours
£12

Microsoft Excel from A-Z: Beginner to Expert

4.7(26)

By Academy for Health and Fitness

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Microsoft Excel course might help you get there! Expand your expertise with high-quality training - study the Microsoft Excel course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Microsoft Excel online training course. The Microsoft Excel course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Microsoft Excel course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Microsoft Excel training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover in the Course: >> Microsoft Excel - Beginner, Intermediate & Advanced << Unit 01: Excel from A-Z Course Introduction Unit 02: Getting Started With Excel Unit 03: Values, Referencing and Formulas Unit 04: Intro to Excel Functions Unit 05: Adjusting Excel Worksheets Unit 06: Visually Pleasing Cell Formatting Unit 07: How to Insert Images and Shapes! Unit 08: Visualize Data with Charts Unit 09: Excel's Printing Options Unit 10: Benefits of Using Excel Templates Unit 11: Working with Excel Datasets Unit 12: Excel Database Functions Unit 13: Excel Data Validation Unit 14: Excel PivotTables Unit 15: Excel's PowerPivot Add-In Unit 16: Excel's Conditional Functions Unit 17: Excel's Lookup Function Unit 18: Text Based Functions in Excel Unit 19: Auditing Formulas and Views in Excel Unit 20: Excel's 'what If?' Tools Unit 21: Welcome to Excel VBA Unit 22: The VBA Language Unit 23: Writing VBA Code Unit 24: Important VBA Tools and Logic Unit 25: Excel VBA Lopps Unit 26: Triggering Macros Unit 27: Excel User Forms Unit 28: Starting a Career in Excel Tutor Support Once you enrol in our Microsoft Excel Course with the Academy for Health & Fitness, you are allocated your tutor. The tutor's guidance and assistance will be available throughout your studies with the college. He/ she will evaluate your work and will provide you with regular feedback on your progress. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Microsoft Excel course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Microsoft Excel from A-Z: Beginner to Expert
Delivered Online On Demand13 hours
£12

Junior Administrator Training

4.7(26)

By Academy for Health and Fitness

Are you looking to improve your current abilities or make a career move? Our unique Junior Administrator Course might help you get there! Expand your expertise with high-quality training - study the Junior Administrator and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this training course in around 7 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Junior Administrator course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on this course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Learning Outcomes: Instant access to verified and reliable information Participation in inventive and interactive training exercises Quick assessment and guidance for all subjects CPD accreditation for proof of acquired skills and knowledge Freedom to study in any location and at a pace that suits you Expert support from dedicated tutors committed to online learning Experts created the Junior Administrator course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this Junior Administrator course and take a step toward a brighter future! Why Prefer this Junior Administrator Course? Opportunity to earn a certificate accredited by CPD Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support ****Course Curriculum**** ***Junior Administrator*** Module 1: Introduction to Office Administration Module 2: Skills of an Effective Administrator Module 3: Business Etiquette Module 4: Business Telephone Skills Module 5: Representing Your Boss and Company Module 6: Organising Meeting and Conferences Module 7: Time Management Module 8: Record Keeping and Filing Systems Module 9: Business Writing Skills Module 10:Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning and Scheduling Assessment Process Once you have completed all the modules in the course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about this subject should take this Junior Administrator course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The program does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Junior Administrator course allows you to study at your own speed and grow a quality skillset. Career path After completing this course, you are to start your career or begin the next phase of your career in this field. Our entire course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Junior Administrator Training
Delivered Online On Demand7 hours
£12