EXCEL & ME
Excel is great
Excel offers many simple but great formulas that I use regularly:
concatenate , counta, hlookup ,if, left, min, networkdays, workday, average, column, countblank, pivot, vlookup, indirect, max, month, replace, ctrl+h, subtotal, f5, sumif, weekday, search, roundup, today, weeknum, countif, getpivotdata, isblank, mid, offset, row, sum, transpose, averageif, date, conditional, formatting, charts, graphs, col_index_num, and, or ,right...
Excel is powerful
Understanding Excel formulas allows me to create complex algorithms:
=if(iserror(vlookup($c9, [20170213_push_rev.xlsx] pipe_oppts!$c:$ae,aa$2,0)) ,"",if (vlookup ($c9,[20170213_push_rev.xlsx]pipe_oppts!$c:$ae,aa$2,0)
I create slideshows
Everyone takes photos to create memories, it has become part of our lives. Unfortunately, not many of us have the time to manage them and create a photo slideshow. I have a great experience in this, and happy to get any photos organised.
So, I love Excel
I live with Excel for over 15 years now and love how I can transform a simple database into an informative overview. I think about Excel as a programming language, that allows me to calculate and reveal any detail from any big data.
Excel Solutions
TO MANAGE DATABASE
- Userfriendly Excel Solutions
- Overviews from big database
- Data comparison
- Data consolidation
Pick this service if you are in the need of an Excel Specialist.
