Microsoft Excel "Tips & Tricks" Workshop - Wed, 6 July (9:00am - 12:30pm)- Every day formulas
- Advanced formulas including lookups
- Pivot tables
- Spark lines
- Basic macros
- Charts
- The camera tool
- Referencing external data
- Data views including freeze frame, split screen, display options, page setup
- Removing duplicate values
- Conditional formatting
- Document security including document protection and removing personal info
- Quick access toolbar
- Creating your own tab
- 64bit vs 32 bit Excel
- Creating a dashboard
- Formatting data
- Tables
- Tips on printing - setting printable areas, watermarks, etc.
- Interactive features such as 3D maps
Click here to book your spot.
Other upcoming "tips & tricks" workshops
Wed, 20 July (9am - 12:30pm) - Sage Pastel Partner / Xpress / Sage 50c
Wed, 3 Aug (9am - 12:30pm) - Sage Pastel Payroll
Wed, 17 Aug (9am - 10am) - SARS E@syFile Submissions
Wed, 7 Sep (9am - 12:30pm) - Sage Intelligence
Wed, 21 Sep (9am - 12:30pm) - Microsoft Excel
Wed, 5 Oct (9am - 12:30pm) - Sage Pastel Partner / Xpress / Sage 50c
Wed, 19 Oct (9am - 12:30pm) - Sage Pastel Payroll
Wed, 2 Nov (9am - 12:30pm) - Sage Business Cloud Payroll
Wed, 16 Nov (9am - 12:30pm) - Xero Accounting
Wed, 7 Dec (9am - 10am) - Leave & Bonus Payroll Processing
Click here for more information.
Click here to book your spot. |
|
