On-Site Excel Training in Washington, DC.
  • 0Shopping Cart
Washington DC Excel Classes
(202) 838-5550
    • Classes
      • Excel Classes
    • On-Site & Staff Training
    • Workshops
    • Tutoring
      • Microsoft Excel Group Tutoring
    • Need a Macro?
      • Microsoft Excel Automation – Automate Repetitive Tasks
      • Get a Quote
      • Clients
    • Customer Service
    • Search

    Archive for category: Excel

    You are here: Home / Excel
    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


    $1,739.99 -  One Day
    Price is valid for up to 10 attendees

    For groups over 10
    add $60 per additional attendee

    For groups over 30 contact us for an estimate


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

    [avia_codeblock_placeholder uid="0"]

    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.washingtondcexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2015-07-01 20:24:282020-02-14 16:28:36Microsoft 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


    $1,639.99 -  One Day
    Price is valid for up to 10 attendees

    For groups over 10
    add $60 per additional attendee

    For groups over 30 contact us for an estimate


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

    [avia_codeblock_placeholder uid="2"]

    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.washingtondcexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2015-07-01 20:17:322020-02-14 16:31:30Microsoft Excel Class - Advanced
    Excel Workshop Part 1

    Data in a Column to a Single Cell Separated by Commas – Macro VBA

    March 31, 2015/in Excel, Learn /by admin

    This macro is useful in case you have a data table in the following format and you want to transform it to a single cell separated by commas.

    43680
    43681
    43659
    43677
    43578
    43522

     

    Preferred Results:

    43680;43681;43659;43677;43578;43522

     

    Excel Macro:

    Option 1:

    Sub ConcatColumnValues()
      Range("B1") = Join(Application.Transpose(Range("A1", Cells(Rows.Count, "A").End(xlUp))), ";")
    End Sub

    Option 2:

    Public Sub TextEr()
    rs = Rows.Count
    lr = Cells(rs, 1).End(xlUp).Row
    stxt = ""
    For Each oj In Range("A1:A" & lr)
    If stxt = "" Then
    stxt = oj
    Else
    stxt = stxt & ";" & oj
    End If
    Next oj
    Range("b1").NumberFormat = "@"
    Range("b1") = stxt
    End Sub
    https://www.washingtondcexcelclasses.com/wp-content/uploads/2015/03/excel_for_mac_2011_icon1.jpg 420 420 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2015-03-31 15:10:062015-04-02 15:16:07Data in a Column to a Single Cell Separated by Commas - Macro VBA
    Excel Workshop Part 1

    From Several Columns to a Single Column with a Formula

    March 27, 2015/in Excel, Learn /by admin

    This formula is useful in case you have a data table in the following format and you want to transform it to “Preferred Results” format.

    A-Data-1 B-Data-1 C-Data-1 D-Data-1
    A-Data-2 B-Data-2 C-Data-2 D-Data-2
    A-Data-3 B-Data-3 C-Data-3 D-Data-3
    A-Data-4 B-Data-4 C-Data-4 D-Data-4

    Preferred Results:

    A-Data-1
    A-Data-2
    A-Data-3
    A-Data-4
    B-Data-1
    B-Data-2
    B-Data-3
    B-Data-4
    C-Data-1
    C-Data-2
    C-Data-3
    C-Data-4
    D-Data-1
    D-Data-2
    D-Data-3
    D-Data-4

    Excel Formula:

    $A$1:$D$4 – change to your data range

    A$7:A7 – change to the first cell where your results data begins. In our example that would be the cell holding A-Data-1 data.

    Apply the formula to the first data results cell and fill down.

    =INDEX($A$1:$D$4,MOD(ROWS(A$7:A7)+ROWS($A$1:$D$4)-1,ROWS($A$1:$D$4))+1,INT((ROW()-ROW($A$7))/ROWS($A$1:$D$4))+1)

    https://www.washingtondcexcelclasses.com/wp-content/uploads/2015/03/excel_for_mac_2011_icon1.jpg 420 420 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2015-03-27 14:52:152015-04-02 15:15:43From Several Columns to a Single Column with a Formula
    Excel Workshop Part 1

    Add a New WorkSheet in Excel – VBA Macro Code

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

    This VBA code will add a new worksheet in your Excel project.

    Sub AddNewWorksheet()
    
     Dim NewWorkSheet As Worksheet
     Set NewWorkSheet = Sheets.Add
    
    End Sub
    https://www.washingtondcexcelclasses.com/wp-content/uploads/2015/03/excel_for_mac_2011_icon1.jpg 420 420 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2014-06-13 16:52:442015-04-02 02:28:53Add a New WorkSheet in Excel - VBA Macro Code
    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.washingtondcexcelclasses.com/wp-content/uploads/2015/03/excel_for_mac_2011_icon1.jpg 420 420 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.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.washingtondcexcelclasses.com/wp-content/uploads/2014/04/ZA1042291391.png 75 170 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2014-06-12 20:15:022017-05-03 07:01:47Microsoft Excel Automation - Automate Repetitive Tasks
    Excel Workshop Part 1

    Delete All Hidden Columns and Rows – VBA Excel – Code

    June 12, 2014/in Excel, Learn /by admin

    This VBA code can help you delete all hidden columns and rows from your excel sheet with a click of a button.

    Sub hiddendelete()
    For lp = 256 To 1 Step -1 'loop through all columns
    If Columns(lp).EntireColumn.Hidden = True Then Columns(lp).EntireColumn.Delete Else
    Next
    For lp = 65536 To 1 Step -1 'loop through all rows
    If Rows(lp).EntireRow.Hidden = True Then Rows(lp).EntireRow.Delete Else
    Next
    End Sub
    https://www.washingtondcexcelclasses.com/wp-content/uploads/2015/03/excel_for_mac_2011_icon1.jpg 420 420 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2014-06-12 19:54:492015-04-02 02:29:39Delete All Hidden Columns and Rows - VBA Excel - Code
    Excel Training Session

    Microsoft Excel Class – Intermediate

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

    Microsoft Excel Class – Intermediate


    $1,539.99 -  One Day
    Price is valid for up to 10 attendees

    For groups over 10
    add $60 per additional attendee

    For groups over 30 contact us for an estimate


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

    [avia_codeblock_placeholder uid="4"]

    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.washingtondcexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2014-05-01 19:17:102020-02-14 16:30:40Microsoft Excel Class - Intermediate
    Excel Training Session

    Microsoft Excel Class – Introduction

    April 29, 2014/in Classes, Excel, Office /by admin
    https://www.washingtondcexcelclasses.com/wp-content/uploads/2014/05/excel_training@2x1.png 464 1152 admin https://www.washingtondcexcelclasses.com/wp-content/uploads/2017/10/washingtondcexcelclasseslogo.png admin2014-04-29 20:29:462020-02-14 17:17:49Microsoft Excel Class - Introduction

    Contact Us

    Washington, DC Excel Classes by Chi Brander, Inc.
    Phone: (202) 838-5550
    Address: 1250 Connecticut Ave NW
    Suite 700
    Washington, DC 20036

    Please, feel free to call us anytime.
    • Customer Service
    • Cancellations / Refunds
    • Terms of Use
    • Privacy Policy

    Locations Serving: Washington, DC and surrounding areas.

    © Copyright - Chi Brander Inc.
    Scroll to top