Course Outline
Getting Started with Excel
- Exploring the Excel interface and core capabilities
- Grasping the concepts of workbooks, worksheets, and cell addressing
- Navigating the Ribbon, Quick Access Toolbar, and context-specific menus
Inputting and Structuring Data
- Inputting and modifying data with speed and precision
- Adjusting the appearance of cells, rows, and columns
- Applying number formats, styles, and themes
- Data hygiene and initial validation checks
Calculations and Functions
- Mastering formula syntax and calculation precedence
- Applying relative, absolute, and mixed cell references
- Utilizing key functions such as SUM, AVERAGE, COUNT, IF, and others
- Leveraging contemporary functions like XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Building and overseeing Excel tables
- Sorting, filtering, and applying conditional filters
- Utilizing structured references within tables
- Validating data and eliminating duplicates
Visualizing Data
- Generating charts and graphs (bar, line, pie, etc.)
- Refining chart components for maximum clarity
- Employing Sparklines and Conditional Formatting to highlight insights
- Best practices for presenting data effectively
Overview of Analytical Tools
- Working with PivotTables and PivotCharts
- Aggregating and categorizing data
- Introducing the Analysis ToolPak for fundamental statistical analysis
Teamwork and Efficiency Features
- Storing and distributing files through OneDrive and SharePoint
- Collaborative editing and comment management
- Tracking version history and recovery procedures
- Utilizing Flash Fill, Quick Analysis, and other efficiency boosters
Recap and Future Directions
Requirements
- Foundational computer literacy
- No previous Excel proficiency is necessary
Target Learners
- Data analysts
- Corporate professionals
- Individuals seeking to master core Excel competencies for data management and analysis
Testimonials (6)
very clear, very good explanation, wishing more teachers would train like this
Mihaela - Phillip Morris
Course - Excel Basics
Explanations ‘in everyone’s language’; the fact that we were answered every time and explained in at least two ways what, how, and from where; the atmosphere created and the fact that despite there being a lot of math, we didn’t feel it; the trainer's experience demonstrated through well-reasoned explanations, but never overly technical; the trainer’s passion: it is clear that they really enjoy what they do :)
Alex - DEICHMANN SRL
Course - Excel Basics
Machine Translated
The practice
Eliza - DEICHMANN SRL
Course - Excel Basics
I appreciated the trainer's way of interacting with all the participants, the willingness to provide any requested information and the interest shown in each topic so that it was well understood. The course was very interactive, with a lot of information and examples, and the exercises were also very useful for checking and reinforcing knowledge.
Alex - DEICHMANN SRL
Course - Excel Basics
Machine Translated
some new functions i did knew before, such as power query; fomat cell -alignment-fill
Bella - fu ma si jing mi duan jian (da lian) you xian gong si
Course - Excel Basics
The guy was really helpful and knowledgeable and i really learned a lot in two days.
