Course Description

MS Excel Bundle



MS Excel Bundle is a course run by 1 Training, Dublin. It is a 'Online Learning' course with a duration of Guided Learning Hours 16. MS Excel Bundle gives a Course Qualification of CPD. For more information about MS Excel Bundle at 1 Training, please review the details below.

MS Excel Bundle

Overview:

This excellent Microsoft Excel Bundle has been created so you can become an expert user of Excel, which is used in most workplaces, and is extremely useful. This Microsoft Excel Bundle is taught by instructors who have years of experience and heaps of insider tips and tricks to share with you. This Adobe After Effects Bundle consists of the following courses: After Effects CS3: Essentials, and After Effects CS3: Advanced. This bundle consists of the following courses: Excel 2016 – PC, Excel 2016 Bootcamp, Excel 2016 for PC – Charting, Excel 2016 for PC – Evaluating Data, Excel 2016 for PC – Frequently Used Formulas & Functions, Excel 2016 for PC – Pivot Tables, Excel 2016 for PC – Protecting Your Spreadsheets and Excel 2016 for PC – Statistical Analysis.

Our courses couldn’t be more convenient, the course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

Course Curriculum Total Units : 0
1: GETTING STARTED
2: WORK WITH DATA AND DATASETS
3: CREATE FORMULAS
4: MANAGE DATA AND DATASETS
5: FORMAT YOUR TABLE
6: WORK WITH SHEETS
7: WORK WITH CHARTS
8: SHARE AND SECURE DATA
9: IMPORT AND EXPORT DATA
1: OVERVIEW
2: HOW TO MAKE A QUOTE & INVOICING FORM
3: USING TEMPLATES
4: CLEANING UP MESSY DATA
5: GRAPHS IN EXCEL
6: PIVOT TABLES
7: HOW TO MAKE A PROFIT & LOSS SHEET
8: CHEAT SHEET & SHORTCUTS
1: GETTING STARTED
2: CHART TABS AND RIDDONS
3: FORMAT YOUR CHART
4: PRESENT YOUR CHART
5: WORK WITH SPARKLINES
6: NEW CHART TYPES
1: GETTING STARTED
2: DATA VALIDATION
3: CONDITIONAL FORMATTING
1: GETTING STARTED & WHAT’S NEW
2: FORMULAS
3: LINKING AND CONSOLIDATING WORKSHEETS
4: AUDITING & ERROR CHECKING
1: GETTING STARTED
2: CREATING & DELETING
3: CUSTOM APPEARANCE & LAYOUT
4: PRINTING OPTIONS & COPYING A PIVOT TABLE
5: SUMMARIZING WITH TOTALS & FORMULAS
6: REFRESHING DATA
7: PIVOT CHARTS
8: SPARKLINES & SLICERS
1: PROTECTING YOUR SPREADSHEET
1: DESCRIBING DATA
2: COMPARING VARIABLES
3: TESTS OF SIGNIFICANCE
4: PRINTING OPTIONS & COPYING A PIVOT TABLE
5: DATA ANALYSIS TOOLPAK

Included Courses:

  • Excel 2016 – PC
  • Excel 2016 Bootcamp
  • Excel 2016 for PC – Charting
  • Excel 2016 for PC – Evaluating Data
  • Excel 2016 for PC – Frequently Used Formulas & Functions
  • Excel 2016 for PC – Pivot Tables
  • Excel 2016 for PC – Protecting Your Spreadsheets
  • Excel 2016 for PC – Statistical Analysis

How will I be assessed?

  • You will have 8 assignments. Pass mark is 65%.
  • You will only need to pay £19 x 8 for assessments.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

Certification:

Successful candidates will be awarded certificates for Microsoft Excel Bundle. Anyone eligible for certification will receive e-certificates, and printed certificates.

The MS Excel Bundle course at 1 Training is listed in Courses.ie's national courses finder.
Training Provider1 Training
Course LocationDublin
Course TypeOnline Learning
Course QualificationCPD
Course DurationGuided Learning Hours 16
Course Fee45
Entry Requirements• You must be 16 or over • You should have a basic understanding of English, Maths and ICT • You will need a computer or tablet with internet connection (or access to one)
Carear Path• Administrator • Office manager • Business executive • Accountant • Bookkeeper
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on Courses.ie by clicking here.

Course Provider

1 Training



63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training




Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the Courses.ie community.
 

Map