Excel Advanced - Super User
@font-face { font-family: Wingdings; } @font-face { font-family: Gill Sans MT; } @page Section1 {size: 595.45pt 841.7pt; margin: 72.0pt 72.0pt 28.05pt 72.0pt; mso-header-margin: 36.0pt; mso-footer-margin: 36.0pt; mso-paper-source: 16640; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 10.0pt } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 10.0pt } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 10.0pt } SPAN.GramE { mso-style-name: ""; mso-gram-e: yes } DIV.Section1 { page: Section1 } OL { MARGIN-BOTTOM: 0cm } UL { MARGIN-BOTTOM: 0cm }
Download our Corporate eBrochure
Are you an advanced user of Excel?
Do you want to complete your knowledge in order to support others who use this powerful software?
Or may you want to analyse your data in more detail and streamline yours and your colleagues’ workflow?
Upon successful completion of this half day workshop you will be able to:
- Streamline your workflow No matter what we do, there are always repetitive tasks; macros will alleviate these dull tasks
- Collaborating with others You have learnt how to stop people from altering your data, but let’s suppose others have access – how do you know where they have been and what they did?
- Auditing Worksheets Identify which cells will alter if you change one or, what happens to formulae if you delete a particular cell.
- Analysing data Analysis, understanding and presentation of data is a key feature of Excel; Pivot Tables are the answer.
- Importing and exporting data Export your data into Word, publish your worksheet to the web or import from the web
Duration: Half Day
|