: Publication

Excel 2011 (Level 2-Intermediate) 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.

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

LESSON 1 – WORKING WITH TABLES
1.1 CREATING A TABLE
1.2 ENTERING DATA INTO A TABLE
1.3 DELETING ROWS AND COLUMNS
1.4 FORMATTING A TABLE
1.5 TOTALING DATA IN A TABLE
1.6 SORTING DATA IN A TABLE
1.7 SORTING MULTIPLE COLUMNS
1.8 FILTERING DATA USING AUTOFILTER
1.9 CREATING CUSTOM FILTERS
LESSON SUMMARY – WORKING WITH TABLES
LESSON 1 QUIZ
LAB 1 – ON YOUR OWN

LESSON 2 – WORKING WITH CHARTS
2.1 CREATING A CHART
2.2 MOVING A CHART
2.3 RESIZING A CHART
2.4 CHANGING THE LAYOUT AND STYLE
2.5 LABELING CHART ELEMENTS
2.6 FORMATTING CHART TEXT
2.7 FORMATTING CHART ELEMENTS
2.8 CHANGING THE CHART TYPE
2.9 SHOWING OR HIDING GRIDLINES
2.10 CUSTOMIZING AXES
2.11 CREATING A PIE CHART
2.12 CHANGING A CHART’S SOURCE DATA
2.13 MOVING A CHART TO A DIFFERENT WORKSHEET
2.14 USING SPARKLINES
2.15 CUSTOMIZING SPARKLINES
LESSON SUMMARY – WORKING WITH CHARTS
LESSON 2 QUIZ
LAB 2 – ON YOUR OWN

LESSON 3 – WORKING WITH GRAPHICS
3.1 ADDING CLIP ART
3.2 ADDING PICTURES
3.3 ADDING SHAPES
3.4 FORMATTING DRAWING OBJECTS
3.5 INSERTING WORDART
3.6 INSERTING SMARTART
3.7 INSERTING AN ORGANIZATION CHART
3.8 MODIFYING AN ORGANIZATIONAL CHART
LESSON SUMMARY – WORKING WITH GRAPHICS
LESSON 3 QUIZ
LAB 3 – ON YOUR OWN

LESSON 4 – WORKGROUP COLLABORATION
4.1 E-MAILING A WORKBOOK
4.2 WEB PAGE PREVIEW
4.3 CONVERTING WORKSHEETS INTO WEB PAGES
4.4 INSERTING HYPERLINKS
4.5 VIEWING AND EDITING COMMENTS
LESSON SUMMARY – WORKGROUP COLLABORATION
LESSON 4 QUIZ
LAB 4 – ON YOUR OWN

LESSON 5 – FINANCIAL & LOGICAL FUNCTIONS
5.1 USING THE IF FUNCTION
5.2 USING NESTED FUNCTIONS
5.3 USING THE PMT FUNCTION
5.4 USING THE FV FUNCTION
5.5 USING AUTOCALCULATE
LESSON SUMMARY – FINANCIAL AND LOGICAL FUNCTIONS
LESSON 5 QUIZ
LAB 5 – ON YOUR OWN

LESSON 6 – DATE AND TIME FUNCTIONS
6.1 UNDERSTANDING DATE/TIME FUNCTIONS
6.2 ADDING A DATE AND A DATE INTERVAL
6.3 SUBTRACTING DATES
6.4 CALCULATING TIME INTERVALS
LESSON SUMMARY – UNDERSTANDING DATE/TIME FUNCTIONS
LESSON 6 QUIZ
LAB 6 – ON YOUR OWN

LESSON 7 – MANAGING WORKBOOKS
7.1 CREATING A WORKBOOK USING A TEMPLATE
7.2 CREATING A NEW TEMPLATE
7.3 EDITING A TEMPLATE
7.4 SHOWING OR HIDING WORKBOOK ELEMENTS
7.5 CREATING A WORKSPACE
7.6 SAVING A WORKBOOK IN A DIFFERENT FILE FORMAT
7.7 USING DATA CONSOLIDATION
LESSON SUMMARY – MANAGING WORKBOOKS
LESSON 7 QUIZ
LAB 7 – ON YOUR OWN
CLASS PROJECT

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.