2 Hour Crash Course - Complete Beginners Microsoft Excel 2016

Delivery in
5 days

  • Views 34
  • 0

What you get with this Hourlie

One to one remote interactive Microsoft Office Word 2016 training with screen sharing via Skype and hands-on tasks to be completed during the sessions.

The 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.

Requirements for this course:
No prior Microsoft Excel knowledge required.

Choose any 2 of the below topics - then based upon your learning pace more topics may be added during the tuition, it's up to you!

Course Outline:

Topic 1 - Getting Started:
- Spreadsheet terminology
- Exploring the Excel window
- Getting help
- Opening and navigating workbooks
- Closing workbooks
Topic 2 - Entering and Editing data
- Creating workbooks
- Entering and editing labels and values
- Entering and editing formulas
- Saving and updating workbooks
Topic 3 - Modifying a Worksheet
- Moving and copying data
- Moving and copying formulas
- Using absolute references
- Inserting and deleting ranges
Topic 4 - Using Functions
- Entering functions
- Using AutoSum
- Using AVERAGE, MIN, and MAX
Topic 5 - Formatting Worksheets
- Formatting text
- Formatting rows and columns
- Number formatting
- Using Format Painter and AutoFormat
Topic 6 - Printing
- Preparing to print
- Page Setup options
- Printing worksheets
Topic 7 - Creating Charts
- Chart basics
- Modifying charts
- Printing charts
Topic 8 - Using Sparklines

Get more with Hourlie Add-ons

  • I can personalise the beginner crash course

    Additional 1 working day


What the Seller needs to start the work

You need to have:
- Basic computer skills
- Access to a computer
- Access to the internet
- Microsoft Office Excel 2016 installed