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

3082 Office Skills courses in Cardiff delivered On Demand

Microsoft Excel for Beginners

By iStudy UK

Are you having trouble showcasing your data in important presentations? Then Microsoft Excel is useful software you can use to solve your problem. If you want to learn the complete guide on how to become a professional user on Microsoft Excel, then this is the course for you. With Excel, you can manage more data than ever, with increased worksheet and workbook sizes. Build great charts, use conditional formatting, help identify the trends and bring data together by using Excel. Gain access to new features such as sparklines, improved pivot tables, slicer, Access spreadsheets from anywhere and much more. Course Highlights Microsoft Excel for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 12 hours, 10 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel for Beginners is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel for Beginners CPD & IAO Accredited 00:20:00 Final Exam Final Exam- Microsoft Excel for Beginners CPD & IAO Accredited 00:20:00

Microsoft Excel for Beginners
Delivered Online On Demand12 hours 10 minutes
£25

Microsoft Office 2016 Excel VBA

By iStudy UK

This Microsoft Office 2016 Excel VBA is designed to introduce you to VBA in as non-threatening a manner as possible. Beginning with wizards and macros, you will get through the methods and syntax of simple programming in VB, culminating in writing custom code, customizing Excel elements and debugging. In this course you will learn automation, styles, version tracking and mail merge, macros, customizing and tailor Word to suit your workflow, and more. You will gain confidence in using the more esoteric features of Word to create efficient long documents. Course Highlights Microsoft Office 2016 Excel VBA is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Office 2016 Excel VBA into 19 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Office 2016 Excel VBA Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Office 2016 Excel VBA is CPD Qualification Standards and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Office 2016 Excel VBA is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Developing Macros Create a Macro Using the Macro Recorder FREE 01:00:00 Edit a Macro FREE 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Formatting Worksheets Using Macros Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel VBA 00:00:00 Mock Exam Final Exam

Microsoft Office 2016 Excel VBA
Delivered Online On Demand11 hours 30 minutes
£25

Microsoft Excel 2007 Advanced Level

By iStudy UK

Are you ready to learn all about Microsoft Excel 2007? In our online course, you'll learn how to classify and filter data along with creating formulas that link to other workbooks. You will also find out how to set up and modify advanced charts. Take your knowledge of this versatile application to the higher level with this advanced course. Our expert instructors will help you demystify some of the most challenging formulas and functions in Excel 2007 and explain to you how to put them to their best use. They will help you start with a review of the more primary, building-block functions, and some of the important keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Course Highlights Microsoft Excel 2007 Advanced Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel 2007 Advanced Level into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel 2007 Advanced Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel 2007 Advanced Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel 2007 Advanced Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel 2007 Advanced Level 00:20:00

Microsoft Excel 2007 Advanced Level
Delivered Online On Demand11 hours 40 minutes
£25

Accredited Diploma in Microsoft Excel 2007

By iStudy UK

Microsoft Office Excel is a great tool used to create and format spreadsheets. Spreadsheets allow you to organise information in rows and tables and analyse it with automatic mathematics. Spreadsheets are also very commonly used to perform various types of calculations. Regardless of whether you are completely new to Excel or upgrading from an older version, this Excel 2007 course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of experience, knowledge and teaching techniques to create an easy-to-use course that can be customised to meet your personal learning needs.  Course Highlights Accredited Diploma in Microsoft Excel 2007 is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Diploma in Microsoft Excel 2007 into 26 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 22 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Diploma in Microsoft Excel 2007 Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Diploma in Microsoft Excel 2007 is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Diploma in Microsoft Excel 2007 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2007 for Beginners 00:00:00 Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Final Exam

Accredited Diploma in Microsoft Excel 2007
Delivered Online On Demand22 hours 30 minutes
£25

Professional Certificate in Understanding Cost System and its Classification in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

The course explores the nature and behaviour of cost in an organization and the approaches used to report and manage it. The course aims to equip the learner with an understanding of the essential terminologies and concepts used in costing so that the learner is able to identify costs, interpret the related information and use the costing information in decision making. After the successful completion of this lecture, you will be able to understand the following: The concept of the Costing System. Various types of costing systems. Different classification of cost. Various cost control of systems. Calculation of cumulative cost variance. Various strategies of pricing policy. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding cost system and its classification Quiz: Understanding Cost System And Its Classification Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the knowledge of the learner in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Cost Control Manager Finance Manager Operatons Manager Organizational Behaviour Specialist Financial Analyst Team Lead Average Completion Time 2 Weeks Accreditation 1 CPD Hour Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate in Understanding Cost System and its Classification in London 2024
Delivered Online On Demand14 days
£35

