2 Hour Crash Course - Complete Beginners Microsoft Excel 2016
$55
Delivery in
5 days
- Views 244
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
Explore the marketplace!
What you get with this Offer
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
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 Offer Add-ons
-
I can personalise the beginner crash course
Additional 1 working day
+$13
What the Freelancer 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
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies