Course Description

MS Excel Bundle

1 Training



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.


College Name 1 Training
Course Category Computers & IT (Information Technology)
Course Type Online Learning
Course Qualification CPD
Course Location Dublin, Ireland
Course Fee 45
Course Duration Guided Learning Hours 16
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)
Career Path • Administrator • Office manager • Business executive • Accountant • Bookkeeper
For information about 1 Training, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

1 Training



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

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 Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

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

Comments, Questions & Reviews

Submit A Comment, Question or Review About
MS Excel Bundle
at 1 Training

Your email address will not be published. Required fields are marked *

Click to Rate

We'd love to send you the latest news and articles about evening classes, further learning and adult education by email. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

Comments and Reviews Policy