Hi there! Can you solve this Excel formula?
No? Would you like too? Our beginners Excel course teaches you how to write formulas and more.
Excel is one of the power
tools of the world. Every business uses it. Microsoft Excel skills can boost your career.
In today’s economy, knowing basic digital skills like MS Excel can boost your career prospects, help you cope in an existing job and give you access to more types of jobs.
This MS Excel course is aimed at beginners and will teach you essential Excel concepts to help you in your everyday work tasks. Each section includes quizzes or activities/tasks or both to help you fully grasp concepts. As an Excel beginner here is what you will get from this Excel course:
• How to use the Excel Ribbon and Quick Access Toolbar- and customise them to suit you
• How to add, delete, rename, copy and move Excel worksheets
• How to cut/copy and paste data - including the many options Excel gives you
• How to write Excel formulas- from ground up.
• How to fully format text and understand the many options Excel provides
• How to make an Excel table in under 10 minutes and customise it
• How to make an Excel bar chart in under 10 minutes and customise it
• How to use conditional formatting to customise your Excel work
Remember this Excel course is backed by a 30 day money back guarantee so enroll today and I look forward to seeing you on the other side:)
This lecture overviews the course and the benefits you will get from this.
This lecture covers how to take screenshots of your Excel work. Note, when posting please ensure nothing sensitive or confidential is included- only the workbook area is needed.
This Excel lecture introduces the Excel menu structure commonly known as the 'Excel Ribbon'. We overview the various commands of each tab.
This Excel lecture overviews the Quick Access Toolbar. We also cover how to customise this toolbar and also how to create your own Ribbon of personal frequent commands. This lecture will be useful once the course is completed since you will by then have a list of favourite Excel items you always want available.
This lecture overviews your Excel task for this section.
This Excel lecture quickly overviews the menu we will be using for the rest of this section...
This Excel lecture introduces the section and shows you how to add and delete Excel worksheets.
This Excel lecture shows you how to rename an Excel worksheet and also the limitations in terms of the length and symbols you can include in your worksheet tab name.
This Excel lecture shows you how to move and copy Excel worksheets.
This lecture shows you how to change the colour tab of an Excel worksheet.
This lecture shows you how to hide and unhide Excel worksheets.
This lecture presents your Excel tasks for this section.
This Excel lecture overviews our strategy for learning Excel formulas for the next couple of sections.
This Excel lecture breaks down the syntax typically used for an Excel formula.
This quiz will test your knowledge of formula syntax
This lecture overviews why we are going back to basics for learning Excel formulas and then covers addition in Excel using two ways, the + symbol and the sum() function.
Tests knowledge on adding in Excel
This Excel lecture shows you how to use the multiply operator in Excel to perform calculations.
Quiz on multiplicaton in Excel
This lecture shows you how to subtract in Excel.
Quiz to test subtraction in Excel
This lecture shows you how to use the divide symbol in Excel
Excel division quiz
Tests knowledge on brackets Excel lecture
This lecture explains cell references in Excel and how to use them.
Quick lecture on using a shortcut key to edit references. This one will supercharge your productivity!
Tests references knowledge in Excel
This lecture shows you a quick way to increase your productivity when typing formulas:). One additional note- the use of the key called 'F-lock' - found on your keyboard is needed. Practically all keyboards have this key. This 'F-lock' key is also known as the 'Fn' key or 'Function' key. Depending on your computer brand, any one of these names is used- but they all do the same thing..which is enable the use of the 'F' keys on your keyboard.
This lecture quickly shows you how the F-lock key looks like on a typical keyboard. Note- the F-lock key is also known as the 'Fn' key or 'Function' key.
This mega Excel lecture covers a full worked example of using Excel formulas. It is fairly long so please rewatch it if necessary. Please note the workbook attached covers both part 1 and part 2 lectures.
This lecture looks at a couple of more worked examples for Excel formulas.
Here we look at a common way of separating two items of data in an Excel cell into two cells. Note the attached resource contains examples for the next 4 lectures too.
In this Excel lecture we look at a great way of calculating working days between two dates.
Here we look at our first example of nesting Excel formulas, that is putting one formula into a parameter of another.
In this Excel lecture we look at how to replace characters of text with another character.
This very short Excel lecture simply covers what happens when text you are looking for isn't found using the substitute() function.
In this Excel lecture we look at another nested formula example.
Tasks for this section.
In this Excel lecture we overview if then else statements in Excel and look at them via a worked example. The attached resource contains worked examples 1-3.
This lecture teaches how to use Excel's comparison operators. On their own these aren't that useful- but when combined with if then else statements become extremely powerful.
In this Excel example we look at how we can use if then else statements and absolute references to create a threshold for which data can be marked/graded against.
In this Excel lecture we take another look at absolute references in the context of a worked example. If then else statements are again used as part of the example.
Tasks for this section
This Excel lecture covers the use of the Excel AND operator. The attached resource covers both lectures (AND and OR).
This Excel lecture covers the Excel OR operator.
Tasks for this section.
This Excel lecture helps you to answer one of the most common questions in Excel formula writing- which one do I use? Note: The attached resource covers both this lecture and 'Part 2'.
Part 2 of our answer to the Excel question of which formula do I use?
This quiz will test your knowledge of Excel's formula helper.
This lecture overviews Excel's error messages - the most popular ones, why they are caused and how to fix them.
Excel error messages quiz.
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 16,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.