- Can get the charts generated which can be used in the Powerpoint decks.
- Have done some complicated reporting as well including Scatter(ubound), Surface charts and the normal Pie, Bar and Line graphs.
- Used dynamic coordinates, setting x value and y values, dynamic colouring for the legends.
- Please have a look on my portfolio one of the complex projects done on charting. The number of graphs itself is dynamic depending on the number of months for which the graphs are run.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl
Sample HighComplex Projects using Macros: (via Freelancer)
- Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors
- Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations.
- System log generation (users logged in time, duration, days) between time period