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

1341 Microsoft Office courses

SharePoint Foundation Basics

4.7(160)

By Janets

SharePoint Foundation Basics is one of our best selling and most popular course. The SharePoint Foundation Basics is organised into 6 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 5 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. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Getting started SharePoint Foundation Sites 00:20:00 Lists Announcements 00:15:00 Events 00:10:00 Link Lists 00:07:00 Task Lists 00:11:00 Contacts 00:11:00 Deleting List Items 00:12:00 Libraries Document Libraries 00:30:00 Picture Libraries 00:23:00 Wiki Pages 00:15:00 Asset Libraries 00:03:00 Form Libraries 00:08:00 Team Communication Discussion Boards 00:16:00 Surveys 00:08:00 Blog Pages 00:15:00 Views Page Views 00:14:00 Personal Views 00:11:00 Account Information and Notifications Personal and Regional Settings 00:11:00 Alerts 00:15:00 RSS Feeds 00:16:00 Mock Exam Mock Exam- SharePoint Foundation Basics 00:20:00 Final Exam Final Exam- SharePoint Foundation Basics 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

SharePoint Foundation Basics
Delivered Online On Demand5 hours 11 minutes
£25

Microsoft Excel VBA Programming Training

By Compete High

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

Microsoft Excel VBA Programming Training
Delivered Online On Demand6 hours 17 minutes
£25

Microsoft Excel Complete Training

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Microsoft Excel Complete Training
Delivered Online On Demand13 hours 3 minutes
£13.59

Excel 2019 Introduction

5.0(1)

By Course Gate

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Introduction is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Introduction is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. 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 Introduction Introduction 00:01:00 Section 01 What is Excel 00:04:00 Opening Excel 00:07:00 Navigating the Excel User Interface 00:10:00 Using the Excel Ribbon 00:07:00 Understanding Excel Worksheet Components 00:07:00 Using the Backstage View 00:09:00 Section 02 Creating a New Workbook 00:06:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using the Accessibility Checker 00:04:00 Section 03 Navigating a Worksheet by Mouse or Keyboard 00:05:00 Understanding Excel Data Types 00:06:00 Using the Inking Tools 00:06:00 Working with Cell and Range Addressing 00:03:00 Using various Data Selection Techniques 00:03:00 Working with Common Excel Commands 00:05:00 Using the Autofill Handle 00:04:00 Using Flash Fill 00:02:00 Section 04 What are Formulas and Functions 00:04:00 Understanding the Components of a Formula 00:06:00 Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Creating Basic Formulas 00:03:00 Working with Basic Functions and AutoSum 00:06:00 Using Cell References 00:05:00 Using the Quick Analysis Tools 00:03:00 Section 05 Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:04:00 Section 06 Formatting and Aligning Data 00:11:00 Merging Data 00:08:00 Wrapping Text and Adjusting Orientation 00:07:00 Formatting Numbers 00:08:00 Using Borders and Shading 00:07:00 Using the Format Painter 00:04:00 Removing Formatting Quickly 00:05:00 Section 07 Using Cell Styles 00:06:00 Applying Themes 00:04:00 Section 08 Inserting and Formatting Images 00:06:00 Inserting and Formatting Shapes 00:06:00 Inserting and Formatting SmartArt 00:09:00 Working with Icons 00:06:00 Working with 3-D Models 00:05:00 Inserting Screenshots 00:05:00 Inserting Hyperlinks 00:05:00 Inserting Symbols and Equations 00:05:00 Inserting WordArt and Text Boxes 00:08:00 Inserting Other Excel Objects 00:06:00 Arranging Objects 00:05:00 Section 09 Using Find and Replace 00:03:00 Using Go To and Go To Special 00:03:00 Using the Spell Checker 00:05:00 Using the Thesaurus and Translation Features 00:05:00 Section 10 Printing and Previewing Excel Files 00:05:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:05:00 Exporting to PDF and XPS 00:04:00 Section 11 Renaming and Coloring Worksheet Tabs 00:04:00 Adding, Deleting, and Navigating Worksheets 00:05:00 Section 12 Viewing Workbooks 00:05:00 Using Zoom Tools 00:02:00 Configuring Sheet Options 00:04:00 Using the Freeze Panes and Split Commands 00:06:00 Working with Window Commands 00:03:00 Adjusting Workbook Properties 00:06:00 Recap Recap 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Excel 2019 Introduction
Delivered Online On Demand5 hours 34 minutes
£11.99

50 Tips to Upgrade your Excel Skill

5.0(10)

By Apex Learning

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill 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 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill 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 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 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

50 Tips to Upgrade your Excel Skill
Delivered Online On Demand2 hours 57 minutes
£12

Advanced Excel Course (Formula, VLOOKUP & Power Query)

5.0(10)

By Apex Learning

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 5 sections • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00

Advanced Excel Course (Formula, VLOOKUP & Power Query)
Delivered Online On Demand2 hours 56 minutes
£12

Excel Spreadsheet for Beginner

5.0(10)

By Apex Learning

Overview This comprehensive course on Excel spreadsheet 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 spreadsheet 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 spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet 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 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Excel Spreadsheet for Beginner
Delivered Online On Demand1 hour 29 minutes
£12

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

5.0(10)

By Apex Learning

Overview This comprehensive course on Excel Pivot Tables, Pivot Charts, Slicers, and Timelines will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 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 Pivot Tables, Pivot Charts, Slicers, and Timelines. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 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 2 sections • 15 lectures • 01:21:00 total length •Getting started with your Pivot Table: 00:04:00 •Drill Down: 00:01:00 •Managing the Field List: 00:02:00 •Changing the Calculation type with Value Field Settings: 00:06:00 •Growing your Pivot Table with Multiple Fields: 00:04:00 •Formatting the Pivot Table: 00:05:00 •Sorting and Filtering the Pivot Table: 00:03:00 •Creating a Dashboard with Slicers, Timelines and Pivot Charts: 00:09:00 •Reporting by day, month, qtr, or year within the Pivot Table: 00:04:00 •Refreshing the Pivot Data with new data: 00:03:00 •Adding your own calculations into the Pivot Table: 00:03:00 •The power of the Filter Section in the Pivot Table: 00:04:00 •PowerQuery: 00:12:00 •PowerPivot: 00:21:00 •Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines: 00:00:00

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Delivered Online On Demand1 hour 21 minutes
£12

Excel Must know Formulas and Functions

5.0(10)

By Apex Learning

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions 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 Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions 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 2 sections • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

Excel Must know Formulas and Functions
Delivered Online On Demand1 hour 53 minutes
£12

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!

5.0(10)

By Apex Learning

Overview This comprehensive course on Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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 Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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 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 2 sections • 23 lectures • 01:56:00 total length •Excel promo: 00:01:00 •Getting the most of the course: 00:01:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:06:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!: 00:00:00

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Delivered Online On Demand1 hour 56 minutes
£12