Basic/Intermediate Microsoft Excel Course
Price $149

You may be great at juggling oranges, but unless you excel at Excel you're never going to get anywhere in the workplace. Whether you need to pad out your CV, or you're simply looking to learn transferable skills, our Excel courses will help you get one step ahead of the rest at work.

@ FindNLearn, we offer personalized online courses for personal and professional development. With our 30 core and Intermediate modules learn the fundamentals and Intermediate of Excel and become a skilled user in no time.

 

  • Learn on the go using any mobile, tablet, laptop or traditional devices at your own pace
  • Get unlimited 24/7 access to the tutorials and the learning materials for 12 months from the date you register
  • Find and learn from our hundreds of learning materials which includes videos, handout and loads of exercises
  • Customize your course on "need to learn basis". Create priority based list and select what you would like to learn first and then learn other areas later
  • Get the completion certification upon course completion
  • Supports Microsoft Excel 2007, 2010 and 2013 versions only
  • 24/7 email support from our experts

 

COURSE PREVIEW

 

 

How To Get Started

 

 

1. Introduction: Be an Excel genius with the help of our basic to advance Excel courses in as little as 24hours! This course outlines a complete guide from the fundamentals of Excel to very powerful complex formulas and functions. Practice our each and every example to master yourself in Excel by watching our interactive videos and using our notes as a reference guide!

 

2. How to Use Videos and Exercises: Get to know how to make most of this course. Learn the techniques how to use videos, exercises, practice templates and handouts.

 

3. Excel Transition Phase: What is the difference between 2007, 2010 and 2013 Excel? What interface, ribbons and functionalities are added in different versions of Excel?

 

Fundamentals of Excel

 

 

4. Interface and Ribbon: What functionalities Excel offers in various tabs: Insert Tab; Formula Tab; Data Tab; Purpose of different Formatting areas within Excel

 

5. Use of Excel: What is Excel used for; How to use simple Math functions; Excel file saving techniques; Different formats of saving an Excel file and why do we need that?

 

6. Formatting Techniques: Art of Formatting Techniques: Format Painter, Font Size, Bold, Italic, Underline, Fill Color, Font Colour, Left, Right and Centre Alignment, Wrap Text, Merge & Centre, Currency Sign, Numbers, Percentage, Control decimal points; Advance Formatting techniques: General, Number, Currency, Accounting, Date, Percentage, Custom Formatting and few short cuts.

 

7. Excel Workbooks Introduction: Difference between Worksheet and Workbooks. How new Excel file appears; Purpose of Excel tabs; How to create new worksheet; Change worksheet name; Apply different formatting.

 

8. Important Shortcut Keys: So many important Excel shortcut keys! Purpose of those shortcuts keys; Different types of shortcut keys using Cntrl, Alt, Cntrl + Shift, Alt + Shift, Cntrl + Shift + Enter, Cntrl + Shift + Numbers and so on

 

Functions and Formulas

 

 

9. Printing Techniques: Printing file correctly is a skill; Learn some new shortcut keys; print previews; repeat titles on each page; page setup; how to print large data sets! Functions and Formulas

 

10. Introducing Formulas: Introduction to some Basic formulas; Learn how to use formulas in Excel; Various different ways of using AUTOSUM function; Learn how and where to use Left and Right function; Calculate the length of text using Len function.

 

11. Cell Reference: The most important module in Basic Excel course: Learn absolute cell reference; How rows and columns behaves using cell references; Purpose of Dollar sign ($) in a formula; a new F4 shortcut key.

 

Administrative Tools and Techniques

 

 

12. Customization: How to change permanent and default Excel settings for Fonts, Colours, Numbers of Worksheets, Ribbons and much more

 

13. Workbook Protection: What is the purpose of protecting worksheets, workbook? How do we protect worksheets and Workbook with and without the password? Learn the importance! How to share workbooks in a working environment? 

 

14. Linking Data to Different Sources: How do we link data in Excel to different data source? Learn how to update external links; How to parse data in Excel; How to convert .txt files into Excel format and much more

 

15. Risk Assessment Techniques: Some basic principles upon which Excel crashes can be avoided; Monitor and Reduce file size; Learn Excel trouble shooting and some other Risk assessment techniques

 

Excel Functions

 

 

16. Text Functions: Define Text functions and their usage? Get introduced to Clean() and Trim() functions. Relativity between Logical conditions and Exact() function in a case sensitive manner. Thorough understanding of Ambpercent[&] to join columns together with Dollar() function.

 

17. Statistical Functions: Multiple ways to use Average() and Count() function in Excel. Use Countif() function on a single criteria and pull values using If() within Sumif() functions, combine it with Array formula to make it powerful. When to use Averageif() function.

 

18. Logical Functions: Learn the power of Logical Statement that evaluates to True and False using And() and Or() functions. Use IF() function to calculate the cumulative totals, define different value sets, hardcode a massage in double quotes.

 

19. Date and Time Functions: Learn the power of Logical Statement that evaluates to True and False using And() and Or() functions. Use If() function to calculate the cumulative totals, define different value sets, hardcode a massage in double quotes.

 

20. Maths and Trigonometry Functions: Use Sumif() function and define Cell Reference within the example; Learn the new Sumproduct() function that make tasks simpler

 

21. Find and Lookup Functions: Learn few of most important and frequently used Excel functions. Different Lookup() techniques using Approximate and Exact match; Two different techniques of using Transpose() function [Array Formula]; Pull values from various worksheets using simple Indirect() function; Combine Hlookup() with Ssumproduct in Array Form to pull values from a single and multiple Rows

 

22. Array Formulas: Learn principles or Array{} formula; How to connect various Columns and Rows using Ambpercent[&]; Learn the art of Cntrl + Shift + Enter in an Array context; Get the desired results through Array Formula

 

Identify Excel Possibilities

 

 

23. Database Features: Make your data dynamic using Table feature; Learn how to use Text to String functionality and combine it with Concatenate() function

 

24. Validation Techniques: How to create Dropdown and List in Excel; What are Control Buttons, Check Box for; Learn some other Data Validaton Techniques

 

25. Conditional Formatting: Learn the art of Conditional Formatting Techniques using 9 various examples based on Above Average, Below Average; Between Greater Than; Less Than; Data Bar; Top 10; Top 5

 

26. Macros: Automate frequent used tasks by recording Macro; Learn Macro file saving technique; Activate Developer Ribbons; Add and assign buttons to Macro

 

Reporting and Presentation

 

 

27. Pivot Table: Make large dataset interactive and create Pivot Tables; Learn how to define Datasource; What are major Pivot Table Fields; How to make interactive reports using Pivot Table; Learn Styling techniques; Introducing Two more new Ribbon Tabs

 

28. Pivot Charts: What is Pivot Charts? How to display data interactively using Pivot Charts; Link Chart Titles with the Pivot Table, Formatting technique and much more

 

29. Charts and Graphs: How to create charts in Excel; Learn the fundamentals of Charts; What is a series? What are axis? Learn different types of charts in Excel

 

30. What-if Scenario: Take you knowledge beyond next level using What-if Analysis; Create various Mortgage Payment scenario by creating interactive Mortgage Calculator using Pmt() function and Data Table functionality

;