On-Site Training: Houston, TX
  • 0Shopping Cart
Houston Computer Classes
    (312) 818-5515
  • Home
  • Classes & Tutoring
      • View All Excel Classes
      • Microsoft Excel Class – Introduction
      • Microsoft Excel Class – Intermediate
      • Microsoft Excel Class – Advanced
      • Microsoft Excel VBA Training – Introduction to Macros
      • Microsoft Excel Automation – Automate Repetitive Tasks
      • Microsoft Excel Tutoring
      • Microsoft Excel Consulting Services
      • PowerPoint Classes
      • WordPress Class – Introduction
      • WordPress Training – Intermediate
      • WordPress Training – Build While You Learn
      • WordPress Tutoring
    • Development & Design
      • HTML Introduction Class
      • CSS Introduction Class
      • Advanced CSS Selectors Course
      • CSS Media Queries for Responsive Web Design
      • Bootstrap Classes – Responsive Web Design
      • Joomla! Training
      • SQL Classes
      • MySQL Training – Introduction
      • JavaScript Classes
      • JQuery Training
      • Python Introduction Class – Programming
      • HTML Tutoring
      • CSS Tutoring
    • Marketing
      • SEO Classes
      • SEO Consulting
      • Google AdWords Classes (PPC Advertising)
      • Google Tag Manager Training Class – Chicago, IL
      • PPC Classes (Pay-per-Click)
      • PPC (AdWords, BingsAds) Consulting
      • Google Analytics Training
  • Services
    • Chicago Web Design & Development Company
    • Microsoft Excel Automation – Automate Repetitive Tasks
  • Plugins
  • Customer Service
  • Clients
  • Locations
  • Search

Archive for category: Classes

You are here: Home / Classes
Excel Tutoring

Microsoft Excel Class – Intermediate

May 1, 2014/in Classes, Excel, Office /by admin

Microsoft Excel Class – Intermediate


$1699.99 - One Day Class

Add More Students:
$60 per each Additional Student

6hr Class with 1hr Break


  • Not Just Teachers

    Classes are held by a professional with real-life day to day advanced Excel experience. We try to concentrate our focus on training students to be ready for working environment.

  • OnSite Training

    At your office, home, conference room.. you name it. Training at your location, at your convenience.

  • Not Enough?

    Sessions can & will be catered to your particular needs.

Request a Session

Please wait...

Questions?

(312) 818-5515


Excel Tutoring


How Does it Work?



Request

Request a tutoring session.

Get Confirmation

Our team member will review your request and get back to you shortly to finalize your appointment. If we are booked for the date/time you specified in your request we'll work with you to find a different date and time that suits you.

Done!

That's it! Enjoy your session at your location!

Intermediate Excel Course Includes:

Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet

Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Analyzing Data Using PivotTables and PivotCharts

  • Create a PivotTable Report
  • Analyze Data Using PivotCharts

Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
* 1 student is allowed per tutoring session. If you need more participants rate changes will apply and we need to be notified beforehand.

* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
https://www.houstoncomputerclasses.com/wp-content/uploads/2014/04/ZA1042291391.png 75 170 admin https://www.houstoncomputerclasses.com/wp-content/uploads/2015/01/ccclogo.svg admin2014-05-01 19:17:102025-02-13 03:17:19Microsoft Excel Class - Intermediate
Excel Tutoring

Microsoft Excel Class – Introduction

April 29, 2014/in Classes, Excel, Office /by admin

Microsoft Excel Class – Introduction


$1599.99 - One Day Class

Add More Students:
$60 per each Additional Student

6hr Class with 1hr Break


  • Not Just Teachers

    Classes are held by a professional with real-life day to day advanced Excel experience. We try to concentrate our focus on training students to be ready for working environment.

  • OnSite Training

    At your office, home, conference room.. you name it. Training at your location, at your convenience.

  • Not Enough?

    Sessions can & will be catered to your particular needs.

Request a Session

Please wait...

Questions?

(312) 818-5515


Excel Tutoring


How Does it Work?



