Import SQL to Excel,complex formulas,customizable format (2)

par charmw
Portfolio

Well-formatted results of complex calculations after importing from SQL database. Values outside certain thresholds are formatted as specified by the user on the first tab. Values below a different threshold, also configured by the user, are hidden completely. Entire table is sorted, and can be filtered via drop-down arrows in headings. [Edited to protect client's privacy and fit image nicely into portfolio.]

image of username charmw Flag of United States Tucson, United States

Me concernant

EDUCATION -CompTIA A+ Certified Professional IT Technician -Associate of Applied Science, Data Processing -Certificate of Achievement, Information Sciences and Technology COMPUTER LANGUAGES -Visual Basic for Applications -JavaScript -HTML -Many others EXPERIENCE -Developed Excel tools ---Automated processing with multiple files ---Complex calculations ---Workflow management ---Text processing ---Report formatting ---User Interface design -Set up and troubleshooting of computer networks -Maintained multi-user, multitasking system software -Managed multi-user security for an inte rnet site -Developed educational tools and presentations -Provided resources for others as part of Help Desk team -Solved complex and escalated problems -Data Entry: 70+ wpm, 99% accuracy

$10 $ US / h

6 évaluations
3.3

Étiquettes