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.
- Interface and general principles of operation for Excel
- Interface of Microsoft Excel. Customizing the Quick Access Toolbar
- Create, open and save workbooks
- Book structure, sheet operations (move, copy, rename, delete sheet, insert new sheet)
- Moving and copying worksheets between files
- Working with the clipboard
- Entering and editing data
- Moving through cells within a sheet, ways to quickly move
- Entering text, dates, and numbers
- Cell content and format
- Clear cell content and formatting
- Using the "autocomplete" feature for numeric data, combinations of text and numbers, dates
- Autocomplete Lists
- Adding, deleting, moving, and copying sheet items
- Special insert
- Pinning panes to permanently display rows/columns on the screen
- Split data in a column based on text you enter
- Data Formatting
- Copy formats to other cells. Format Painter Tool
- Hiding and showing rows, columns, and sheets
- Search (text, numbers) and replace data
- Working with formulas and functions
- Entering and editing formulas
- Operator types in formulas
- Operator precedence
- Using different types of links in calculations: relative links, absolute links, mixed links
- Using the Function Wizard
- Use mathematical, statistical, logical functions and functions of date and time in formulas (ROUND, TODAY, SUM, COUNT, MIN, MAX, AVAREGE, IF, SUMIF, COUNTIF, LEFT, &, FIND
- Nested functions. Copying and moving formulas
- Working with Smart Tables
- Creating and formatting tables
- Built-in table templates
- Sorting and filtering tables. Slicing
- Use of totals. Dependence of totals on filters
- Using formulas in tables
- Converting a table to a range
- Building and editing charts
- Chart Wizard
- Recommended charts
- Customizing charts
- Editing Chart Data: Removing and Adding Data Series
- Change the chart type
- Changing Chart Options
- Formatting Chart Elements
- Location of data series along the minor axis
- Combined charts. Using the Secondary Axis
- Printing worksheets
- Preview
- Changing page layout
- Setting page parameters: orientation, margins, scale
- Headers and footers
- Print workbooks and sheets: full, selective, multiple copies
Sign up for the closest date
Copyright © 2024 Networking Technologies