Course NT-Excel 365 (I) Microsoft Excel 365, part 1
Training can be conducted on any version of Microsoft Office. The course program is adapted to the specifics, needs and level of audience
- 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