You will learn how to:
- Navigate the Excel user interface, enter your data, process it, and format it
- Use formulas and functions to perform calculations
- Automate the selection and search of data using functions
- Analyze data and present results in a user-friendly way
- Create user-friendly spreadsheets. Check data, find and correct errors. Create navigation aids for large books
- Build charts and graphs that effectively summarize data
This course is for those who:
- Starts working in MS Excel
- Wants to learn how to organize and present any data in the form of tables
- Masters formulas and functions, charts and graphs
- Want to improve your Excel skills
- Strives to increase their value in the labor market through professional work in MS Excel
Rates
EASY
- 6 topics
- 31 lessons
- 2 hours of video
- 203 test questions
- 6 case studies
- Final test for the course
- Certificate of excellence
- Telegram chat for program listeners
Program duration: 3 weeks
Nearest start date, dd/mm/yy: No limitations
99 USD
EXPERT
- Everything included in EASY plan
+ - Individual support of the teacher with verification and analysis of practical tasks
Program duration: 3 weeks
Nearest start date, dd/mm/yy: 01-06-2023
129 USD
PRO
- Everything included in EASY plan
+ - Individual support of the cource author with verification and analysis of practical tasks
Program duration: 3 weeks
Nearest start date, dd/mm/yy: 01-06-2023
390 USD
Program syllabus
- Navigation
- View modes
- Data input
1. Introduction to Excel
- Formulas
- Functions
- Cross references
2. Calculations
- Borders
- Alignment
- Number formats
3. Table formatting
- Managing Rows and Columns
- Search and Replace
- Filtering, sorting data
4. Working with data
- Page orientation
- Margins, scale, headers and footers
- Output to PDF
5. Spreadsheet printing
- Basic types of charts (pie, column charts and graphs)
- Change the chart style
- Change chart elements