12879 Courses in Cardiff delivered Online

Unlock the power of data with our 'Sales Analysis in Excel' course. Dive into e-commerce sales analysis and craft insightful sales analysis reports. Discover how to manipulate sales data, forecast trends, and automate workbook functionality. Elevate your career with advanced Excel skills! Learning Outcomes of Sales Analysis in Excel: Master data manipulation techniques for e-commerce sales analysis. Create comprehensive sales reports with Excel's advanced functions. Visualize data effectively using charts, PivotTables, and PivotCharts. Forecast future trends and make data-driven decisions. Automate repetitive tasks to boost efficiency and productivity. Why buy this Sales Analysis in Excel? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Sales Analysis in Excel there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Business analysts seeking to enhance their data analysis skills. Sales professionals aiming to leverage Excel for deeper insights. Aspiring data scientists interested in e-commerce sales data. Students and graduates looking to gain a competitive edge. Entrepreneurs striving to optimize their sales strategies. Prerequisites This Sales Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sales Analysis in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Sales Analyst: £25,000 - £45,000 Per Annum Financial Analyst: £30,000 - £55,000 Per Annum Market Research Analyst: £25,000 - £40,000 Per Annum Excel Specialist: £22,000 - £35,000 Per Annum 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 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11: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 Welcome to the Course 00:03: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 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 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13: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

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

Overview This comprehensive course on Financial Modeling Using Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Modeling Using Excel 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 Financial Modeling Using Excel. It is available to all students, of all academic backgrounds. Requirements Our Financial Modeling Using Excel 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 • 9 lectures • 01:31:00 total length •Welcome to the Course! Get the Overview of What You'll Learn: 00:04:00 •Planning your Financial Model: 00:09:00 •Building a Model Template: 00:12:00 •Projecting the Income Statement: 00:13:00 •Projecting the Balance Sheet: 00:17:00 •Projecting Cash Flows: 00:14:00 •Advanced Financial Modeling: 00:14:00 •BONUS LESSON: Top 5 Excel Features for Financial Modellers: 00:08:00 •Resources - Financial Modeling Using Excel: 00:00:00

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

In this course, you will learn the advanced features and functions of Microsoft Excel 2010. You will learn how to plan your worksheet and be clear on your objectives and the importance of saving as much as possible. You will know how to use macros to automate repetitive tasks, What If Analysis and how to outline to quickly manage detail data. You will also know the guided exercises provided in this course to refresh your skills. Course Highlights Certified Microsoft Excel 2010 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 Certified Microsoft Excel 2010 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 10 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 Certified Microsoft Excel 2010 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? Certified Microsoft Excel 2010 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 Certified Microsoft Excel 2010 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. Certified Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 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 00:30:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:20:00 Final Exam Final Exam-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:20:00

