EXCEL – Introduction (Level 1)
Attend our live sessions from anywhere | Certificate included | 0% Interest Free Plan
Acudemy
Summary
0% Interest Free payments available.
- Tutor is available to students
Add to basket or enquire
Dates
Overview
The perfect beginners course for those who are self taught or have little to no experience. You want to pick up Excel like a PRO, and you're in the right place! This course is for those who are interested in learning how to create spreadsheets. Whether you prefer Mac or PC is not important because this course will be equally suitable for both.
Description
Getting started with Microsoft Excel
• Introduction to Excel
• Navigating the Excel Screen and Ribbon
• Tips and Tricks for Selection and Movement around the screen
File Management
• Creating and Saving Workbooks
• Opening Workbooks
Data Input and Selection
• Typing and Formatting for Text, Dates and Numbers
• Selecting Cells, Rows and Columns using the Mouse and Keyboard shortcuts
Using Functions
• Using the Sum, Average, Min, Max, Count Functions
• Understanding and working with the Function Wizard
Editing Worksheets
• Adding Rows and Columns
• Sizing Rows and Columns
• Hiding/Unhiding Rows and Columns
Copying and Moving Data/Formulae
• Using Cut, Copy and Paste
• AutoFill
• Drag and Drop
• Copy and Drop
Multiple Sheets
• Creating new Sheets
• Coloring Sheet Tabs
• Navigating Sheets
• Deleting Sheets
Working with Dates
• Date Calculations
• Formatting Dates
Working with Large Worksheets
• Freezing Panes
• Working with Split Pane View
• AutoFilter
Charts and Graphs
• Creating Charts and Graphs alongside data
• Creating Charts and Graphs on a new sheet
• Changing the Chart Types
• Basic Formatting of Charts and Graphs
Formatting Worksheets
• Working with Fonts, Sizes and Colours
• Adding Borders and Fill Colour to Cells
• Aligning the Content of a Cell
• Applying Number Formatting
• Using the Format Painter
• Merge and Unmerge Cells
Who is this course for?
This course is suitable for people who are self taught or have little to no experience of using Microsoft Excel who
wish to get more confident within the package.
Objectives:
At the end of this course you will feel more confident in creating spreadsheets with everyday calculations. You will know how to format and print spreadsheets, and how to create charts. Often, self-taught users miss out on the essential features and time saving shortcuts which are covered during this course.
Requirements
Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. We would expect delegates to know how to: launch and close applications, navigate, save and open files. Delegates should have a knowledge about excel.
Career path
• Administrative Assistant
• Accountants
• Project Manager
• Data Journalist
• Information Clerk
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.