Microsoft Excel Introduction
- 3 hours on-demand video
- 2 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- This intensive one-day training course is designed to let users get to grips with the main features of Microsoft Office Excel 2007, 2010, 2013 or 2016, including a thorough treatment of the new 'Ribbon' interface, originally introduced with Excel 2007. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.
- A basic understanding of Microsoft Windows
MODULE 1: Getting Started with Microsoft Excel
Learning outcomes: Starting Excel and some of its basic navigation and help controls.
Exploring your Workbook
Getting Help with Excel
MODULE 2: The Excel Interface
Learning outcomes: A look at the Ribbon interface and the different tabs and options the Ribbon offers.
The Quick Access Toolbar and File Menu
The Home Tab
The Insert Tab
The Page Layout Tab
The Formulas Tab
The Data Tab
The Review Tab
MODULE 3: Microsoft Excel Basics
Learning outcomes: Identify and Use Cells, Columns, Rows, Workbooks to enter and manage data.
Working with Excel
Moving your Data
Basic Excel Features
Smart Tags and Options Buttons
MODULE 4: Editing your Workbook
Learning outcomes: Understanding formatting features and enhancing a workbook's overall appearance and using Conditional Formatting.
Enhancing a Worksheet's Appearance
MODULE 5: Printing and Viewing your Workbook
Learning outcomes: Exploring Excel's printing and viewing options enhancing your ability to print and work with your data effectively.
Using the View Tab
Managing a Single Window
Managing Multiple Windows
Printing your Workbook
Print Page Layout options
MODULE 6: Working with Charts in Excel
Learning outcomes: Introducing charts within Excel and explain how to create basic charts to help convey your data with.
Using Recommended and Standard Charts
Chart Tools - Design & Format
- The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.