Course NT-Excel 365 (I) Microsoft Excel 365, part 1

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