Tel:020 7920 9500
Microsoft Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction..
For more demanding uses, Excel can be used to create charts, Analyse Data, used as a data repository and of course keep track of your accounts.
Benefit From our Smart Training
Excel Intermediate Course Overview
Unlocking Excel’s Power: Intermediate Training
This course is designed for Excel users looking to expand their skills beyond the basics.
Key Focus:
- Mastering Excel Formulas & Functions: Gain proficiency in advanced formulas and functions to manipulate and analyze worksheet data effectively.
- Data Summarization Techniques: Learn to efficiently summarize data using filters, subtotals, and data tables.
Benefits:
- Increased Productivity: Streamline data analysis and improve efficiency in your daily work.
- Enhanced Data Analysis Capabilities: Gain the confidence to tackle more complex data challenges.
- Improved Decision-Making: Leverage data insights to make informed business decisions.
Who Should Attend:
- Excel users with some prior experience seeking to enhance their skills.
- Professionals who work with data regularly and want to improve their efficiency.
- Anyone who wants to unlock the full potential of Excel for their work.
By the end of this course, you will feel confident in your Excel skills and equipped to tackle new data challenges with ease
Excel Intermediate Training Course Details
Duration: 1 Day
Course Location : Face to face group / Online & Onsite training available.
Class Size : As a guide we recommend class sizes to be no more than six.
Virtual / Online training Format : Teams or Zoom.
Tailored Course Content : Our Excel Introduction Training Course can be tailored to your requirements
Course Objectives:
- Build upon foundational Excel skills to enhance productivity and data analysis capabilities.
- Master advanced formatting techniques for professional presentations.
- Learn to efficiently manage and manipulate data.
- Utilize advanced formulas and functions for complex calculations.
- Create dynamic and interactive spreadsheets.
Module 1 Advanced Formatting (90 mins)
- Conditional Formatting:
- Applying rules (greater than, less than, between, etc.)
- Data bars, color scales, icon sets
- Creating and managing rules
- Cell Styles: Creating, modifying, and applying custom cell styles.
- Sparklines: Creating and customizing sparklines for data visualization.
Module 2. Working with Data (120 mins)
- Data Validation:
- Restricting data entry (drop-down lists, whole numbers, etc.)
- Applying input messages and error alerts.
- Filtering and Sorting: Advanced filtering techniques (multiple criteria, custom filters).
- Data Tables: Creating one-variable data tables for sensitivity analysis.
Module 3 Advanced Formulas (120 mins)
- IF Functions: Nested IF statements, IFERROR, IFS.
- SUMIF, COUNTIF, AVERAGEIF: Conditional sums, counts, and averages.
- VLOOKUP ,HLOOKUP and XLOOKUP: Lookup values in tables.
- Text Functions: Extracting, manipulating, and formatting text data.
Module 4. Working with Worksheets (60 mins)
- Worksheet Management: Inserting, deleting, renaming, and moving worksheets.
- Grouping Worksheets: Applying formatting and formulas to multiple worksheets simultaneously.
- 3D References: Linking formulas across multiple worksheets.
Module 5 Data Analysis & Visualization (60 mins)
- Pivot Tables (Introduction): Creating basic pivot tables for data summarization.
- Charts & Graphs: Creating and formatting basic charts (bar, line, pie).
Online or Your Venue
Courses delivered by Certified Trainers
- This is a basic outline and can be customized based on the specific needs and learning objectives of the target audience.
- Remember We will adapt the course to your specific requirements and the level of your learners.
- We Provide ample time for questions and discussions.
This intermediate outline provides a solid step up from the foundation introduction course .
Our instructors are very approachable, making the dryest subject matter fun.
