Skip Main Navigation
Page Content
This event has ended

Beginning Excel - 6-12-2013

Training Tamer Inc.

Wednesday, June 12, 2013 from 1:00 PM to 4:30 PM (EDT)

Beginning Excel - 6-12-2013

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Beginning Excel Workshop - 6-12-013, 1:00 - 4:30 PM   more info 23 Tickets Ended $10.00 $1.54

Share Beginning Excel - 6-12-2013

Event Details

Beginning Excel Course Description:

This three hour class is a hands-on training session that will cover basic features of Microsoft Excel.  The class will use real world business problems as the focus for teaching all the concepts and students will do an exercise after each topic to practice what they have learned.


          NOTE:  You must cancel at least 72 hours before the workshop begins to get a refund!

 
Prerequisites:

Microsoft Windows 2000/XP/7, Mouse Usage, and Typing (30 WPM)

Course Topics:

1.      How to run Microsoft Excel

2.      Display or hide toolbars

3.      Define distinction between spreadsheet and workbook

4.      Cell as the core element where data is entered in a spreadsheet

5.      Identifying cells via row and column designators (e.g. A1)

6.      Moving from cell to cell (Mouse Click into any cell, Tab to move to cell to right, Enter
      to move to cell below)

7.      Enter data into an empty cell

8.      Edit data currently in a cell

9.      Create basic spreadsheet structure and enter data

§  Spreadsheet title (if embedded in spreadsheet)

§  Row and column titles

§  Data

10.  Name a spreadsheet

11.  Save and name a new workbook for the first time

12.  Save additions/changes to a workbook

13.  Set autosave option to automatically save your file every X minutes

14.  Exit Microsoft Excel

15.  Open an existing worksheet to edit it

16.  Format spreadsheet

§  Create titles that span multiple columns by merging the contents of cells

§  Change the font and point size of data in a cell

§  Format the data in a cell (bold, italicize, underline, color)

§  Position the data in a cell (align left , center, or align, right, or justify/block)

§  Change the data type/display format of data in a cell (e.g. displaying a number like
   14.4 as currency like $14.40)

§  Resize column width or row height

§  Autowrap text within a cell (to avoid making an extra wide text cell)


§  Align data within a cell either vertically or horizontally

§  Add printable borders around a cell or group of cells

§  Shade the background of a cell or group of cells

§  Insert new rows or columns in a spreadsheet

17.  Inserting explanatory comments in cells (e.g. to explain what to put in a cell) and
      editing these comments

18.  Cut and paste data within a spreadsheet

19.  Create formulas

§  Row and column references (relative, absolute, and mixed)

§  Sum up data in non-contiguous cells in a row or column

§  Sum up data in contiguous cells in a row or column using SUM formula

§  Use an existing row/column total formula to automatically create equivalent
   formulas for other columns

§  Add today’s date to spreadsheet

20.  Create additional spreadsheets in the workbook

21.  Create cross-spreadsheet formulas

22.  Change spreadsheet setup for display and printing  (changes only impact currently
      open spreadsheet)

§  Scaling  the data so it fits horizontally on page without spilling over to another page

§  Set the paper orientation (portrait or landscape)

§  Change the size of the margins (top and bottom and/or left and right)

§  Change the size of the page header and footer

§  Create custom headers and footers to appear on each page

§  Force  column titles to print on each page of a multiple page spreadsheet

23.  Preview what the printed result of a spreadsheet will look like

§  Zoom in to full spreadsheet full size

§  Access Page Setup to make changes

§  View and alter margins

24.  Print out a copy of a spreadsheet or the entire workbook

§  Set global print options

       Number of pages to print from each spreadsheet

       Portion of spreadsheet or workbook to print

       Number of copies to print

§  Use Properties button

       Set page orientation (portrait or landscape) for all spreadsheet in workbook
     (overrides spreadsheet specific setting done with via File|Page Setup)

       Set page order for printing  (front to back or back to front)

       Set the number of spreadsheet pages to print on a physical page

25.  Open multiple workbooks and copy data from one and paste into the other

 

Have questions about Beginning Excel - 6-12-2013? Contact Training Tamer Inc.
Attendee List Sort by: Date | First Name | Last Name
Show More

When & Where


Strayer University
4902 S. Eisenhower Blvd
Presidents Plaza, Suite 200, Room 207
Tampa, FL 33634

Wednesday, June 12, 2013 from 1:00 PM to 4:30 PM (EDT)


  Add to my calendar

Organizer

Training Tamer Inc.

Training Tamer provides training, coaching and support services for job seekers and employers.  We help job seekers win a job fast and we enable employers to hire and retain Grade A Talent!

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.