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.
At your office, home, conference room.. you name it. Training at your location, at your convenience.
Sessions can & will be catered to your particular needs.
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.
At your office, home, conference room.. you name it. Training at your location, at your convenience.
Sessions can & will be catered to your particular needs.
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
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.
Things you were spending weeks to get done will now be complete within minutes. Think of the savings you were missing all these years!
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.
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.
At your office, home, conference room.. you name it. Training at your location, at your convenience.
Sessions can & will be catered to your particular needs.
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.
At your office, home, conference room.. you name it. Training at your location, at your convenience.
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.
Locations Serving: Washington, DC and surrounding areas.