This workshop will cover all Microsoft Excel intermediate level principles as well as useful functions & tricks – 6 hours
• Illustration Editing:
o Insert ClipArt, Pictures from Files, and Screen Shots
o Move or Delete a Picture
o Format Picture
o Use SmartArt
o Edit and Format SmartArt
o Add and Edit Word Art
o Draw and Format Shapes

• Chart Editing:
o Insert Chart
o Edit the design, layout and format of a chart
o Print a chart

• Manage Cell and Range Names
o Naming Ranges
o Naming Formulas

• Conditional Function and Format
o IF function: COUNTIF, SUMIF, AVERAGEIF
o Nested IF
o Conditional formatting

• Times and dates
o Time and date format
o Time and date functions

To attend you should know the basics of Microsoft office.
The session is online, we will be using Excel in parallel, make sure you are on a laptop and Excel is installed on your laptop.