
Explore Excel basics in this beginner introduction for first-time users. Master workbook layout, navigation, the ribbon and quick access toolbar, basic data formatting, copy-paste, templates, and saving, printing, and viewing.
Explore the Excel beginner interface, including the quick access toolbar, ribbon, formula bar, and cell references, and learn basic data entry, formatting, sheets, and templates.
Open Excel to create a blank workbook or choose templates, then save or save as, recover unsaved workbooks, and share, print, or export your file.
Learn to format text and numbers in Excel by applying fonts, colors, alignment, wrap and merge, plus decimals, currency, and date formats.
Learn how to use Excel's copy and paste options—from cut vs copy to paste special values, formatting, and comments; apply transpose and autofill for efficient data handling using keyboard shortcuts.
Learn how to view multiple sheets in one workbook by opening a new window and using arrange all to work in two sheets simultaneously.
BEGINNER - INTRODUCTION TO EXCEL/FIRST TIME USER
Excel was released in 1985 and has grown to become arguably the most important computer program in workplaces around the world. In business, literally, any function in any industry can benefit from those with strong Excel knowledge. Excel is a powerful tool that has become entrenched in business processes worldwide—whether for analyzing stocks or issuers, budgeting, or organizing client sales lists.
Are you new to Excel or have you recently joined the workforce? Do you have new recruits who will need to use Excel to fulfil daily work duties? If you’ve answered yes to any other above questions, then join us for a two-hour webinar where we introduce delegates to Microsoft Excel.
The objective of session 1 is to enable delegates to open and create Excel workbook files, use the 2016 interface, format worksheets and data, and become comfortable with the Excel interface by looking at the following:
· Introduction
o Terminology
o Layout and interface
o Move or copy sheets
o Status Bar
o Print Preview and set print area o Formatting data (changing appearance) and format Painter
o Various ways to Paste data
o How Windows Regional Settings may affect your Excel
· Recovering Lost Documents and using the auto-save function
· Built-in Templates - Exploring pre-created templates, e.g.
o Budgets
o Expense tracker
o Invoices
· Navigating Seamlessly
o Freeze panes
o Quick access toolbar
o How to navigate without a mouse
o Line breaks.