Deepen your understanding of functions, delve into data analysis tools such as pivot tables and charts, and explore advanced formatting and conditional formatting techniques to efficiently manage and present complex data sets. Additionally, you’ll learn to work with larger datasets, employ more sophisticated formulas, and streamline processes through data validation and automation features.
“The Intermediate Microsoft Excel course is for those who understand the basics of Excel and are familiar with the Excel screen, formatting and basic formulas. You will explore basic VLOOKUP and pivot tables to ensure that you understand the more advanced formulas and functions of MS Excel.”
Course Content
- Applying cell and range names
- Naming ranges automatically
- Using specialised functions
- Fixed referencing
- Sort and filter data
- Excel built-in functions
- Creating a chart
- Modifying charts
- Adding data to charts
- MIN, MAX and AVERAGE
- COUNT, COUNT-A and COUNTBLANK
- Rounding
- Insert graphic objects
- Draw and modify shapes
- llustrate workflow using SmartArt graphics
- Add a background
- Custom format numbers, dates etc.
- Watch window option
- Text to columns
- Subtotal function
- Protection
- Set up calculations
- Types of errors
- Breaking links
- Data validation
- Hyperlinks
- Working with dates and time
- Dynamic dates and the TODAY and NOW functions
- Conditional formatting
- Format painter
- Paste special
- Pivot table
- Count using pivot tables and drilling down into detail
- Updating a pivot table with new data and adding multiple values
- Using calculated fields in pivot tables
- Removing or hiding subtotals, grand totals and filling blanks
- Google sheets
- Non-accredited: Short course only
- Duration: 1h 30m
- Delivery: Classroom/Online/Blended
- Access Period: 12 Months
