Excel Intermediate 2013

  1. About the Course
  2. Target Audience
  3. Why Choose Us?
  4. Syllabus
  5. Book the course

 

    Course Overview

      Students will learn how to work more effectively with Excel 2013 workbooks and worksheets. Students will undertake tasks using complex formulas and functions, advanced formatting, absolute referencing, conditional formatting and charting features. Once students have completed the course they will be able to manage, manipulate and analyse complex data.

      Course Length

    • 1 Day
    • Every Tuesday
    • 10:00am - 5:00pm

 

    Target Audience

      This course is intended for current Microsoft Excel 2013 users who wish to extend their knowledge and skills beyond building simple workbooks.

      Participants should have already completed the Excel 2013 Beginner Course before attending this course or have equivalent skills or experience. It is also important to have a general understanding of computers and the Windows operating system.

 

    Why Choose Us?

    • Small class size which allows trainers to give required attention to each delegate
    • Flexible course schedules (Week Days, Weekend, Evenings) to suit your work and social life
    • Class room based, Tutor Led, hands-on training; giving you real life experience
    • Excellent Modern Facilities
    • Very affordable course fees without compromising on quality
    • All our courses are based on certification or project works
    • All our courses are Practical Based (Hands-on Training)
    • Taught by Certified Trainers
    • Employment Opportunities and Assisting in building your CV
    • Friendly and helpful staff

 

    Course Content

      Unit 1: Fill Techniques

      Unit 2: Worksheet Techniques

      Unit 3: Page Setup

      Unit 4: Applying Borders

      Unit 5: Essential Functions

      Unit 6: Complex Formulas

      Unit 7: Financial Functions

      Unit 8: Date and Time Functions

      Unit 9: Defined Names

      Unit 10: Number Formatting Techniques

      Unit 11: Conditional Formatting

      Unit 12: Goal Seeking

      Unit 13: The Quick Analysis Tools

      Unit 14: Worksheet Tables

      Unit 15: Pivot Tables

      Unit 16: Chart Elements

      Unit 17: Chart Object Formatting

Event Event Date Capacity Registered Available place Register
Excel Intermediate 2013 02-06-2015 10:00 am 5 0 5
Excel Intermediate 2013 09-06-2015 10:00 am 5 0 5
Excel Intermediate 2013 16-06-2015 10:00 am 5 0 5
Excel Intermediate 2013 23-06-2015 10:00 am 5 0 5
Excel Intermediate 2013 30-06-2015 10:00 am 5 0 5