
Master the basics of Excel, including workbooks, sheets, the ribbon with home and insert tabs, and how to navigate cells, enter formulas in the formula bar, and manage sheets.
Learn to work with cells in Excel, enter and edit data, and navigate with tab and enter. Create and rename sheets, build a labeled table, and format numbers as currency.
Learn how to format cells in Excel by adjusting column width, using auto fit, wrapping text, and resizing row height to display all content.
Learn how Excel applies the order of precedence—brackets first, then division and multiplication, then addition and subtraction—to formulas, such as quantity times price for total charges, and avoid left-to-right mistakes.
Learn to build Excel formulas starting with equals sign that multiply quantity by price, reference cells with relative references, and use sum function for subtotal, taxes, shipping, and currency formatting.
Move and resize table ranges in Excel, insert rows and columns, and update subtotals and totals automatically; count items and use Flash Fill for IDs, with borders and auto fit.
Master Excel printing with page layout adjustments for margins and scaling, fit to one page, page break preview, and print options for selection, sheets, or the entire workbook.
This is a free introduction course that will provide you with the basics of Excel. Here is a summary of what you will learn in this free intro:
Explanation of Workbook, Worksheet, Ribbon and basics of Excel
Adding text and numbers in cells
Adjusting and formatting columns, rows and cells
Adding formulas and functions
Copying & Pasting
This is only an introduction to Microsoft Excel for those who want to get a peak of what this software can offer. There is another full course that will take you from basic to advanced skills and features.
The full course starts with the basics and moves to intermediate and advanced Excel skills that will help you with your everyday tasks. You can create well-formatted documents using different fonts, colours, themes, sizes, backgrounds, pictures, and charts.
Activities will include:
- Creative thinking and problem solving - Analyzing and solving business and application problems
- Visual - Designing the visual layout of a document, spreadsheet, and charts
- Mathematical: applying the correct furmulae withing spreadsheets and tables
- Technological: using microcomputer applications to solver business problems
Some of the functionalities you will learn in the full course are:
•Advanced functions (Vlookup, IF statements, PMT, etc.)
•What if analysis and understanding error codes.
•Advanced Charts in Excel (Column, Stack, Pie, Line charts and more)