This course is designed to teach you the basic foundations of Microsoft Excel, so that you will feel comfortable navigating the world’s most popular spreadsheet software. Learn what Excel is used for, what workbooks and worksheets are and how to manage them. Navigate your way around cells, rows and columns in a worksheet. Discover how to format different types of data and use conditioning formatting to highlight relevant data making analysis easier. Work with formulas and formulae and discover how to add them to perform calculations. Learn about charts and changing views, as well as discover how to print your worksheets.

Achieve tasks like:

• Signing into Excel.

• Finding the Quick Access toolbar.

• Discovering the Menu options.

• Navigating through Worksheets.

• Opening a recently used Workbook

• Starting from scratch

• Saving Workbooks

• Pinning a Workbook

• Creating New

• Copying and Renaming

• Changing colours

• Selecting cells

• Selecting a range of cells

• Selecting non-adjacent cells

• Selecting an entire Worksheet

• Selection cursors

• Scrolling using the scroll bars

• Changing the width of a column

• Changing the height of a row

• Inserting columns

• Deleting columns

• Inserting rows

• Deleting rows

• Inserting text

• Inserting values

• Spell check

• Moving data

• Copying and Pasting data

• Autofill

• Inserting a picture

• Changing the font and size

• Adding visual effects

• Adding borders

• Highlighting cells and changing the font color

• Using the format painter

• Aligning and wrapping data

• Merging cells

• Changing the format of data

• Formatting cells as a table

• Sorting and filtering data

• Highlight cell rules

• Sorting by color

• Top/Bottom rules

• Icon sets

• Data Bars

• Color Scales

• SUM, TODAY

• Inserting formulae

• Absolute and relative cell references

• AutoSum, AVERAGE, COUNT, MAX, MIN

• Types of charts

• Recommended charts

• Moving charts

• Changing the chart title

• Changing the data source

• Formatting chart axis

• Zoom

• Freeze Panes

• Quick Access toolbar

• Hide/Show

• Default Options

• Page Orientation

• Scaling

• Margins

• Header/Footer

• Print Area

• Print Titles

• Print Preview