[vc_row][vc_column][vc_column_text] Description: In this course, you will be able to identify the elements of the Microsoft Excel interface. You will learn how to create a basic worksheet and to get comfortable with the parts of the screen. This Microsoft Office 2013 Excel Beginners - Complete Video Course covers the basic functions and features of Excel 2013. You will learn about calculations and how to modify and format a worksheet. You will also learn how to customize the Excel environment and how to manage and print workbooks. In this course, you will take your knowledge up a notch as you get acquainted with Microsoft Excel 2013's most sophisticated features. If you think you know Excel 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Excel tips and tricks out there. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.[/vc_column_text][/vc_column][/vc_row] Getting Started with Microsoft Excel 2013 Identify the Elements of the Excel Interface FREE 00:14:00 Create a Basic Worksheet 00:16:00 Use the Help System 00:04:00 Performing Calculations Create Formulas in a Worksheet 00:15:00 Insert Functions in a Worksheet 00:13:00 Reuse Formulas 00:15:00 Modifying a Worksheet Manipulate Data 00:13:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:08:00 Search for and Replace Data 00:12:00 Spell Check a Worksheet 00:06:00 Formatting a Worksheet Modify Fonts 00:11:00 Add Borders and Color to Cells 00:10:00 Apply Number Formats 00:10:00 Align Cell Contents 00:10:00 Apply Cell Styles 00:08:00 Printing Workbook Contents Define the Basic Page Layout for a Workbook 00:16:00 Refine the Page Layout and Apply Print Options 00:13:00 Managing Large Workbooks Format Worksheet Tabs 00:03:00 Manage Worksheets 00:09:00 Manage the View of Worksheets and Workbooks 00:10:00 Customizing the Excel Environment Customize General and Language Options 00:08:00 Customize Formula Options 00:04:00 Customize Proofing and Save Options 00:04:00 Customize the Ribbon and Quick Access Toolbar 00:04:00 Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Take your career to the next level by mastering new Excel functions. This The New functions in Microsoft Excel in 2021 course aims to provide you with a greater understanding of Excel's new formulas to boost your work output. Microsoft Excel is a widely used spreadsheet program in various organizations. It simplifies the process of calculation, analysis and visualization of data and information. Having Excel skills adds a considerable amount of weight to your resume. In this The New functions in Microsoft Excel in 2021 course, you will learn about the latest functions of Excel to simplify your Excel tasks. You will learn the principles behind dynamic arrays and explore how to create a table of random numbers or random dates with Randarray. It will teach you the new ways of dynamically sorting data with the sort by function. You will also delve into other functions such as XLOOKUP, SWITCH and CONCAT and determine how they work.  Learning Outcomes Familiarize with the new functions of Excel Understand how the FILTER function works Explore how the new UNIQUE, SORT and SORTBY Excel functions work Know how to use RANDARRAY function to randomly sort lists Be able to use DYNAMIC array formulas Understand how to use the new functions in reports Who is this course for? The New functions in Microsoft Excel in 2021 course is highly relevant for professionals who want to excel in their position with their Excel skills. Gaining the skills adds weight to the resume and provides tremendous career opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The New functions in Microsoft Excel in 2021 course provides useful skills to possess and would be beneficial for any related profession or industry such as: Office administrators Accounting officers Managers HR Project Supervisors Data analyst Teachers Sales Representatives The New functions in Microsoft Excel in 2021 Module 01: Introduction and Agenda 00:07:00 Module 02: RANDARRAY 00:04:00 Module 03: UNIQUE 00:05:00 Module 04: SEQUENCE 00:04:00 Module 05: SORT and SORTBY 00:09:00 Module 06: SORT A Practical Example 00:06:00 Module 07: FILTER 00:07:00 Module 08: FILTER A Practical Example 00:08:00 Module 09: Other Useful New Functions 00:15:00 Module 10: Using the New Functions in Reports 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you having trouble showcasing your data in important presentations? Then Microsoft Excel is a 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 2010, then this is the course for you. With Excel 2010, 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 2010. Gain access to new features such as sparklines, improved pivotCharts, slicer, Access spreadsheets from anywhere and many more. Whether you are a beginner or an advanced level user at Microsoft Excel 2010, this course will help you. You will be able to learn all the relevant information on how to analyze numbers, keep track of data, and graphically represent your information using various charts. Course Highlights Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 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 2010 Certified - Beginners, Intermediate & Advanced into 39 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 1 day, 7 hours 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 2010 Certified - Beginners, Intermediate & Advanced 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 2010 Certified - Beginners, Intermediate & Advanced 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 2010 Certified - Beginners, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path 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 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 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 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 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 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 00:20:00

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Excel 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Microsoft Excel 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 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 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 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 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 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Introduction Introduction 00:03:00 Part 1: Forecasting Basics of Forecasting 00:05:00 Creating Linear Model with Trendlines 00:08:00 1.1 Getting Data Ready For Regression Model Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 1.2 Forecasting Using Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 1.3 Handling Special Events Like Holiday Sales Forecasting in presence of special events 00:02:00 Excel: Running Linear Regression using Solver 00:08:00 Excel: Including the impact of Special Events 00:22:00 1.4 Identifying Seasonality & Trend for Forecasting Models to identify Trend & Seasonality 00:06:00 Excel: Additive model to identify Trend & Seasonality 00:09:00 Excel: Multiplicative model to identify Trend & Seasonality 00:06:00 Market Basket Analysis Market Basket and Lift - Introduction 00:08:00 Named Ranges - Excel 00:10:00 Indirect Function - Excel 00:05:00 2-way lift calculation in Excel 00:11:00 2-way lift calculation - Dynamic 00:07:00 2-way lift data table creation 00:07:00 3-way lift calculation 00:19:00 Store Layout optimization using Lift values 00:15:00 RFM (Recency, Frequency, Monetary) Analysis RFM (recency, frequency, monetary) Analysis 00:08:00 RFM Analysis in Excel- Part 1 00:16:00 RFM Analysis in Excel- Part 2 00:12:00 Part 2: Pricing Part 2: Pricing Steps of setting a Pricing policy 00:03:00 Different Pricing Objectives 00:07:00 2.1 Estimating Demand Estimating Demand 00:07:00 Forms of Demand Curve 00:02:00 Excel: Estimating Linear Demand Curve 00:08:00 Excel: Estimating Power Demand curve with Elasticity 00:05:00 Excel: Estimating Power Demand Curve with points 00:03:00 Subjective Demand curve 00:01:00 Excel: Estimating Subjective Demand Curve 00:02:00 2.3 Evaluating Pricing Strategies Price Bundling 00:07:00 Types of Bundling 00:08:00 The Bundling Problem 00:04:00 Excel: Solving Bundling problem Part 1 00:14:00 Excel: Solving Bundling problem Part 2 00:08:00 Non-Linear Pricing Strategies 00:03:00 Excel: Solving Bundling problem (Price Reversal) 00:08:00 3.1 Lifetime Customer Value Lifetime Customer Value - Key concepts 00:09:00 Lifetime Customer Value - Excel model 00:11:00 3.2 Variations And Sensitivity Analysis Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Appendix 1: Excel Crash Course Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Basic Formula Operations 00:13:00 Mathematical Formulas 00:19:00 Textual Formulas 00:17:00 Logical Formulas 00:11:00 Date-Time Formulas 00:07:00 Lookup Formulas ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools 00:19:00 Formatting data and tables 00:18:00 Pivot Tables 00:08:00 Advance Excel- Solver, Data tables 00:15:00 Assessment Assessment - Retail Analytics In Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00