Basic to Advance Excel -Series5

Basic to Advance Excel -Series5

• 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.

Date and Time functions, OFFSET Function, Charts and Form/ActiveX controls - Basic to Super advance

Url: View Details

What you will learn

• You will be able to create all type Basic and Advance dynamic Charts
• Form Controls or ActiveX controls and it will give you a vision on creating dashboards.
• Learn Date and Time functions - basic to advance- its fundamentals

Rating: 4.9

Level: All Levels

Duration: 7 hours

Instructor: ajay parmar