Duration: 1 Day
Course Overview
This 1 day instructor led training course builds upon basic Excel knowledge and increases user confidence in using Excel. It provides more of an understanding of working with formulas and functions and demonstrates how Excel can be applied in various business applications.
How can I attend my course?
COURSE OBJECTIVES
• Create advanced formula
• Work with various functions
• Use range names to simplify formula
• Manage and link multiple worksheets
• Create professional looking spreadsheets with advanced formatting techniques
• Create, format and manipulate table data
• Summarise data with outlines and subtotals
• Use web features and share workbooks Create templates with comments and protection
Course Content
More Formulas and Functions
• Relative and absolute formulae
• Nesting formula
• Date and time calculations
• A range of useful functions including:
• Date and Time functions
• Text functions
• Logical functions (IF)
Cell and range names
• Creating and using names
• Managing names
Using multiple worksheets and workbooks
• Linking worksheets with 3D references
• Linking workbooks
• Managing workbooks
Advanced formatting
• Special number formats
• Working with styles
• Conditional Formatting
Work with large worksheets
• Freeze panes
• Headers & Footers
• Print scaling options
• Print formatting options
Tables
• What is a table?
• Formatting a table
• Sorting and filtering data
Outlining and subtotals
• Outlining data
• Creating subtotals
Web and sharing features
• Save as web pages
• Using hyperlinks
• Sharing workbooks
More charting
• Sparklines
• Chart formatting options
• Combination charts
• Adding graphical elements
Documenting and auditing
• Auditing features
• Comments in cells and workbooks
• Protect Workbooks
Work with Templates
• Use built-in templates
• Creating templates from scratch
• Manage templates
Work with Graphic Objects
• Insert Sparklines
• Insert SmartArt
• Work with pictures, clipart and shapes
COURSE PREREQUISITES
Delegates are recommended to have a basic knowledge of Excel or attended the introduction to Excel course.