Modules (7) Resources ()
start your excel journey.
- Course Exercise Files
Introduction to Excel 2013Resources availableIn this module you will be introduced to Excel 2013. Excel 2013 is the latest version of Microsoft’s Excel product and Excel is the world’s most popular spreadsheet product. Excel every day not only for things like personal finances, but also it’s used in big business, and is really important for business such as finance. Excel version older than the 2007 version don’t have the ribbon interface. Some of the changes in Excel 2013 are in fact intended to accommodate people that use touch screen.
Introduction - Learning OutcomesStart Topic
Introduction to Excel 2013Start Topic
What's New in 2013?Start Topic
Using TouchStart Topic
Introduction - Lesson SummaryStart Topic
Getting Started with Excel 2013Resources availableWhen creating new Workbooks, you can use templates, which will be downloaded from Microsoft, they have a description and rating to help decide whether to use them or not. The general idea of templates is somebody has gone to the trouble of creating the mechanism to make this thing work, and you could take this, maybe adapt the categories to your own requirements and needs. Templates a really excellent way of getting you started on setting up a workbook to perform a useful function.
Getting Started - Learning OutcomesStart Topic
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & ColumnsStart Topic
Templates; Creating, Opening, and Saving a WorkbookStart Topic
Online, Offline, and Contextual HelpStart Topic
Excel OptionsStart Topic
Getting Started - Lesson SummaryStart Topic
The Ribbon and ToolbarsResources availableThe ribbon interface works on a tab interface with the likes of the View tab containing all the view functions and buttons, insert tab containing all the insert functions and so forth. You get will additional tabs sometimes, for example charts tab is added when you click on a chart in the workbook. All the individual commands in a tab are grouped together.
The Ribbon and Toolbars - Learning OutcomesStart Topic
Ribbon InterfaceStart Topic
Quick Access ToolbarStart Topic
Mini ToolbarStart Topic
Create Backup Option; Auto-Recover and AutosaveStart Topic
The Ribbon and Toolbars - Lesson SummaryStart Topic
Entering and Deleting DataResources availableIn this module you'll learn how pressing the enter key after entering data in a cell your selection will be move to the cell below. Text is aligned to the left of the cell it is entered in and numbers align to the right of the cell. Moving you courser in between the top of two columns, will change the cursor to a line with a double headed arrow, which can click and drag to the right to increase the width of a column.
Entering and Deleting Data - Learning OutcomesStart Topic
Entering Text and NumbersStart Topic
Date FormatsStart Topic
Formatting Cells; Editing and Deleting DataStart Topic
Flash FillStart Topic
Entering and Deleting Data - Lesson SummaryStart Topic
Formatting a WorksheetResources availableIn this module you will learn that themes are a set or group of colours, fonts, graphics, etc. that you can use to change how to Worksheet look and feel. By default, the office theme is applied to newly made workbooks. The themes in Office 2013 are common across the applications of the Office suite. When you’re formatting there are basically three levels of formatting and the theme is at the top level of the formatting.
Formatting a Worksheet - Learning OutcomesStart Topic
Themes and Cell StylesStart Topic
Inserting, Deleting, Hiding and Adjusting Rows and ColumnsStart Topic
Wrap Text and AlignmentStart Topic
Merging Cells; Applying Themes and StylesStart Topic
Formatting a Worksheet - Lesson SummaryStart Topic
Proofing and Managing WorksheetsResources availableThe buttons for cut, copy and past are in the home tab in the clipboard group on the far-left side of the ribbon. In this module you will learn that whether paste will make a column wider, or whether paste will make a row taller, and so on largely depends both on the current situation in terms of what’s on the worksheet you’re working in and on the formatting that you’re using. The key board shortcuts, for copy is Ctrl+c, for paste is Ctrl+v, and cut is Ctrl+x.
Proofing and Managing Worksheets - Learning OutcomesStart Topic
Copy and Paste and ProofingStart Topic
Spell checkingStart Topic
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple WorksheetsStart Topic
Proofing and Managing Worksheets - Lesson SummaryStart Topic
course assessment: Microsoft Excel 2013 for Beginners - Start Your Excel Journey
Course assessmentResources available