Excel: Core Concepts for Business
Course Summary
2 Days | Core Concepts
This excel course is designed to empower individuals with fundamental and intermediate skills in Microsoft Excel. Whether you are new to Excel or looking to enhance your existing knowledge, this comprehensive training will provide you with the essential tools and techniques to navigate, analyze, and present data effectively. From basic data entry and formatting to intermediate-level formula usage and data analysis, this course is crafted to build a solid Excel skill set that can be applied across various professional domains.
Learning Objectives
- Navigate and use core Excel functions for data entry, formatting, and organization.
- Apply intermediate formulas and functions for analysis and problem-solving.
- Create and present data using tables, charts, and basic data tools.
- Use time-saving tips, tricks and short cuts to increase productivity.
- Build a practical Excel skill set applicable across business functions.
Who Should Attend
This course is open to all.
Learning Topics
- Introduction: Ribbon and keyboard shortcuts
- Excel Basics: Navigation, editing, and basic formatting
- Formatting and Navigation: Freeze panes, referencing, Go To Special
- Basic Functions: SUM, IF, DATE, TEXT, and logical functions
- Lookup Functions & Data Extraction: VLOOKUP, INDEX/MATCH, XLOOKUP
- Mathematical Functions: SUMIF, ROUND, MIN/MAX, PV/FV
- Financial Functions: NPV, XNPV, IRR, XIRR
- Sorting, Filters, and Pivot Tables: Sorting, filtering, and Pivot Tables
- Developer Tab: Macros and form controls
- Using LAMBDA to Create Custom Functions: Custom Excel functions
- Introduction to Charts and Graphs: Bar, line, and pie chart creation