PowerPoint Presentation

By The Teachers Training

Overview PowerPoint Presentation Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this PowerPoint Presentation Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Unit 01- Introduction And Welcome Introduction 00:03:00 Unit 02 - Map Out Your Massage Map Out Your Massage Introduction 00:14:00 Prepare Your Opening Slides 00:09:00 Prepare Your Opening Slides Activity 00:04:00 Prepare Your Core Content Slides 00:15:00 Prepare Your Core Content Slides Activity 00:04:00 Prepare Your Closing Slides 00:06:00 Prepare Your Closing Slides Activity 00:05:00 Unit 03 - Add Variety To Your Visuals Add Variety To Your Visuals Intro 00:06:00 Use Pictures To Add Impact 00:17:00 Use Pictures To Add Impact Activity 00:04:00 Keep Graphics Simple 00:07:00 Keep Graphics Simple Activity 00:03:00 Use Illustrations To Increase Comprehension 00:07:00 Use Illustrations To Increase Comprehension Activity 00:04:00 Use Handouts To Reach Every Learner 00:08:00 Your Turn Activity 00:02:00 Additional Material Game Changing PowerPoints Workbook 00:05:00 Game Changing PowerPoints - Workbook 01:18:00 Assignment Assignment - PowerPoint Presentation 00:00:00

PowerPoint Presentation
Delivered Online On Demand3 hours 21 minutes
£27.99

Data Entry Administrator

4.8(9)

By Skill Up

Turn yourself into the linchpin of highly organised data and a facilitator of streamlined processes. Learn about Using Excel's Flash Fill and Autofill to Automate Data Entry.

Data Entry Administrator
Delivered Online On Demand1 hour 44 minutes
£25

Receptionist

5.0(1)

By LearnDrive UK

Elevate your career with our Receptionist course! Gain mastery in communication, front desk management, scheduling, and more. Become an office cornerstone. Enrol now!

Receptionist
Delivered Online On Demand1 hour
£5

SQL Server : Basic Microsoft SQL Server

4.7(47)

By Academy for Health and Fitness

**Trust The 35000+ Students Who Are Learning with Us & Kick Starting Their Career!** Deal Price is Active; Save Now- £405! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Basic Microsoft SQL Server Course might help you get there! Expand your expertise with high-quality training - study the Basic Microsoft SQL Server 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 Basic Microsoft SQL Server online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this training course in around 4 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The Basic Microsoft SQL Server 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 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 Basic Microsoft SQL Server course. With this comprehensive Basic Microsoft SQL Server 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 the 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 this program. Learning Outcomes of Basic Microsoft SQL Server: 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 Why Prefer thisBasic Microsoft SQL Server 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) Standards-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 Basic Microsoft SQL Server 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 Basic Microsoft SQL Server course and take a step toward a brighter future! ****Course Curriculum**** ***Basic Microsoft SQL Server*** Introduction Introduction Setup SQL server setup SQL server management studio setup Databases and tables Basic queries INSERT SELECT UPDATE DELETE Filter and sort Variables Logic Security Authentication Connection strings Vulnerability assessment MSSQL an different drivers Stored procedure Example: attendee registry c# Python Files File table Stored procedures General Functions Import data Export data Jobs Backup Database email Job notifications Assessment Process Once you have completed all the modules in the Basic Microsoft SQL Server course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Show off Your New Skills with a Certification of Completion The learners have to complete the assessment of this Basic Microsoft SQL Server course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 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.

SQL Server : Basic Microsoft SQL Server
Delivered Online On Demand4 hours
£12

Data Analysis and Forecasting in Excel

4.7(160)

By Janets

Register on the Data Analysis and Forecasting in Excel today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Data Analysis and Forecasting in Excel is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Data Analysis and Forecasting in Excel Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Data Analysis and Forecasting in Excel, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Data Analysis and Forecasting in Excel 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 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:08: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:06:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09: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:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:06: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.

Data Analysis and Forecasting in Excel
Delivered Online On Demand4 hours 51 minutes
£25