Request

Request a tutoring session.

Get Confirmation

Our team member will review your request and get back to you shortly to finalize your appointment. If we are booked for the date/time you specified in your request we'll work with you to find a different date and time that suits you.

Done!

That's it! Enjoy your session at your location!

Microsoft Excel Introduction Course Includes

  • Starting Microsoft Excel
  • The Excel screen
  • Using the ribbon
  • Using keytip badges
  • Minimising the ribbon
  • Using shortcut menus
  • Launching dialog boxes
  • Customising the quick access toolbar
  • The office button
  • Using the office button
  • The status bar
  • Customising the status bar
  • Exiting safely from Microsoft Excel

Creating a new workbook

  • Understanding workbooks
  • Using the blank workbook template
  • Typing text into a worksheet
  • The ‘Save As’ dialog box
  • Saving a new workbook
  • Typing numbers into a worksheet
  • Typing simple formulas in a worksheet
  • Easy formulas
  • Typing dates in a worksheet
  • Easy formatting
  • Checking spelling in a worksheet
  • Making and saving changes
  • Printing a worksheet
  • Safely closing a workbook

Working with workbooks

  • Opening an existing workbook
  • Moving about a worksheet
  • Moving about a workbook
  • Going to a specific location
  • The ‘Open” dialog box

Editing in a workbook

  • Understanding data editing
  • Overwriting cells contents
  • Editing longer cell entries
  • Editing formulas
  • Editing functions
  • Clearing a cell
  • Deleting in a worksheet
  • Undoing and redoing operations

Formulas and functions

  • Understanding formulas
  • Creating formulas that add
  • Creating formulas that subtract
  • Formulas that multiply and divide
  • Understanding functions
  • Using the SUM function to add
  • Summing non-contiguous ranges
  • Calculating an average
  • Finding a maximum value
  • Finding a minimum value
  • More complex formulas
  • What If formulas

Formula referencing

  • Absolute versus relative referencing
  • Relative formulas
  • Problems with relative formulas
  • Creating absolute references
  • Creating mixed references

Selecting ranges

  • Understanding ranges
  • Selecting ranges
  • Selecting non-contiguous ranges
  • Using special selection techniques
  • Selecting larger ranges
  • Selecting rows
  • Selecting columns
  • Viewing range calculation
  • Creating an input range

Copying Excel data

  • Understanding copying in Microsoft Excel
  • Using fill for quick copying
  • Copying from cell to another
  • Copying from one cell to a range
  • Copying from one range to another
  • Copying relative formulas
  • Copying to a non-contiguous range
  • Copying to another worksheet
  • Copying to another workbook

Font formatting

  • Understanding font formatting
  • Working with live preview
  • Changing fonts
  • Changing font size
  • Growing and shrinking fonts
  • Making cells bold
  • Italicising text
  • Underlining text
  • Changing font colours
  • Changing background colours
  • Using the format painter
  • Applying strikethrough
  • Subscripting text
  • Superscripting text

Cell alignment

  • Understanding cell alignment
  • Aligning right
  • Aligning to the centre
  • Aligning left
  • Aligning top
  • Aligning bottom
  • Aligning to the middle
  • Rotating text
  • Indenting cells
  • Wrapping and merging text
  • Merging and centering
  • Merging cells
  • Unmerging cells

Row and column formatting

  • Approximating column widths
  • Setting precise column widths
  • Setting the default column width
  • Approximating row height
  • Setting precise row heights
  • Hiding rows and columns
  • Unhiding rows and columns

Printing:

  • Understanding printing
  • Previewing before you print
  • Performing a quick print
  • Selecting a printer
  • Printing a range
  • Printing an entire workbook
  • Specifying the number of copies
  • The ‘Print’ dialog box
* 1 student is allowed per tutoring session. If you need more participants rate changes will apply and we need to be notified beforehand.

* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
https://www.houstoncomputerclasses.com/wp-content/uploads/2014/04/ZA1042291391.png 75 170 admin https://www.houstoncomputerclasses.com/wp-content/uploads/2015/01/ccclogo.svg admin2014-04-29 20:29:462025-02-13 03:17:39Microsoft Excel Class - Introduction
HTML Tutoring

HTML Introduction Class

April 29, 2014/in Classes, HTML /by admin

HTML Introduction Class


$439.99 - One Day Class

Add More Students:
$60 per each Additional Student

6hr Class with 1hr Break


  • Classes by a Professional Developer

    Class by a professional web developer that knows all ins and outs. Expect a real professional developer that builds websites on day to day basis.

    This Course Will Cover:

    • HTML Fundamentals
    • Create a few basic web pages.
    • Insert and format text.
    • Apply hyperlinks in all its variations.
    • Structure the content on your web page.
    • Apply styles to some page elements.
    • Insert and control images on your web page.
    • Create, modify, and format a basic layout.
    • More… Course will be extended to more topics as the time allows.
  • OnSite Training

    At your office, home, conference room.. you name it. Training at your location, at your convenience.

  • Not Enough?

    In addition your instructor will be well-versed in other leading technologies such as CSS, PHP, MySQL, Ajax, JavaScript, jQuery etc.

Request a Session

Please wait...

Questions?

(312) 818-5515


HTML Tutoring


How it Works?



Request

Request a tutoring session.

Get Confirmation

Our team member will review your request and get back to you shortly to finalize your appointment. If we are booked for the date/time you specified in your request we'll work with you to find a different date and time that suits you.

Done!

That's it! Enjoy your session at your location!

* 1 student is allowed per tutoring session. If you need more participants rate changes will apply and we need to be notified beforehand.

* The client must provide suitable and safe work environment for the tutor to be able to provide the training.

https://www.houstoncomputerclasses.com/wp-content/uploads/2014/04/HTML5_Logo_5121.png 512 512 admin https://www.houstoncomputerclasses.com/wp-content/uploads/2015/01/ccclogo.svg admin2014-04-29 19:54:052017-02-18 02:30:19HTML Introduction Class
Page 4 of 41234

  • Copy WordPress Pages and PostsAverage Salaries – City of Chicago Fire Police Department EarningsMarch 21, 2017 - 1:56 am
  • Copy WordPress Pages and PostsAverage Salaries – City of Chicago Fire Department EarningsMarch 14, 2017 - 4:51 am
  • Ultimate Google Sheets VLOOKUP Tutorial SeriesMarch 14, 2017 - 4:44 am
  • Google Sheets SPLIT Function Tutorial – Similar to Text to Columns in ExcelMarch 5, 2017 - 11:46 am
  • How to Pull Data From Other SpreadSheets using Google Sheets IMPORTRANGE FunctionMarch 5, 2017 - 11:42 am
Call Us: (312) 818-5515
Locations:

Chicago Computer Classes - River North
300 N LaSalle Street
Suite 4925
Chicago, IL 60654

For Excel Training Call (312) 818-5503



  • Copy WordPress Pages and PostsAverage Salaries – City of Chicago Fire Police Department EarningsMarch 21, 2017 - 1:56 am
  • Copy WordPress Pages and PostsAverage Salaries – City of Chicago Fire Department EarningsMarch 14, 2017 - 4:51 am
  • Ultimate Google Sheets VLOOKUP Tutorial SeriesMarch 14, 2017 - 4:44 am
  • Google Sheets SPLIT Function Tutorial – Similar to Text to Columns in ExcelMarch 5, 2017 - 11:46 am
  • How to Pull Data From Other SpreadSheets using Google Sheets IMPORTRANGE FunctionMarch 5, 2017 - 11:42 am
  • Customer Service
  • Refunds, Cancellations & Billing Policies
  • Privacy Policy
  • Terms of Use
  • SiteMap

Locations Serving: Chicago, Loop, Downtown, North, North-East, North-West and West Suburbs, including Evanston, Northbrook, Schaumburg, Hoffman Estates and Naperville IL.

© Copyright - CHI BRANDER INC.
Scroll to top