: Publication

Excel 2011 (Level 1) 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 1 – INTRODUCTION

COMPONENTS OF THE MANUAL
WHAT’S NEW IN EXCEL 2011?

LESSON 1 - EXCEL BASICS
1.1 CREATING AN EXCEL WORKBOOK
1.2 EXAMINING THE EXCEL ENVIRONMENT
1.3 USING MENUS AND TOOLBARS
1.4 USING THE RIBBON
1.5 OPENING AN EXISTING WORKBOOK
1.6 NAVIGATING A WORKSHEET
1.7 CREATING A NEW WORKBOOK
1.8 SAVING A NEW WORKBOOK
1.9 MOVING BETWEEN WORKBOOKS
1.10 SETTING EXCEL PREFERENCES
1.11 SWITCHING BETWEEN VIEWS
1.12 USING HELP
1.13 CLOSING A DOCUMENT AND EXITING MICROSOFT EXCEL
LESSON SUMMARY – EXCEL BASICS
LESSON 1 QUIZ
LAB 1 – ON YOUR OWN

LESSON 2 – WORKING WITH DATA
2.1 ENTERING TEXT AND NUMBERS
2.2 ENTERING SIMPLE FORMULAS
2.3 CHOOSING FORMULA CELL REFERENCES MANUALLY
2.4 USING AUTOSUM
2.5 CHANGING & DELETING DATA
2.6 USING UNDO/REDO
2.7 USING FIND AND REPLACE
2.8 USING THE GO TO COMMAND
2.9 SPELL CHECKING YOUR WORKSHEET
2.10 INSERTING SYMBOLS
LESSON SUMMARY – WORKING WITH DATA
LESSON 2 QUIZ
LAB 2 – ON YOUR OWN

LESSON 3 – EDITING A WORKSHEET
3.1 WORKING WITH RANGES
3.2 COPYING AND PASTING DATA
3.3 USING THE SCRAPBOOK
3.4 CUTTING AND PASTING DATA
3.5 COPYING AND MOVING CELLS USING DRAG-AND-DROP
3.6 CHANGING COLUMN WIDTH
3.7 CHANGING ROW HEIGHT
3.8 INSERTING AND REMOVING ROWS AND COLUMNS
3.9 COPYING DATA AND FORMULAS WITH AUTOFILL
LESSON SUMMARY – EDITING TEXT
LESSON 3 QUIZ
LAB 3 – ON YOUR OWN

LESSON 4 – FORMATTING A WORKSHEET
4.1 FORMATTING TEXT
4.2 USING THE FORMAT CELLS DIALOG BOX
4.3 FORMATTING VALUES
4.4 USING THE FORMAT PAINTER BUTTON
4.5 ALIGNMENT AND TEXT WRAPPING
4.6 MERGING CELLS
4.7 ADDING CELL BORDERS
4.8 APPLYING COLORS AND SHADING TO CELLS
4.9 APPLYING CELL STYLES
4.10 HIDING AND UNHIDING ROWS & COLUMNS
4.11 FREEZING AND UNFREEZING ROWS & COLUMNS
4.12 INSERTING AND REMOVING PAGE BREAKS
LESSON SUMMARY – FORMATTING A WORKSHEET
LESSON 4 QUIZ
LAB 4 – ON YOUR OWN

LESSON 5 – PAGE SETUP AND PRINTING
5.1 ADJUSTING MARGINS
5.2 SETTING PAGE ORIENTATION
5.3 SETTING PAPER SIZE
5.4 DEFINING A PRINT AREA
5.5 PRINTING WORKSHEET TITLES
5.6 FORCING A WORKSHEET TO FIT
5.7 INSERTING HEADERS AND FOOTERS
5.8 PRINTING A WORKSHEET
LESSON SUMMARY – WORKING WITH PAGES
LESSON 5 QUIZ
LAB 5 – ON YOUR OWN

LESSON 6 – FORMULAS AND FUNCTIONS
6.1 RELATIVE REFERENCES
6.2 ABSOLUTE REFERENCES
6.3 MIXED REFERENCES
6.4 COPYING FORMULAS
6.5 MIN, MAX, COUNT AND AVERAGE FUNCTIONS
6.6 USING THE FORMULA BUILDER
LESSON SUMMARY – FORMULAS AND FUNCTIONS
LESSON 6 QUIZ
LAB 6 – ON YOUR OWN

LESSON 7 – MODIFYING WORKBOOKS
7.1 ADDING AND DELETING WORKSHEETS
7.2 COPYING WORKSHEETS
7.3 RENAMING WORKSHEETS
7.4 REPOSITIONING WORKSHEETS
7.5 GROUPING WORKSHEETS
7.6 CHANGING WORKSHEET TAB COLORS
7.7 USING 3-D FORMULAS & REFERENCES
LESSON SUMMARY – MODIFYING WORKBOOKS
LESSON 7 QUIZ
LAB 7 – ON YOUR OWN
CLASS PROJECT – NEW PRODUCTS

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.