july, 2022

This is a repeating event

12julAll DayFeaturedMicrosoft Excel Intermediate Training CourseGlasgow

Event Details

One Day Course

This course is intended to allow people with an existing knowledge of working with basic spreadsheets within Excel to move on to the next level of ability including working with more complex spreadsheets, analysing and presenting data.

Course Aims to enable delegates to:

Produce more professional spreadsheets and charts using Microsoft Excel and build on existing knowledge to manipulate and analyse data. The training is designed for existing Excel users wanting to increase their skills.

Course Content

Working with Large Spreadsheet View options Hiding/displaying data Freeze Panes Grouping & Outlining Printing From Excel Page Layouts Printing Large Data Sets Working with Multiple Worksheets Using multiple worksheets Linking worksheets Managing workbooks Advanced Formatting Borders and shading Special number formats Dates Pre-set Styles Custom Styles Conditional formatting Data Bars, Colour Scales & Icons Custom Conditional Format Rules Advanced Formulae Relative Cell References Absolute Cell References Logical Statements (IF) Simple Lookups Useful Functions List Management Creating lists Sorting and filtering AutoFilter Advanced filtering Documenting and Auditing Comments and Text Boxes Useful Auditing features Charts & Graphs Creating auto-charts Creating customized charts Chart Locations Working with Chart Elements Formatting chart options Adding graphic elements

Follow-on Courses

Microsoft Excel Advanced

Requirements before booking this course:

This course is for people who wish to expand on their current knowledge of Microsoft Excel. Anyone attending the course should either have attended Excel Foundation level, or have an equivalent knowledge.

more

Leave a Reply

Your email address will not be published.

X