On-Site Training: Chicago, North, North-East, North-West and West Suburbs, including Schaumburg, Hoffman Estates and Naperville.
  • 0Shopping Cart
Chicago Excel Classes
(312) 818-5503
    • Classes
      • Excel Classes
    • On-Site & Staff Training
    • Workshops
    • Tutoring
      • Microsoft Excel Tutoring
    • Need a Macro?
      • Microsoft Excel Automation – Automate Repetitive Tasks
      • Get a Quote
      • Clients
    • Customer Service
    • Search

    Archive for category: Office

    You are here: Home / Office
    Excel Training Session

    Microsoft Excel VBA Training – Introduction to Macros

    July 1, 2015/in Classes, Excel, Office /by admin

    Microsoft Excel VBA Class – Introduction to Macros


    $1739.99 -  up to 10 attendees

    Add More Students:
    $60 per each Additional Student

    One Day


    • 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-5503


    Excel Training Session


    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!

    * 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.chicagoexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.chicagoexcelclasses.com/wp-content/uploads/2013/04/ccclogo1.png admin2015-07-01 20:24:282022-01-27 08:08:34Microsoft Excel VBA Training - Introduction to Macros
    Excel Training Session

    Microsoft Excel Class – Advanced

    July 1, 2015/in Classes, Excel, Office /by admin

    Microsoft Excel Class – Advanced


    $1639.99 -  up to 10 attendees

    Add More Students:
    $60 per each Additional Student

    One Day


    • 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-5503


    Excel Training Session


    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!

    * 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.chicagoexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.chicagoexcelclasses.com/wp-content/uploads/2013/04/ccclogo1.png admin2015-07-01 20:17:322022-01-27 08:07:41Microsoft Excel Class - Advanced
    Excel Workshop Part 1

    Convert CrossTab Table to Database List Table – Excel VBA Macro Code

    June 13, 2014/in Excel, Learn, Office /by admin

    If you work with databases and regular data tables you probably had a situation when someone gave you a regular Excel 2 dimensional spreadsheet that is not that useful if you need to use the data within a database and run some queries or just make PivotTables in Excel. The Macro code below will transform your CrossTab table to a regular database list table.

    This script will create a new sheet and prompt you to enter a starting point for your converted data. Then it will render the data in 3 columns as a regular database data table.

    Sub CrossTabToDatabase()
     Dim DataTable As Range, OutputRange As Range
     Dim RowOutput As Long
     Dim r As Long, c As Long
    Dim WS As Worksheet
    
    On Error Resume Next
     Set DataTable = ActiveCell.CurrentRegion
     If DataTable.Count = 1 Or DataTable.Rows.Count < 3 Then
     MsgBox "Select a cell within the summary table", vbCritical
     Exit Sub
     End If
     DataTable.Select
    
     Set WS = Sheets.Add
     Set OutputRange = Application.InputBox(prompt:="Select a cell starting where you'd like to output the new datatable.", Type:=8)
    ' Convert the range
     RowOutput = 2
     Application.ScreenUpdating = False
     OutputRange.Range("A1:C3") = Array("Column1", "Column2", "Column3")
     For r = 2 To DataTable.Rows.Count
     For c = 2 To DataTable.Columns.Count
     OutputRange.Cells(RowOutput, 1) = DataTable.Cells(r, 1)
     OutputRange.Cells(RowOutput, 2) = DataTable.Cells(1, c)
     OutputRange.Cells(RowOutput, 3) = DataTable.Cells(r, c)
     OutputRange.Cells(RowOutput, 3).NumberFormat = DataTable.Cells(r, c).NumberFormat
     RowOutput = RowOutput + 1
     Next c
     Next r
    End Sub
    https://www.chicagoexcelclasses.com/wp-content/uploads/2015/03/excel_for_mac_2011_icon1.jpg 420 420 admin https://www.chicagoexcelclasses.com/wp-content/uploads/2013/04/ccclogo1.png admin2014-06-13 16:42:102015-04-02 02:29:14Convert CrossTab Table to Database List Table - Excel VBA Macro Code
    Excel Tutoring

    Microsoft Excel Automation – Automate Repetitive Tasks

    June 12, 2014/in Consulting, Excel, Office /by admin

    Microsoft Excel Automation



    • Automate Repetitive Tasks

      We can automate very complex tasks for Excel. Those repetitive tasks that you had to do before you now don’t have to. We are here to make your life easy and get things done fast.

    • Save Time and Money

      Things you were spending weeks to get done will now be complete within minutes. Think of the savings you were missing all these years!

    • Connect with Other Sources and API

      Not only we automate tasks in Excel, we connect it with other data sources, APIs and World Wide Web. Now your Excel documents can come to life like they never did before.

    Request a Quote

    Please wait...

    Questions?

    (312) 818-5503


    Excel Training Session


    How it Works?



    Request

    Request a Quote.

    Confirm

    Our team member will review your request and get back to you shortly with any questions answers of which are required to give you a valid quote and time-frame. Once you receive the final quote and you approve moving on with the project we'll get to work.

    Done!

    That's it!

    https://www.chicagoexcelclasses.com/wp-content/uploads/2014/04/ZA1042291391.png 75 170 admin https://www.chicagoexcelclasses.com/wp-content/uploads/2013/04/ccclogo1.png admin2014-06-12 20:15:022017-05-03 07:01:47Microsoft Excel Automation - Automate Repetitive Tasks
    Excel Training Session

    Microsoft Excel Class – Intermediate

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

    Microsoft Excel Class – Intermediate


    $1539.99 -  up to 10 attendees

    Add More Students:
    $60 per each Additional Student

    One Day


    • 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-5503


    Excel Training Session


    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!

    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.chicagoexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.chicagoexcelclasses.com/wp-content/uploads/2013/04/ccclogo1.png admin2014-05-01 19:17:102022-01-27 08:02:40Microsoft Excel Class - Intermediate
    Excel Training Session

    Microsoft Excel Class – Introduction

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

    Microsoft Excel Class – Introduction


    $1439.99 -  up to 10 attendees

    Add More Students:
    $60 per each Additional Student

    One Day


    • 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-5503


    Excel Training Session


    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!

    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

    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.chicagoexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.chicagoexcelclasses.com/wp-content/uploads/2013/04/ccclogo1.png admin2014-04-29 20:29:462022-01-27 08:01:35Microsoft Excel Class - Introduction
    Excel Tutoring

    Microsoft Excel Tutoring

    April 25, 2014/in Office, Tutoring /by admin

    Microsoft Excel Tutoring


    $95/hr - 3 hour minimum

    Add More Students:
    $25/hr per each Additional Student


    • Not Just Teachers

      Tutoring by a professional with real-life day to day advanced Excel experience. Our tutors are not just teachers by the book, they all work on complicated Excel spreadsheets in real life application scenarios. We try to concentrate our focus on teaching the features with some shortcuts, logical organization and workarounds that you won’t find in the book.

    • OnSite Training

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

    • Not Enough?

      All tutoring sessions can and will be catered to your particular needs. Tell us what specifically you want to learn and you will learn just that or we will use our redesigned programs to provide you with best knowledge base possible.

    Request a Session

    N/A
    Please wait...

    Questions?

    (312) 818-5503


    Excel Training Session


    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.chicagoexcelclasses.com/wp-content/uploads/2014/04/ZA1042291391.png 75 170 admin https://www.chicagoexcelclasses.com/wp-content/uploads/2013/04/ccclogo1.png admin2014-04-25 19:38:332017-05-03 07:04:00Microsoft Excel Tutoring

    Contact Us

    Chicago Excel Classes by Chi Brander, Inc.
    200 W Madison St
    Suite 2100
    Chicago, IL 60606

    Please, feel free to call us anytime.
    Call Us: (312) 818-5503
    • Customer Service
    • Cancellations / Refunds
    • Terms of Use
    • Privacy Policy

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

    © Copyright - Chi Brander Inc.
    Scroll to top