Excel 2013-2016 Intermediate Level
Course Description
COURSE OUTLINE
Introduction
- Welcome and Admin
- Using the Provided Excel files for Practical Activities
Finding your way around with Excel
- What is Excel used for
- Touring and Navigating the menu system
- Using the Quick Access Toolbar
- Understanding workbooks and worksheets
- Excel Formula bar
- Making use of the Status bar
- Using navigation tools
- Using the Mini toolbar and shortcut menus
- Creating new workbooks (Files)
- Exploring Excel Help
Excel Data Entry
- Exploring data entry and editing techniques
- Excel AutoFill Feature
- How to work with dates and times in Excel
- Reversing with Undo and Redo
- Adding comments to sheets
- When to use Save or Save As
Formulas and Functions
- Creating simple formulas
- Copying a formula into adjacent and other cells
- Calculating year to date totals – (Excel Today Function)
- Creating a percentage change formula
- Working with relative, absolute, and mixed references
- Using SUM and AVERAGE
- Using other common functions
Formatting Essentials
- Exploring font styles and effects
- Adjusting row heights and column widths
- Working with alignment and Wrapping Text
- Designing borders
- Exploring numeric and special formatting
- Formatting numbers and dates
- Using conditional formatting
- Creating and using tables
- Inserting shapes, arrows, and other visual features
Manipulating Data and Adjusting Worksheet Layout
- Inserting and deleting rows and columns
- Hiding and un-hiding rows and columns
- Moving, copying, and inserting data
- Finding and replacing data
- Printing in Excel
- Exploring the Page Layout tab and Page Layout view
- Previewing page breaks
- Working with Page Setup and printing controls
Excel Charts
- Creating charts
- Exploring chart types
- Formatting charts
- Working with axes, titles, and other chart elements
- Creating in cell charts with Spark-lines
Adjusting data and worksheet Views
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically
- Collapsing and expanding data views with outlining
Working with Multiple Worksheets and Workbooks
- Displaying multiple worksheets and workbooks
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets
- Using formulas to link worksheets and workbooks
- Locating and maintaining links
IF Functionality, Data lookup and Power Functions
- Using IF functions and relational operators
- Getting approximate table data with the VLOOKUP function
- Getting exact table data with the VLOOKUP function
- Using the COUNTIF, SUMIF family of functions
Protection, Security and Sharing
- Unlocking cells and protecting worksheets
- Protecting workbooks
- Assigning passwords to workbooks
- Sharing workbooks
- Tracking changes
Data Manipulation and Management
- Sorting data
- Inserting subtotals in a sorted list
- Using filters
- Splitting data into multiple columns
- Splitting and combining columnar data with Flash Fill
- Removing duplicate records
- Using Data Validation tools
Introducing Pivot-tables and Pivot Charts
- Creating Pivot-tables
- Manipulating Pivot-table data
- Using slicers to clarify and manipulate fields
- Using Pivot Charts
Conclusion
- Course Wrap up, next steps
- Certification of Trainees
Terms & Conditions
- The course will be held at a predetermined venue.
- A deposit is required at the time of booking for individual attendance.
- Any remaining balance is due before the course begins.