One Day • Instructor Led
This course offers valuable tips and tricks to maximize the capabilities of Excel. You will learn shortcuts that are sure to speed up application development with Excel and take your skills to the next level. To take this course, we recommend you be familiar with basic concepts of data analysis, such as working with tables, filtering, sorting, using formulas, and performing calculations.
Course Objectives
In this course, you will learn to:
- Deploy time-saving customizations
- Develop shortcuts to work with large files
- Copy print settings across multiple sheets
- Apply custom functions
- Create dynamic chart data
Prerequisites
To ensure your success, we recommend you have experience using Excel with data and familiarity with basic concepts of data analysis such as working with tables, filtering, sorting, using formulas and performing calculations.
Course Outline
Lesson 1: Basic Excel Usage
- Selecting
- Navigating
- Hiding
- Formatting
Lesson 2: Data Entry
- AutoComplete, AutoCorrect and Auto Fill
- Freezing panes
- Drop-Down lists
Lesson 3: Formatting
- Number formats
- Gridlines, borders and underlines
- Wrapping text
- Colors and alternate row shading
Lesson 4: Basic Formulas & Functions
- References
- Values and formulas
- Names
Lesson 5: Useful Formula Examples
- Calculating
- Dates
- Counting
- Lookups
Lesson 6: Charts & Graphics
- Different types of charts
- Plotting
- Graphics
Lesson 7: Working with Files
- Importing
- Document properties
- Passwords
Lesson 8: Printing
- Printing controls
- Page breaks and numbering