Course Outline
Introduction to Excel
- Overview of the Excel interface and key features
- Understanding workbooks, worksheets, and cell references
- Navigating the Ribbon, Quick Access Toolbar, and contextual menus
Data Entry and Formatting
- Efficiently entering and editing data
- Formatting cells, rows, and columns
- Applying number formats, styles, and themes
- Data cleaning and basic validation techniques
Formulas and Functions
- Grasping formula structure and the order of operations
- Employing relative, absolute, and mixed references
- Essential functions: SUM, AVERAGE, COUNT, IF, and others
- Leveraging modern functions: XLOOKUP, IFS, and dynamic arrays
Working with Data Ranges and Tables
- Creating and managing Excel tables
- Sorting, filtering, and applying conditional filters
- Using structured references within tables
- Data validation and removing duplicate entries
Data Visualization
- Creating charts and graphs (column, line, pie, etc.)
- Formatting chart elements for improved clarity
- Utilizing Sparklines and Conditional Formatting for visual insights
- Best practices for effective data presentation
Introduction to Data Analysis Tools
- Utilizing PivotTables and PivotCharts
- Summarizing and grouping data
- Introduction to the Analysis ToolPak for basic statistical analysis
Collaboration and Productivity Features
- Saving and sharing files via OneDrive and SharePoint
- Co-authoring workbooks and managing comments
- Accessing version history and recovery options
- Using Flash Fill, Quick Analysis, and other time-saving tools
Summary and Next Steps
Requirements
- A fundamental understanding of computers
- No previous experience with Excel is required
Target Audience
- Data analysts
- Office professionals
- Anyone interested in learning the basics of Excel 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.
