Excel - Advanced
Unlock your true potential as an office professional with our comprehensive and practical introductory course on Microsoft Excel. Designed specifically for adults and office workers, this course equips you with the essential skills and knowledge to excel in your daily tasks, boost productivity, and gain a competitive edge in the workplace.
Whether you are a beginner or have limited experience with Excel, our expert instructors will guide you step-by-step through the fundamental concepts and functionalities of this powerful spreadsheet software. By the end of the course, you will have mastered the core techniques and gained confidence in using Excel to streamline data analysis, reporting, and decision-making processes.
Don't let Excel intimidate you. Join our introductory Microsoft Excel course today and unlock a world of possibilities. Take control of your spreadsheets, boost your productivity, and become an indispensable asset in any office environment. Book now and take the first step towards Excel mastery!
RECAP OF INTERMEDIATE
- Linking spreadsheets
- Consolidating data and using workbooks
- Database and sorting
- Word and graphic tools
- Absolute referencing
STYLES AND ANNOTATIONS
- Using Autoformat
- Create, edit, use and merge styles
USING FORMULAS
- If, date and lookup tables
- Tables
CHARTS
- Creating 2D and 3D charts
- Graphing isolated rows
- Creating overlay charts
REPORTS AND VIEWS
- Using Report and View Managers
DATABASE
- Sorting and querying
- Database statistical functions
- Using the Pivot table wizard
MACROS
- Macro recording and running
- Automatic executing macros
- Assign macros to buttons and graphic objects
MISCELLANEOUS CONTENT AND TIPS
- Exchanging data with other documents
- Setting up a workspace
- Specifying startup directory
- Create and use document templates
- Protecting data
Class Details
3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $150 + GST (per person)
3 people - $175 + GST (per person)
1 or 2 people - $205 + GST (per person)
Evening Class 2½ hours 5:30pm - 8:00pm $90 + GST
At Your Site
4 or more people - $225 + GST (per person)
3 people - $250 + GST (per person)
2 or fewer people - $275 + GST (per person)
Venue:
Upcoming Sessions
Dates don't suit? Call or E-mail.