Microsoft Excel Level 1, Mini Session 1

Overall functions of the package and the worksheet layout

Backstage information

Compatibility modes and problems

Ribbon bars, sections, expanding and Quick Access bar

Identifying and selecting cells, ranges, and global

Data alignment: orientation, format to fit, wrap text

Cell width and row width – manual, auto adjustment, group, assign number

Borders vs Gridlines

Sheets and workbooks – naming and selecting

Selectors for move, data fill, select

Auto Fill for days, months, numbers and custom data

Custom Data Fill

Entering labels and numbers

Format painter for duplicating appearance

Format numbers as currency, accounting, dates, percentage, and more

DATE and NOW FUNCTIONS

Move, copy, paste data and use of clipboard

Open, save, save as files

Spell Check and default of not checking capitals

AutoCorrect

Formula bar and expanding

Formulas – entering at least five different ways

Click here to enroll in this Zoom session.