Carefulness of macros! Building your first macro without having any programming knowledge. Macro & VBA: Automate Your Excel Action or Report.Customizing Data Bars and Icon set’s parameter. Using Data Bars and icons for great presentation. Multiple Conditional Formatting-manage rules. Applying Advanced Conditional Formatting on Dashboard.Control your chart by form controls (drop-down, option button etc.) Special charts for Target-Achievement analysis. Special charts for Group-Sub group analysis. Creating various types of Charts-Column, Bar, Pie, Line etc. Where will you use form controls? Tabular and graphical data interaction using form controls. Use Button, Check Box, Option Button, List Box, Combo Box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |