: Publication

Excel 2011 (Level 3- Advanced) by Kona Courseware is a step-by-step Excel training manual iillustrated with full-color diagrams, lists, tables and screen shots.  These features are designed to aid in comprehension, retention, and application both inside and outside of the classroom. Our courseware is simple to use for both instructors and students yet comprehensive and highly effective. Many students find the “step-by-step” approach of our manuals to be a valuable self-study resource well after their class has ended.

EXCEL 2011 LEVEL 3 – INTRODUCTION
REQUIREMENTS
COMPONENTS OF THE MANUAL
TRAINING FILES
WHAT’S NEW IN EXCEL 2011?

LESSON 1 - IMPORTING & EXPORTING DATA
1.1 IMPORTING EXTERNAL DATA INTO EXCEL
1.2 IMPORTING TEXT DATA INTO EXCEL
1.3 IMPORTING DATA FROM A DATABASE
1.4 LINKING TO ANOTHER FILE
1.5 LINKING & EMBEDDING OBJECTS
1.6 EXPORTING DATA FROM EXCEL
1.7 PUBLISHING WORKSHEETS & WORKBOOKS TO THE WEB
LESSON SUMMARY – IMPORTING AND EXPORTING DATA
LESSON 1 QUIZ
LAB 1 – ON YOUR OWN

LESSON 2 - FORMATTING NUMBERS
2.1 CREATING CUSTOM NUMBER FORMATS
2.2 USING CONDITIONAL FORMATTING
2.3 APPLYING CONDITIONAL FORMATTING BASED ON TOP/BOTTOM
RULES
2.4 APPLYING SPECIALIZED CONDITIONAL FORMATTING
2.5 CREATING YOUR OWN FORMATTING RULES
2.6 MANAGING CONDITIONAL FORMATTING
2.7 CLEARING CONDITIONAL FORMATTING
LESSON SUMMARY – FORMATTING NUMBERS
LESSON 2 QUIZ
LAB 2 – ON YOUR OWN

LESSON 3 - WORKING WITH RANGES
3.1 NAMING A RANGE
3.2 USING A NAMED RANGE
3.3 MANAGING RANGE NAMES
3.4 USING THE VLOOKUP FUNCTION
LESSON SUMMARY – WORKING WITH RANGES
LESSON 3 QUIZ
LAB 3 – ON YOUR OWN

LESSON 4 - WORKING WITH MACROS
4.1 CREATING A MACRO
4.2 RUNNING A MACRO
4.3 EDITING A MACRO
4.4 SAVING A WORKBOOK WITH MACROS
4.5 OPENING A WORKBOOK WITH MACROS
LESSON SUMMARY – CUSTOMIZING EXCEL
LESSON 4 QUIZ
LAB 4 – ON YOUR OWN

LESSON 5 - DATA ANALYSIS TOOLS
5.1 TRACING FORMULA PRECEDENTS
5.2 TRACING CELL DEPENDENTS
5.3 TRACING AND FIXING ERRORS
5.4 ERROR CHECKING A WORKSHEET
5.5 CREATING A PIVOTTABLE
5.6 REARRANGING A PIVOTTABLE
5.7 SETTING PIVOTTABLE OPTIONS
5.8 FORMATTING A PIVOTTABLE
5.9 FILTERING PIVOTTABLE DATA INLINE
5.10 CREATING CUSTOM FILTERS
LESSON SUMMARY – DATA ANALYSIS TOOLS
LESSON 5 QUIZ
LAB 5 – ON YOUR OWN

LESSON 6 - SUMMARIZING DATA
6.1 ADDING SUBTOTALS TO A LIST
6.2 NESTING SUBTOTALS
6.3 APPLYING ADVANCED FILTERS
6.4 ADDING GROUP AND OUTLINE CRITERIA TO RANGES
6.5 USING DATA VALIDATION
6.6 CONVERTING TEXT TO COLUMNS
LESSON SUMMARY – SUMMARIZING DATA
LESSON 6 QUIZ
LAB 6 – ON YOUR OWN

LESSON 7 - WHAT-IF DATA ANALYSIS
7.1 USING GOAL SEEK
7.2 USING SOLVER
7.3 CREATING & DISPLAYING SCENARIOS
7.4 USING DATA TABLES
LESSON SUMMARY – WHAT-IF DATA ANALYSIS
LESSON 7 QUIZ
LAB 7– ON YOUR OWN

LESSON 8 - WORKGROUP COLLABORATION
8.1 LOCKING/UNLOCKING CELLS IN A WORKSHEET
8.2 PROTECTING A WORKSHEET
8.3 SHOWING OR HIDING FORMULAS
8.4 PROTECTING A WORKBOOK
8.5 CREATING A SHARED WORKBOOK
8.6 TRACKING CHANGES TO A WORKBOOK
8.7 ACCEPTING AND REJECTING CHANGES TO A WORKBOOK
8.8 PASSWORD PROTECTING A WORKBOOK
8.9 MERGING COPIES OF SHARED WORKBOOKS
LESSON SUMMARY – WORKGROUP COLLABORATION
LESSON 8 QUIZ
LAB 8– ON YOUR OWN
CLASS PROJECT – COMPANY UPDATE

INDEX

The goal of Kona Courseware is to create courseware to make learning technology concepts easy, no matter what kind of learner you are. Our courseware is designed for an instructor led environment and facilitates learning via auditory, visual and hands-on experiences by each student. Authored and developed by an outstanding team of computer software instructors and trainers, we think you will find that our courseware  is comprehensive and highly effective.  We also purposely designed our courseware to be simple to use, intuitive and unintimidating for students.