Excel Level 1 Course Syllabus
Duration: 1 day - 8 academic - 6 astronomical hours
General information about Microsoft Excel
- Excel user interface.
- Create, open, and save workbooks.
- Working with workbook windows in Excel.
- Excel Help System.
Managing sheets
- Select, insert, delete, move, copy, rename sheets.
- Moving through sheets.
- Pinning areas.
- Window splitting.
- Changing the sheet scale.
Data entry
- Move through cells within a worksheet.
- Enter text, dates, and numbers.
- Clearing the cell contents.
- Editing cell contents.
- Insert, delete, copy, and move cells, rows, and columns.
- Hiding and showing rows and columns.
- Undo and redo an action.
- Automatic cell completion. Autocomplete list.
- Working with notes.
Sheet formatting
- Formatting cells. Formatting numbers, dates, and times.
- Change the height and width of rows and columns. Hide and show rows, columns, and sheets.
- Format as pattern tool.
Working with formulas. Functions.
- The concept of formula, examples.
- Entering and editing formulas.
- Typical errors when working with formulas and ways to correct them.
- Insert, delete, copy, and move cells in worksheets that have formulas. Absolute and relative references.
- Using functions. AutoSum. Examples of some functions (SUM, MIN, MAX, AVERAGE, IF).
Search and replace data.
Working with charts
- Basic information about charts.
- Constructing charts based on a rectangular data area.
- Use of some basic chart types (bar, line, graph, pie, area, etc.). Combination charts.
- Formatting charts.
- Constructing charts based on data that does not form a continuous rectangular data region.
Page settings and printing
- Setting page parameters.
- Using print areas and page breaks.
- Print preview.
- Setting print options. Print.
Certificates and materials: GROW EXPERT EDUCATION PROVIDER
Registration: +38068 701 03 01 / +38073 712 12 30
info@akcent-pro.com