Course ID: 21366 | Course Duration: 1 Day | CEUs: 0

Excel 2003 for Business Training Class

Course ID: 21366

Excel 2003 for Business Training Seminar

Class Type:
   - Can retake the class, for free, up to 3 months.
   - Free forum support for 1 year after class
   - Hands on, goal based
   - Small Classes of 4 to 9 people
   - Fast computers
   - Comfortable chairs, convenient location
   - Patient, Fun, Experienced Trainer

When you are finished with this class you will be able to:
   - Create and manipulate advanced charts
   - Create complex formulas
   - Format text and numbers
   - Effectively maneuver around Excel
   - Understand how to use any predefined functions
   - Feel confident when printing large spreadsheets
   - Understand how to manage Excel databases


	Agenda
	OUTLINE: Lesson 1 What you can do with Excel Cell and Row structure Creating an efficient Excel workspace Quickly entering data using Auto-fill Auto-entries Moving Data Paste Special Lesson 2 Creating formulas manually Creating formulas using paste functions and auto functions Sum, Average, Count, Minimum, MAXIMUM, STANDARD DEVIATION Understanding how to use hundreds of predefined functions Lesson 3 Absolute References and why they are crucial to you Solo Project Monthly global allocation Lesson 4 Formatting Alignment Size Direction Format types Borders Cell width and height Merging cells Lesson 5 Advanced Formatting Custom formatting Conditional Formatting Lesson 6 Charting Quick and dirty charting when your in a rush Advanced data series charting Chart types and when to use them Controlling every aspect of chart formatting such as color, axis scales, 3-D views, etc Lesson 7 Databases How to properly set up an Excel Database to ensure accurate information Auto-filtering Sorting the database Subtotals Solo Project Database creating and sorting Lesson 8 Printing Setting print area Using the Page Break Preview Page Orientation Repeating heading rows Adding headers and footers to your printing area Controlling the annoying "blank pages" and the "stray column" printing problem Printing areas that are not next to each other Lesson 9 Where to find answers to more complex Excel problems Books we have found helpful ?? New York Interactive Media 2008


	Audience
	Examples of people who will benefit greatly from this class: - Those seeking to feel comfortable with most Excel office tasks - Those looking to interview for positions that require up to an intermediate level of Excel.


	Pre-requisites
	Our Excel for Business class is an accelerated level one course. We require that our students have basic computer skills, such as saving/retrieving documents, using a mouse, etc.