Basic Excel
The badge recipient developed the ability and knowledge of creating an income statement, statement of equity, balance sheet and making adjustments on a worksheet.
Earners of this badge developed and enhanced their skills based on the objectives listed below:
- Mastery of an array of Excel formulas and functions
- Design and organize worksheet to include usage of charts and
graphs
- Usage of shortcut menus
- Solve common printing and output problems
- Mastery of Marcos
- Excel Workbooks
- How to solve problems in excel using Help tool efficiently
- How to select cells or ranges of cells
- How to quickly find a single file or a particular workbook
- Build a worksheet from the ground up
- Copy and quickly move data utilizing shortcuts
- How to zoom in or zoom out of the worksheet
- Techniques to freeze titles in place while moving around in a
worksheet
- Formula and Function basics
- Mathematical formulas: how to subtract, multiply or divide
data
- Basic Excel functions to calculate averages, percentages and
more using built-in predefined formulas
- Techniques for producing visually exciting worksheets
- Formatting guidelines for attractive, readable worksheets
- How to control alignment, decimals, dollar signs and more using
one operation
- Fonts, shading and borders that increase the readability and
attractiveness of worksheets
- Print Options: How to customize printing
- How to add headers, footers and page numbers to a worksheet
- How to set manual page breaks and ensure your titles and
labels print on every page
- Understand terms commonly used in charting and graphing data
- How to produce vivid, exciting charts to accompany data
- Knowledgeable about chart placement: embedded charts,
separate charts and chart sheets within a workbook
- Knowledgeable about using large worksheets with Split Windows
- Database basics
- Keyboard shortcuts
- How to automate tasks using macros
Earners of this badge are students enrolled in a basic accounting and bookkeeping course offered by Community Action Partnership of Providence (CAPP). This badge is part of a group of badges that can be found here:
http://www.badgelist.com/CAPP-Accounting-BookkeepingThe administrative account that grants this badge is owned and operated by Community Action Partnership of Providence (CAPP). Other CAPP badges can be found here:
http://www.badgelist.com/u/CAPPFor more information about this class or one of the many other services and programs offered by CAPP to Providence residents please visit
http://www.cappri.org/
Community Action Partnership of Providence
518 Hartford Avenue | Providence, Rhode Island 02909
Tel. 401.273.2000 | Fax. 401.228.3078 |
http://www.cappri.org/