MICROSOFT® EXCEL (INTERMEDIATE-ADVANCED)
1 session per week
4 hours per session
48 total class hours
This course is designed for any individual interested in increasing their knowledge and proficiency with Excel 2013, students transitioning from Excel 2003/2010, and anyone wishing to move their Excel skills to a higher level.
Prospective students should be familiar with basic computer terminology, be proficient with the use of the mouse and keyboard, and have at least 6 months experience using Microsoft Excel. Participants should understand basic mathematical principles.
2007 /2010 to 2013 Skills Migration
- Learning the new 2013 interface. How to adapt what we know about 2007/2010 into 2013.
- A tool that maps 2013 commands to 2007/2010 will be given to class members.
- Shortcut keys for navigating the new ribbon interface will be discussed and practiced.
Range Names, Lists, and String Functions
- Use of range names for navigation, formula simplification, and using range name constants.
- 2013 range name scopes will be discussed.
- Use of the new Names Manager. MID, LEFT, RIGHT, CONCATENATE, TRANSPOSE.
- SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS.
- Nesting functions.
- Various LOOKUP functions will be discussed.
- Combined with the previous weeks named range concept and a new “list” tool, participants obtain a useful and commonly used skill set.
PivotTables and PivotCharts
- PivotTables and PivotCharts with emphasis on the differences in 2013.
- Formatting options, including the use of the new conditional formatting features.
- More PivotTables and PivotCharts.
- Proper data design principles.
- Adding, deleting records, sorting, filtering data.
- Advanced querying, Outlining, Data Tables.
- Explore the new charting features in Excel 2013. Some emphasis on using Excel charts in PowerPoint presentations.
- Linking charts to PowerPoint presentations.
Managing Multi-Sheet Workbook
- Using multi-sheet and multi-book formulas. 3D formulas and linking. Array functions.
- Learn the process of recording “keystroke” macros and analyzing the results.
- Learn to modify and enhance the recorded macros.
- Create macros from scratch.