/

Microsoft Excel Intermediate

Activia Training
Add to shortlistShortlisted by 38 people

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-Intermediate-courses/57159736/

Course description

Microsoft Excel Intermediate:


COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

FREE E-LEARNING REVISION

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .

DURATION

This is a one-day training course structured into 6 modules

COURSE AIMS

This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010, 2013 or 2016, in order to increase their knowledge and productivity.

TARGET AUDIENCE

Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

MODULE 1: Advanced File Tasks
Saving and File Management

Converting and Encrypting Files
File Properties and Digital Signatures
File Accessibility and Compatibility

MODULE 2: Working with Functions and Formulas
Formulas with Absolute References

Autosum Functions (SUM & AVERAGE)
IF and Nested Functions
Working with Named Ranges
Array Functions (SUMIF & AVERAGEIF)
Formula Auditing
Text Functions

MODULE 3: Managing Tables in Microsoft Excel
Creating Excel Tables

Working with Records and Filters
Advanced Filters

MODULE 4: Data Tools in Excel
Text to Columns

Flash Fill
Remove Duplicates
Data Validation
Consolidate

MODULE 5: Doing More with Charts in Excel
Trendlines

Error Bars
Working with Axis Options
Advanced Chart Formatting

MODULE 6: Sparklines
Creating Sparklines

Editing Sparklines

Additional entry requirements

Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Training for employers

This course has been specifically designed for companies training their employees.

Course reference: ATMSXL606 (use this when contacting provider)

Course info
158 views
Start Date: No future start dates currently available

Location:

Birmingham, B4 7LR, Bristol, BS1 6EA, Leeds, LS1 3BE, London, E1W 1AW, London, SW1H 0HW + 5 more

Time:

9:30am - 4:30pm

Duration:

7 hours

Attendance:

Full time

Qualification:

Certificate of Attendance

Level:

Beginner IntermediateAdvanced

From: £238.80

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Microsoft Excel Intermediate by Activia Training on Hotcourses
Add to shortlist

You might like...

Others viewed...

  • People who viewed this course also viewed

  • Excel

    from: £107.00

    Mary Ward Centre

    (LONDON – WC1N 3AQ)
  • Excel - Beginner

    from: £65.00

    South Thames College

    (London – SW18 2PP)
  • Intermediate Microsoft Excel

    from: £170.00

    Insight IT Training Limited

    (Manchester – M2 4WQ)