Discussing the all Date and Time functions and also how to deal with Complex Date and Time formats.
How dates are stored in excel and if we need to break down.
How times are stored in excel and what happens if you want to split the time into seconds or minutes or hours.
How to split date and time - its a science which you need to understand. What happens behind the scenes.
Complete walk-through on OFFSET function.
OFFSET as a normal function - for movements
OFFSET as an array function - customize your data using it.
Charts making and important key points to be considered before making them.
Use and role of OFFSET in charts - Super advance
Know your ActiveX Controls and Form Controls - Extremely powerful and helpful in making dashboards
Option buttons, combo boxes, List Boxes, Check box controls and many more.
How these controls work in excel. What is the catch - that we need to understand
How to design Active X controls
How to design FormX controls- from drawing them to editing them what type of problems you may face in the beginning.
Are they like data validations or totally different.
Which one you should choose between ActiveX and FormX controls in terms of functioning and formatting.
How do you see if your controls are in edit mode or not and how to change these phases one by one like from working phase to editing phase. Its mesmerizing.
We will learn how to make Charts like pie chart, Treemap chart, column chart, stacked charts, line graphs, bar charts, doughnut charts.
How to edit charts fields if required, Get familiar with chart source data.
Why to use data as Tables if we are using them in charts - advantages.
How to supply top 50% data or bottom 50% or whatever in Charts
Create secondary axis - why do we need to do it.
How to handle problems if your data in x axis and y axis has number formats. Every aspect of chart is discussed.
Legends, Formatting Axis of charts, Color Series, Gridlines - All chart component are discussed.
