Excel Intermediate
Short course
In Leicester
Description
-
Type
Short course
-
Level
Intermediate
-
Location
Leicester
-
Duration
1 Day
Our Get Into IT Excel is an intermediate level course providing people with a clear understanding of the power Excel in everyday use, learn new skills on Excel realise potential of this everyday technology at their finger tips. Suitable for: This course will benefit those individuals who have access to Microsoft Office packages
Facilities
Location
Start date
Start date
Reviews
Teachers and trainers (1)
Ben Woodthorpe
Ben is a professional systems analyst and highly experienced IT trainer with a wealth of practical experience. With over 5 years experience and knowledge in key areas of Microsoft he has worked with smaller SME’s right through to PLC’s, developing employees skills and creating bespoke database applications for specific business situations. Ben’s creative, professional and structured approach brings added value to every training session, helping people and businesses reach their potential.
Course programme
Benefit
This is a one day course which benefits those individuals who have a basic knowledge of Excel but who want to enhance their knowledge of Excel at intermediate level.
Course content
Working with large worksheets
• Viewing options
• Hiding, displays & outlining data
• Printing large worksheets
Using multiple worksheets & workbooks
• Using multiple worksheets
• Linking worksheets by using 3-D formulas
• Consolidating data
• Linking workbooks
• Managing workbooks
Customizing Excel
• Using Options dialog box
• Customizing toolbars & menus
Advance Formatting
• Borders & shading
• Using special number formats
• Working with data
• Working with styles
• Other advanced formatting
List Management
• Examining lists
• Sorting & filtering lists
• Advanced filtering
Advanced Charting
• Chart formatting options
• Using combination charts
• Using graphic elements
Documenting & Auditing
• Auditing features
• Comments & text boxes
• Protection
• Workgroup collaboration
Using templates
• Built in templates
• Creating & managing templates
Additional information
Excel Intermediate