Basic operations of Excel

Excel basic teaching is designed specifically for novice professionals, students, and office beginners. Using plain language + step-by-step screenshots, it breaks down the core operations of Excel. From interface recognition, cell editing, and data entry, to formula application, format layout, and data filtering, every step is clearly marked with details (such as "How to enter the sum formula", "Techniques for batch adjusting row height"). It is also accompanied by tips to avoid common problems (such as avoiding data format confusion and solutions to formula errors). No professional foundation is required, and you can quickly master basic Excel skills by following the guide, easily handling daily office needs such as report making and data organization.

What you'll Learn

• Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.

• Use formulas and functions to perform calculations on data. Automate choices and data lookups using functions.

• Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.

• Create easy-to-use spreadsheets. Validate data, find and correct errors. Create navigation aids for large workbooks.

Modules in the Course 

1. Cell formatting, common Excel Formulas, Data management (consolidation, validation, etc) and visualization

2. Advanced Data Management, How to do Financial Calculation, Data Tables and Solver, Regression Tool

3. Apply Excel Functions and Tools to solve "open-ended" problems in given projects. 

Duration: 2-3 days

Including: Videos and electronic readings, we also have assignments for you to test your learning outcomes.