Excel 2016 Course- Beginners Excel Tips Part 2
4.4 (37 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,349 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Course- Beginners Excel Tips Part 2 to your Wishlist.

Add to Wishlist

Excel 2016 Course- Beginners Excel Tips Part 2

Excel 2016 tutorial tips course on Excel to work better and quicker.
4.4 (37 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,349 students enrolled
Last updated 2/2017
English
Price: Free
Includes:
  • 1 hour on-demand video
  • 2 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use the tips applied to aid their everyday Excel work and increase productivity
View Curriculum
Requirements
  • Students will need to have a basic understanding of MS Excel
  • A willingness to learn
  • A PC and Excel 2013 or Excel 2016
Description

This Excel tips course is designed to help you further your Excel skills. Aimed at beginners, it shows you how to do simple things which perhaps you might at some point need to do in Excel. For example watermarking a document or customising numbers to show as currency.

Think of this course as a basics course which just shows you 'how to' in Excel.

This basic Excel 2016 course is suitable for beginners to intermediate users and teaches the following:

  • How to add a watermark in Excel
  • How to customise numbers to show as currency in Excel
  • How to add shapes in Excel
  • How to add Hierarchy diagrams in Excel
  • How to add Cycle flow diagrams in Excel
  • How to add Funnel diagrams in Excel


This is not an advanced course so please bear that in mind before considering enrolling. What this course is though is a bite size course - In 1 hour you can pick up everything taught. How cool is that? The lectures have been kept as simple as possible yet illustrate effectively how to use the taught concept.

As with all courses by Mach 42 Productions, full support is given via the course discussion forums. This course is filmed using the latest copy of Excel 2016 and is in HD quality. The great thing about this course is that you can apply what is taught to ANY of your daily work tasks in Excel regardless of the industry you are in.

Remember Excel is used in practically all businesses. Its a powerful tool- so why not learn it? Sign up today and I look forward to seeing you on the other side!


Who is the target audience?
  • Students who just want simple tips to use Excel to help them get through their daily work
  • Junior Analysts who are just starting out
  • Students studying at university who are required to use Excel in their coursework/assignments
  • Do not take this course if you are an advanced user of Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction to course!
2 Lectures 03:01

This lecture overviews the Excel course and explains the purpose of the course, the aim of the course and best ways to learn from this Excel course.

Welcome lecture
01:57

Introduce yourself!
01:04
+
'How to' in Excel
7 Lectures 48:18

This Excel lecture will show you how to add a watermark to your Excel spreadsheet. Watermarks are often used to mark documents 'Draft' or 'Confidential'. The method we show you here is simple and effective to get these type of results.

How to add a watermark in Excel to your spreadsheet
06:49

Quiz on watermarks.

Watermark quiz
3 questions

This Excel lecture will show you how to customise numbers to display as currency in your spreadsheet cells. We will also show you an important step to make you aware of what this method does to the number and what it doesn't. 

How to customise numbers to display as currency in Excel
11:32

Quiz on numbers being displayed as currency.

Format quiz
2 questions

This Excel lecture will show you how to add shapes in Excel. Shapes are really good for enhancing spreadsheet data. We will overview three common types of shapes often used in Excel.

How to add shapes in Excel
10:29

This Excel lecture will show you how to add Hierarchy diagrams in Excel. These diagrams are great for illustrating company structures and will save you lots of time by using one of Excel's templates and modifying them as opposed to making one from scratch.

How to add Hierarchy diagrams in Excel
08:21

This Excel lecture will show you how to add Cycle flow diagrams in Excel. These diagrams are great for illustrating cycles for processes and concepts. We will give an example of a staff flow diagram used to show the different attributes that contribute to happy(!) staff.

How to add Cycle flow diagrams in Excel
04:27

This Excel lecture will show you how to add a funnel diagram in Excel. These diagrams are great for showing how elements come together (merge) or get filtered to produce an outcome. These diagrams are often great for printing out and sticking on notice boards to remind staff of outcomes and values of their team function.

How to add a Funnel diagram in Excel
03:25

This Excel lecture will show you how to quickly find and select cells which have formulas on your worksheet.

How to quickly locate cells which have formulas in Excel
03:15
+
The End!
2 Lectures 02:59

This Excel lecture wraps up the course.

End lecture
00:37

Bonus lecture
02:22
About the Instructor
Mach 42 Productions
4.3 Average rating
579 Reviews
17,252 Students
13 Courses
Excel Consulting | 17,200+ Students | 13 Courses

Our Udemy Excel courses have been developed to cover a wide range of needs for the Excel user. There is a course to suit everyone from beginners level to advanced. We provide all workbooks and full support via the discussion forums. Simply put our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.

Our Excel IT Consultant/Instructor Navin has been in the IT industry for approximately ten years. Recently featured nationwide in Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.

During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.

This spurned Navin's need to develop these range of Excel courses which to date have over 17,200 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.