Please copy the following into the notepad, change the suffix to .bat @echo off setlocal enabledelayedexpansion for %%F in (*.txt) do ( set /p .=Processing [%%~F] … <nul set “firstline=” (for /f “tokens=* usebackq” %%a in (“%%~nxF”) do ( if not defined firstline ( set firstline=%%a echo !firstline:”=! ) else …
Please copy the following into the notepad, change the suffix to .bat for /f %%a in (‘dir /b *.CSV’) do for /f “tokens=*” %%b in (%%a) do echo %%b,%%a >> all.csv Place it in your folder, together with all other .csv file. Double click .bat file, it will generate the …
This video shows how to use excel to do auto fill
You can use sparklines to show trends in a series of values. This video demos how to create sparklines, adjust axis, change color and change sparkline type.
This video demos how to use excel countifs and sumifs to perform summary based on multiple conditions
CSV Splitter – http://www.fxfisherman.com/forums/forex-metatrader/tools-utilities/75-csv-splitter-divide-large-csv-files.html. Google earth can only deal with 2400 points. If you are going to have more than that, you need this tool. Sydney had ~90,000 water meters in Florida. HINT: A bunch of addresses might get kicked out. If you see a pattern of mistakes, fix them …
1. Convert to table and name the name, as following example named as “Products” Table 2. Excel options -> Add-ins ->Manage -> COM Add-ins-> Go -> turn on the powerpivot 3. Powerpivot -> Add to Data Model for all of the tables 4. Powerpivot -> Manage ->Diagram view -> connect …
