What you'll learn in this excel class:
Learn to create and manipulate advanced charts, understand how to manage Excel databases, create complex formulas, format text and numbers, efficiently maneuver around Excel, understand how to use any predefined functions and feel confident when printing large spreadsheets.Course Outline:Lesson 1What you can do with ExcelCell and Row structure Creating an efficient Excel workspace Quickly entering data using Auto-fill Auto-entries Moving Data Paste Special Lesson 2Creating formulas manually Creating formulas using paste functions and auto functions Sum, Average, Count, Minimum, Maximum, Standard DeviationUnderstanding how to use hundreds of predefined functions Lesson 3Absolute References and why they are crucial to you Solo ProjectMonthly global allocation Lesson 4- FormattingAlignment Size Direction Format types Borders Cell width and height Merging cells Lesson 5- Advanced FormattingCustom formatting Conditional Formatting Lesson 6- ChartingQuick and dirty charting when you are 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- DatabasesHow to properly set up an Excel Database to ensure accurate informationAuto-filtering Sorting the database Subtotals Freezing Rows for easy viewing Solo ProjectDatabase creating and sorting Lesson 8- PrintingSetting 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 Examples of people who will benefit greatly from this class:Those seeking to feel comfortable with most Excel office tasksThose looking to interview for positions that require up to an intermediate level of ExcelMaterialsDetailed reference sheet of everything coveredMultiple XLS and XLT examples for in class and after classShortcut sheetResource sheetStudents will receive a Certificate of Completion at the end of this course and may retake the same course as many times as they want.
Positive : 
Negative : 
Reviews of School (3)
Kate Maitland
Posted on
03/02/2013
Excel 2011 for Mac Business Group Class
Fabulous excel class. Scott was a great teacher. I would like to sign up for the WORD class now. When are they offered? Also, I would like a certificate for the EXCEL class to prove that I took it. Thank you, Kate Kate Maitland
Joanna Neuberg
Posted on
01/26/2013
Advanced Excel 2007-2010 for Business Group Class
Excellent class and teacher
Michael
Posted on
05/24/2012
Photoshop Essentials
My class turned out to be great. I was the only student so I got a private lesson and we moved along at my pace. This turned out especially well since I knew some Photoshop before the class.