Data Analysis - Microsoft Excel - Jobs and Recruitment on reed.co.uk, the UK's #1 job site

Data Analysis – Microsoft Excel

£118.41

Develop in-demand skills for a better future with a super-saver bundle deal with 200 CPD points for just ?119 and instantly save ?1580 ! This Data Analysis- Microsoft Excel bundle includes 1 best selling ABC Awards-endorsed course with 5 additional CPD-accredited course, expert assistance and course assessment. Enjoy 12 months access to this bundle of courses FREE of charge and master a range of in-demand professional skills to advance your career. No hidden costs — simply enrol this Data Analysis- Microsoft Excel bundle and get certified from ABC Awards. This Data Analysis- Microsoft Excel bundle package includes: ABC Awards-endorsed Data Analysis In Excel with endorsed certificate 5 additional CPD courses — Financial Modeling Using Excel Business Data Analysis Content Management Business Productivity Training Google Analytics Course Dedicated tutor support and 24/7 customer support are available to all students with this premium quality Data Analysis- Microsoft Excel bundle. Get the help you require and the answers to all your queries throughout the comprehensive syllabus of this Data Analysis- Microsoft Excel bundle. This premium online course titled Data Analysis- Microsoft Excel bundle ensures your professional development with ABC Awards & CPD accreditation. You’ll have the privilege of learning in your own time, at your own pace and earning an accredited certification. With this Data Analysis- Microsoft Excel bundle program, success becomes a lot easier that enables you to monetise your skills. This Data Analysis- Microsoft Excel bundle is designed for both part-time and full-time students and can be completed at a pace that suits your learning style. Why People Enrol this Data Analysis- Microsoft Excel bundle From One Education: Receive an ABC Awards-endorsed certificate upon successful completion of the Data Analysis- Microsoft Excel bundle 5 additional CPD courses to enrich your knowledge and skills Learning materials of our Data Analysis- Microsoft Excel bundle contains engaging voiceover and visual elements for your comfort Get 24/7 access to all Data Analysis- Microsoft Excel bundle content for a full year Complete the Data Analysis- Microsoft Excel bundle at your own pace Each of our students gets full tutor support on weekdays (Monday to Friday) Efficient assessments and instant results upon completion of our Data Analysis- Microsoft Excel bundle

SKU: 242039 Category:

Description

Business_Microsoft Office

Description

Course Curriculum:

Here is a curriculum breakdown of the ABC Awards-endorsed Data Analysis In Excel:

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analyzing Data

  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

Using Lookup Functions and Formula Auditing

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

Creating Sparklines and Mapping Data

  • Create Sparklines
  • MapData

Forecasting Data

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

How is the Data Analysis- Microsoft Excel bundle assessed?

To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score displayed for your perusal. For each test, the pass mark will be set to 60%.

When all tests have been successfully passed, you will be able to claim a recognised and professional certificate endorsed by ABC Awards and Certa Awards. ABC Awards and Certa Awards Quality License Scheme is a respected global brand name in the education sector.

Certification

Endorsed Certification from ABC Awards

After successfully completing the Data Analysis- Microsoft Excel bundle, learners will get an endorsed certificate (included with the course) delivered right at their doorstep by post, without paying a single penny! Note that, learners residing outside the UK has to pay a £10 postage charge.

CPD & IAO Accredited Certification from One Education

After successfully completing the MCQ assessment of this Data Analysis- Microsoft Excel bundle, you will also qualify for a CPD Certificate from One Education, as proof of your continued professional development. Certification is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.