/

Microsoft Excel Intermediate

Add to shortlistShortlisted by 33 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
117 views
START DATES
OCTOBER 2018
Sun Mon Tue Wed Thu Fri Sat
NOVEMBER 2018
Sun Mon Tue Wed Thu Fri Sat

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

Ask a question

Get course info