Course NT-Excel 365 (I) Microsoft Excel 365, part 1 | nt.ua

(044) 390 73 35 (050) 352 68 64

EN RU UA

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
  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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

Course Code

NT-Excel 365 (I)

Length, days (hours)

2 (12)

Closest dates

Price, UAH

Class schedule

Date

Time

10.06.24
09:30 - 17:00
11.06.24
09:30 - 17:00