Developing a user interface focused on streamlining tasks by utilizing lookup, text, and date functions in correspondence with ActiveX controls. This course also involves creating various Pivot Charts on a communal worksheet analyzed by using data slicers.
Upon completion of this course the user will be able to design worksheets for personal use as well as for other end users with a focus on simplifying input via complex methodology. Additionally, the user will define various Pivot Tables and Charts in order to analyze and slice data.
VLOOKUP, CONCATENATE, and Date functions; exploring ActiveX controls, Pivot Tables, Pivot Charts, chart dashboards, using timeline and multiple data slicers