Course Outline - MS Excel intermediate

Unification of knowledge
Advanced methods of designing and formatting  tables
Formatting by the Styles
Conditional Formatting
Advanced calculations and functions, multiple functions
Choice of the most common and usefull functions from all cathegories (IF, COUNTIF, TODAY, FIXED, HLOOKUP, VLOOKUP, CONCATENATE, ROUND… etc.) practical excersices.
Work with spreadsheets – Calculations in the 3D tables
Formula Auditing, Trace Precendents, Dependents
Advanced Charts (3D Charts, Layout,Labels, Axes, Analysis)
Advanced print settings
Header/Footer
Rows to repeat at top, Set Pront Area,)