Microsoft Excel Introduction 2010/2013/2016 | Training Course
This intensive Microsoft Excel Introduction is a great way to discover Excel's basic features.
Microsoft Excel is a powerful and popular spreadsheet program that is used for storing, organising and manipulating data, usually in a table of rows and columns. In today's world, it's the de facto application for working with numerical data. On completion of this course you will have gained the confidence, skill and practical experience to use MS Excel to create and modify a spreadsheet. You will be able to create and navigate within workbooks, use simple formulae and operations, manage worksheets, prepare spreadsheets for output and much more. If you're looking for a good starting point with Microsoft Excel, this is it.
- You should be familiar with using a mouse and working in a Windows environment.
- A working installation of Microsoft Excel is required. You can purchase the software or obtain a trial version of it from the Microsoft website.
- No prior experience of MS Excel is required.
Why take this course? Make collaborations easier - A lot of businesses and organizations already use MS Excel. Knowledge of Excel will enable you to access, share and work collaboratively on Excel projects. Enhance your ability to analyse large amounts of data – You will learn how to use powerful filtering, sorting and search tools that will help you to quickly find the information you want. Improve your job prospects - Learning Excel will open up more opportunities for employment.
Who should take this course?
- Anyone with little or no familiarity with Microsoft Excel wishing to learn the basic features in the shortest possible time.
- Self-taught users keen on mastering the fundamentals.
- Individuals aspiring to achieve Microsoft Certification status.
Duration 1 day
Microsoft Excel Introduction 1-Day Course Content
- Launching the software
- Understanding the operating environment
- The title bar
- The formula bar and name box
- The structure of an excel spreadsheet
- Workbooks, worksheets, columns, rows and cells
- The active cell
- Help features
- Creating a new workbook
- Navigating the worksheet using the keyboard, the scroll bars and the mouse
- Selecting cells, rows and columns with the keyboard and mouse
- The mouse pointer
- Using undo
- Saving a workbook and using save as
- Closing a workbook
- Opening a workbook
- Deleting a workbook
- Using the file tab
- Data types
- Entering and editing text, numeric and date values appropriately in cell and via the formula bar
- Using find and replace
- Using goto
- Moving data with cut and paste or drag and drop
- Using copy and paste
- Creating data using autofill and custom lists
- Inserting rows and columns
- Deleting rows and columns
- Creating simple formula
- Using arithmetical operations
- Entering relative formulae with the autofill tool
- Using the autosum tool
- Simple statistical summaries
- Using absolute and relative cell references
- Understanding and correcting common error messages and circular references
- Basic text and number cell formatting via the toolbar
- Borders and shading
- Using the format cells dialogue sheet to enhance the display and alignment of numbers, dates and numeric data
- Formatting rows and columns
- Using the format painter
- Adding, removing, renaming and reordering worksheets
- Moving worksheets between workbooks
- Recommended charts
- Producing different types of charts
- Changing the chart type
- Chart buttons
- Elements, styles/colour, values
- Modifying the formatting of a chart
- Adding text labels and other drawing objects to a chart
- Spell checking
- Protecting formula
- Adding comments
- Using page break preview
- Using print preview
- Applying headers, footers and other page setup options