Course NT-Excel (I) Microsoft Excel, part 1
The course provides knowledge and skills in effective work in Excel, in particular, in creating reports of varying complexity, selecting data by one or more criteria, calculating, automatically collecting data from several tables, constructing graphs and charts, automating similar operations.
p>After completing this course, students will be able to:
- orientate yourself in the structure of the workbook;
- create spreadsheets;
- format data;
- use different formulas and functions;
- create charts;
- apply data filtering and sorting;
- print the workbook.
Audience Profile
The training is intended for professionals who are starting to use Excel in their work or who already have practical skills in working with MS Office applications. Students will get acquainted with the features of MS Excel versions, master the basic techniques of working with electronic spreadsheets, learn about ways to automate data entry and their calculations, as well as analyze data using pivot tables. The course will be of interest to accountants, financiers, economists, analysts, managers, marketers and other specialists who collect and process information.
Before attending this course, students must have:
- ability to work with MS Windows.
1. Interfaceand general principles of working in Excel
- Microsoft Excel Interface. Customizing the Quick Access Toolbar
- Creating, Opening, and Saving Workbooks
- Workbook Structure, Sheet Operations (Moving, Copying, Renaming, Deleting, Inserting a New Sheet)
- Moving and Copying Worksheets Between Files
- Working with the Clipboard
- Using Help
2. Entering and editing data
- Navigating cells within a sheet and quick navigation methods
- Entering text, dates, and numbers
- Cell content and format
- Clearing cell content and formatting
- Using AutoFill for numeric data, text/number combinations, and dates
- AutoFill lists
- Adding, deleting, moving, and copying sheet items
- Paste Special
- Freezing panes to permanently display rows/columns on the screen
- Cell formatting
- Copying formats to other cells. Format Painter
- Using cell styles for consistent table formatting
- Hiding and showing rows, columns, and sheets
- Finding and replacing data
3. Working with formulas and functions
- Entering and Editing Formulas
- Types of Operators in Formulas
- Operator Precedence
- Copying and Moving Formulas
- Using Different Types of References in Formulas: Relative References, Absolute References, Mixed References
- Functions. Using the Function Wizard
- Using Mathematical, Statistical, Logical, and Date/Time Functions in Formulas: SUM, ROUND, COUNT, COUNTA, MIN, MAX, AVAREGE, IF, SUMIF, COUNTIF, LEFT, RIGHT, MID, LEN, CONCATENETE (&), FIND, TODAY
- Nested Functions
- Common Errors When Working with Formulas
4. Construction and editing diagrams
- Selecting a chart type. Recommended charts
- Customizing charts
- Changing chart data: removing and adding data series
- Changing the chart type
- Formatting chart elements
- Combo charts: Using a secondary axis
5. Printing worksheets
- Print Preview
- Change Page Layout
- Page Setup: Orientation, Margins, Scaling
- Headers and Footers
- Print Areas
- Print Workbooks and Sheets: Full Print, Selected Prints, Multiple Copies
6. Useful keyboard shortcuts
Sign up for the closest date
Copyright © 2026 Networking Technologies