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.
Course Objectives:
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.
Course Highlights:
VLOOKUP, CONCATENATE, and Date functions; exploring ActiveX controls, Pivot Tables, Pivot Charts, chart dashboards, using timeline and multiple data slicers
