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
add $60 per additional attendee
For groups over 30 contact us for an estimate
[avia_codeblock_placeholder uid="0"]
Questions?
(312) 818-5503
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.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
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
add $60 per additional attendee
For groups over 30 contact us for an estimate
[avia_codeblock_placeholder uid="2"]
Questions?
(312) 818-5503
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.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
Convert CrossTab Table to Database List Table – Excel VBA Macro Code
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
Microsoft Excel Automation
Questions?
(312) 818-5503
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!
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
add $60 per additional attendee
For groups over 30 contact us for an estimate
[avia_codeblock_placeholder uid="4"]
Questions?
(312) 818-5503
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.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
Microsoft Excel Tutoring
$1000 minimum
Select Hours and # of Participants for an Estimate
Questions?
(312) 818-5503
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.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
Locations Serving: Washington, DC and surrounding areas.