This data is compiled using public dataset released by the City of Chicago Date Created 2/28/2017 Position Average Salary # Employed FIRST DEPUTY SUPERINTENDENT $197,724 1 CHIEF $185,364 5 GENERAL COUNSEL $170,112 1 DEPUTY CHIEF $168,835 17 SUPERINTENDENT’S CHIEF OF STAFF $162,012 1 COMMANDER $161,324 40 DIR OF HUMAN RESOURCES $150,396 1 DIR OF CAPS $145,476 […]
This data is compiled using public dataset released by the City of Chicago Date Created 2/24/2017 Position Average Salary # Employed FIRE COMMISSIONER $202,728 1 FIRST DEPUTY FIRE COMMISSIONER $197,736 1 DEPUTY FIRE COMMISSIONER $187,680 3 ASST DEPUTY FIRE COMMISSIONER $185,352 3 DISTRICT CHIEF $170,112 11 DEPUTY COMMISSIONER $161,886 2 COORD OF AIR MASK SERVICES $157,776 […]
The ultimate series covering everything you need to know about Google Sheets VLOOKUP function. Most of it applies to Microsoft Excel as well. Make sure you watch the whole series if you want in-depth understanding of VLOOKUP function and everything related. Other functions included: INDEX, MATCH, IFERROR, UNIQUE, QUERY & more.
This Excel macro is useful if you have one or more Excel files where you want to set the column sizes exactly the same as the other workbook. This script will take the current active (selected) workbook (Excel File) as a reference, get all the column widths from the active sheet (selected tab) and apply […]
Suppose you have an Excel file with multiple tabs in the following format and you need to combine them to a single master sheet. This can either be a very long and boring copy/paste work or you can speed up the process by using the VBA code further down on this page. A B C […]
Below is a demonstration of using PowerPoint.Application to open a PowerPoint file and then run a macro that is stored within the PowerPoint file. Make sure you modify “fullpath\p1.pptm” and point it to the full path-filename to your PowerPoint file. Modify the macro name. Macro name must be full macro name with file, module and macro […]
Below is a demonstration of using Application.FileDialog to give the user an option to select a file and then open it. The code is well commented and should be self explanatory. The full file path will be stored in fullpath variable, which is used later in the code to open the file after making sure there […]
Below is a demonstration of using Application.FileDialog to give the user an option to select a file. The code is well commented and should be self explanatory. The full file path will be stored in fullpath variable, which can be used later in the code. An example using the code to prompt the user to […]
Average Salaries – City of Chicago Fire Police Department EarningsMarch 21, 2017 - 1:56 amAverage Salaries – City of Chicago Fire Department EarningsMarch 14, 2017 - 4:51 am
Ultimate Google Sheets VLOOKUP Tutorial SeriesMarch 14, 2017 - 4:44 amGoogle 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
Locations Serving: Chicago, Loop, Downtown, North, North-East, North-West and West Suburbs, including Evanston, Northbrook, Schaumburg, Hoffman Estates and Naperville IL.
