Microsoft Excel Part 2

Ready to elevate your skill set? This live online or in person course is designed for users who want to significantly boost their productivity and take full control of complex data projects. We move past introductory skills to focus on the essential techniques used by advanced Excel professionals every day. You'll gain a deep understanding of data modeling and analysis, which provides the perfect foundation for moving on to specialized visualization and reporting tools like Power BI.

Excel Part 2 Class: Key Skills

• Customization & Visualization
  • Go beyond basic formatting to customize data appearance using advanced cell formats, Sparklines, and powerful Conditional Formatting rules for instant data visualization.
• Workbook Organization & Security
  • Learn professional techniques for managing, securing, and sharing complex workbooks. Apply features like Split Views, the Trust Center, and file protection to ensure data integrity.
• Data Integration & Naming Conventions
  • Become proficient in working with multiple tables and data ranges. Master the Name Manager for easy referencing and link data seamlessly using internal references and advanced tools like Slicers.
• Advanced Formulas & Automation
  • Unlock powerful functions for complex lookups (XLOOKUP, VLOOKUP), logic (IFS), and data cleanup (Text to Columns). Explore advanced analysis tools (Goal Seek, Scenario Manager) and simple macro recording to boost your efficiency.

Prior Learning

This course assumes you have a solid foundation in all Excel Part 1 topics. You should be proficient in:

• Managing the interface
• Building basic formulas and text functions
• Creating and formatting Excel Tables
• Using Pivot Tables for basic data summarization

If you're confident in those areas, you're ready to master the next level of efficiency and analysis.

To ensure success, students should:

• Be comfortable reading and understanding English, as all materials are provided in English.
• Have basic computer skills, including navigating the internet, downloading/uploading files, installing software, and using applications like Microsoft Word.
• A basic understanding of math principles such as addition, subtraction, multiplication, division, and fractions is recommended.

These foundational skills will help you engage fully with our primarily online courses.