Benefits
- At the end of this course you will have a good working knowledge of Excel basics.
- You will feel more confident using Excel and be able to create a spreadsheet from scratch.
- Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments.
- Spreadsheets that you create will be easier to use and look more presentable.
- After completing this course you will be prepared to attend the Excel Intermediate training course.
Course Syllabus
- What's new in Excel
Getting Started
Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks
- Entering and Editing data
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks
- Modifying a Worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges
- Using Functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX
- Formatting Worksheets
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat
- Printing
Preparing to print
Page Setup options
Printing worksheets
- Creating Charts
Chart basics
Modifying charts
Printing charts
- Using Sparklines
PAY FOR YOUR COURSE ONLINE, BOOK NOW
Fast & secure online payment