EXCEL 2013 (LEVEL 3- ADVANCED)

Kona Courseware

ISBN-13:

# pages: 275

 

Suggested Retail: $44.95

$44.95

Description

Excel 2013 (Level 3- Advanced) by Kona Courseware is a step-by-step Excel training manual illustrated 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.

Table of Contents

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


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
1.8 CREATING XML WEB QUERIES
1.9 CREATING REFRESHABLE WEB QUERIES
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
4.6 ADDING A MACRO TO THE QUICK ACCESS TOOLBAR
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 WITH SLICERS
5.10 FILTERING PIVOTTABLE INLINE
5.11 CREATING CUSTOM FILTERS
5.12 FILTERING PIVOTTABLE DATA USING TIMELINE
5.13 CREATING A PIVOTCHART
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
6.7 PREVIEWING DATA USING QUICK ANALYSIS
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
8.10 INSPECTING WORKBOOKS
8.11 CHECKING DOCUMENT COMPATIBILITY
8.12 CHECKING DOCUMENT ACCESSIBILITY
LESSON SUMMARY – WORKGROUP COLLABORATION
LESSON 8 QUIZ
LAB 8– ON YOUR OWN
CLASS PROJECT – COMPANY UPDATE


INDEX

About the Author(s): Kona Courseware

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.

Back To Top