
About this Course
Syllabus
About this Course
Excel is considered one of the most common programs in the world of data. Its friendliness and convenience make the data analysis process simple and easy for the novice user. And at the same time – Excel is a very powerful and sophisticated tool for the experienced user.
This course teaches the basics of the software, and allows beginners to enter the world of data analysis using it.
Audience
Various units in the organization that wish to use Excel to improve their day-to-day work
Prerequisites
Familiarity with the Windows operating system, and various office tools (such as Word, Power Point, etc.)
- Utilizing Columns and Rows
- Utilizing Several Worksheets
- Locate and Replace
- Utilizing Several Workbooks
- Basic Formatting
- Setting Number Formats
- Date and time formatting
- Wrapping and Aligning of Text
- Borders and Merging of Cells
- Filtering Fundamentals
- Advanced Filtering
- sorting in Excel
- Introduction to Formulas
- Arithmetic Formulas
- Applying Formulas to Text
- Applying Formulas to Dates
- Reference Cells
- Hiding Columns and Rows
- Introducing Functions in Excel
- Arithmetic Functions
- Functions for Counting
- Calculations Based on Conditions
- Functions for Date and Time
- Functions for strings
- logical and lookup operations
- The IF Statement
- AND and OR
- VLOOKUP
- VLOOKUP with IFERROR
- Basics of Modelling
- The PMT Process
- Data Validation Lists
- Slider Bars
- Named Ranges
- Model Design
- Custom Formats
- Conditional Formatting
- Using Charts
- Text to Columns
- External Data
- Table Features
- Tables as Named Ranges
- Overview of Pivot Tables
- Pivot Tables with Layers
- Pivot Table Layout and Formatting
- Pivot Table Filtering
- Slicers
- Pivot Table Calculus
- Basics of Macros
- Executing Macros With Buttons
- Editing Macros