: Publication

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

COMPONENTS OF THE MANUAL
TRAINING FILES
WHAT’S NEW IN EXCEL 2016?

LESSON 1 - EXCEL BASICS
1.1 CREATING AN EXCEL WORKBOOK
1.2 EXAMINING THE EXCEL ENVIRONMENT
1.3 OPENING AN EXISTING WORKBOOK
1.4 NAVIGATING A WORKSHEET
1.5 CREATING A NEW WORKBOOK
1.6 SAVING A NEW WORKBOOK
1.7 MOVING BETWEEN WORKBOOKS
1.8 SETTING EXCEL OPTIONS
1.9 SWITCHING BETWEEN VIEWS
1.10 USING TELL ME TO OBTAIN HELP
1.11 CLOSING A WORKBOOK AND EXITING 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
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
2.11 USING SMART LOOKUP
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 OFFICE CLIPBOARD
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
3.10 FILLING IN CELLS USING FLASH FILL
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 AND CENTERING TEXT
4.7 ADDING CELL BORDERS
4.8 APPLYING COLORS AND SHADING TO CELLS
4.9 APPLYING CELL STYLES
4.10 HIDING AND UNHIDING ROWS AND COLUMNS
4.11 FREEZING AND UNFREEZING ROWS AND 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 THE INSERT FUNCTION BUTTON
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.