Excel - Intermediate
Take your Microsoft Excel skills to the next level with our comprehensive intermediate course designed to enhance your proficiency in this powerful spreadsheet software. Whether you're an office worker, business professional, or data enthusiast, this course will empower you with the knowledge and skills to efficiently manage and analyze data like a pro.
In this intermediate Excel course, you will explore a wide range of topics to expand your capabilities. From advanced formulas and functions to data visualization techniques and data analysis tools, you'll gain the expertise to handle complex datasets, streamline workflows, and extract meaningful insights from your data.
Harness the power of Excel's advanced features and unleash your data management potential. Book our intermediate Excel course today and embark on a transformative learning journey that will elevate your skills, boost your productivity, and make you a valuable asset in any data-driven environment. Get ready to excel in Excel!
REVIEW OF INTRODUCTION
- Minimising, maximising and arranging windows
- Cutting and pasting between spreadsheets
- Linking spreadsheets
- Consolidating data and using workbooks
DATABASE AND SORTING
- Sorting rows based on a column
- Subtotals
- Outlining
- Setting criteria and extracting records using Filters
- Advanced Filter
- Using the data form
- Basic functions and function wizard
WORD AND GRAPHIC TOOLS
- Adding and editing word processing frames
- Using the drawing tools to add graphic objects
MISCELLANEOUS CONTENT AND TIPS
- Absolute referencing
- Freezing columns and rows for easy editing
- Naming ranges for linking and quick positioning
- Grouping Worksheets
- Autofill and Series fills
- Inserting comments and notes
- Transpose columns and rows
- Tips and techniques
Pricing:
On your premises
3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $225 + GST (per person)
3 people - $250 + GST (per person)
1 or 2 people - $275 + GST (per person)
Venue:
On your premises or we can arrange a venue to suit.
Upcoming Sessions
Dates don't suit? Call or E-mail.