Basic Excel
Career Objective
Master Excel Fundamentals: Build a strong foundation in Excel, including essential functions, formulas, and data management techniques.
Learn Data Manipulation and Visualization: Develop skills in organizing and manipulating data, and create charts and graphs to effectively visualize your data insights.
Enhance Data Analysis Skills: Learn to analyze data using Excel’s powerful tools, identify trends, and generate meaningful reports for informed decision-making.
Course Instructions
- Follow the course sequence to qualify for the complete course certificate.
- Each module completed individually earns a certificate specific to that module.
- Completing the entire sequence is necessary to obtain the full course certificate.
- Sequential completion ensures thorough learning and mastery.
- Each module certificate acknowledges acquisition of specific skills.
- To earn the full course certificate, completing all modules in sequence is mandatory.
- Following the correct sequence enhances comprehension and application.
- Certificates for individual modules recognize targeted skill advancement.
What you will learn?
Essential Functions and Formulas
Data Management Techniques
Organizing and Manipulating Data
Creating Charts and Graphs
Using Excel’s Analysis Tools
Essential Functions and Formulas
- Basic Arithmetic Operations: Addition, subtraction, multiplication, and division.
- Â Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER.
- Date and Time Functions: TODAY, NOW, DATE, TIME, YEAR, MONTH, DAY, DATEDIF.
- Logical Functions: IF, AND, OR, NOT, IFERROR.
- Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH.
Data Management Techniques
- Data Entry and Formatting: Cell formatting, conditional formatting, data validation.
- Cell Referencing: Relative, absolute, and mixed references.
- Basic Data Organization: Sorting, filtering, and using tables.
- Named Ranges: Creating and managing named ranges for easier reference.
Organizing and Manipulating Data
- Data Cleaning: Removing duplicates, finding and replacing, using text-to-columns.
- Data Transformation: PivotTables, PivotCharts, and Power Query basics.
- Advanced Filtering: Using custom filters, advanced filters, and criteria ranges.
Creating Charts and Graphs
- Basic Chart Types: Column, bar, line, pie, and scatter charts.
- Chart Customization: Formatting chart elements, adding titles, labels, and legends.
- Data Visualization Techniques: Using trendlines, data labels, and annotations.
- Dynamic Charts: Creating charts that update automatically with data changes.
Using Excel’s Analysis Tools
- Data Analysis Toolpak: Performing statistical analysis, regression analysis, and descriptive statistics.
- Scenario Manager: Creating and managing different scenarios for forecasting.
- Goal Seek and Solver: Performing goal-seeking analysis and solving optimization problems.