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:
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!
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.
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.
Quiz on watermarks.
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.
Quiz on numbers being displayed as currency.
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.
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.
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.
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.
This Excel lecture will show you how to quickly find and select cells which have formulas on your worksheet.
This Excel lecture wraps up the course.
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.