Basic/Intermediate/Advance Microsoft Excel Course
Price $199

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 50 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

 

Advance Functionalities

 

31. Logical Functions: Learn the power of Logical Statements that evaluates to True, False with the help of multiple examples using Nested If Statements combined with the power of Index(), Coutifs(), Rows(), Row(), Small() functions; the use of And(), Or() functions stand alone and within If() that makes the formula very powerful and yield amazing results based on various multiple criteria

 

32. Text Functions: Extend your understanding of Logical Condition and compare various strings using Text functions. Get the understanding of case sensitive scenario using Exact() function or use (==) comparison operator to make exact comparison

 

33. Maths and Trigonometry Functions: Specify up to 127 conditions to use the power of Sumifs() based on multiple columns and rows; Use -- signs within Sumproduct() or create Logic Conditions with [=] operator; Customize criteria in desire formats using Text() function

 

34. Find and Lookup Functions: Learn the most used functions in Excel with superpower capabilities - Use Index() in Reference or Array form; Vlookup() to join multiple columns using Ambpercent[&] and drop downs; Transpose() Array to flip the data or alternative ways of achieving same results using Index(), Columns(), Rows(); Call in advance Name Range functionality using Hlookup() without giving Table Range

 

35. Statistical Functions: Multiple criteria? Coutifs() and Averageifs() solves this problem even if dataset is ambiguous, learn how to take help of Wildcard [*]

 

36. Array Formulas: Perform multiple calculations on one or more of the items in an Array{} and manipulate data with Indirect(), Len(), Mid(), Isnumber(), Row(); Combine these functionalities together and apply methodological calculations within to make the formula even more powerful and get the desired results. Sample formula used within the exercise 

 

Advance Conditional Formatting Techniques

 

37. Introducing Formulas To Conditional Formatting: Learn the art of Conditional Formatting with the help of Vlookup(), And(), Or(), Countif(), Logical Condition, Data Validation and flag OH Budget to Actual variance; highlight Odd, Even Rows; Row, Column and Intersecting Value; On the basis of a single or multiple criteria; Duplicate records; True entire Row; True entire Column and even more with our 10 set of examples

 

Advance Macros and Data Handelling Techniques

 

38. Importing Data Into Excel: Ready to import your database based on SAP, Access, SQL, etc.? Not a problem anymore. Step by step guide to make the learning easy; understand the database relationship; define them; perform customized user based reports and flush out unwanted data using the powerful Pivot Tables; Present them using Pivot Charts and more

 

39. Form Controls: Use automated Form Controls tools to make your life easier; Learn the difference between Labels, Check Box, Spin Button, Option Button, Group Box and so on

 

40. Dynamic Tables: Manage and analyze a group of related data easier with the help of Tables; Use Dynamic Tables to extract data into various TABS using Nested If(), Index(), Small(), Row(), Rows(), Array{}; Sample formula used within exercise 

 

41. Data Validation: Define Restrictions on what data can or should be entered in a cell using Data Validation techniques; Learn how to create Drop Down List; Restrict cell input using Warnings; How to use formulas within Vlookup(); Create Names from Selection, advance Name Range, Circles using Invalid Data option

 

42. Advance Macros: Automate frequently used task by creating Advance Macro; Create Logical Conditions using And(); Invoke Advance Filters; Record Macros and create database and store it on a different location when multiple criteria are met

 

43. VBA Interaction: Learn the Excel VBA interaction; VBA coding format; How to write basic VBA program; Sample basic and complex VBA examples: Message Box; Using formula within the VBA codes: Learn how to move data from one worksheet to another worksheet: create Buttons: Saving VBA files: Run VBA macros

 

Effective Decision Making Tools

 

44. Pivot Tables: Make large dataset interactive using Pivot Tables; Acquire the Grouping Technique; Manipulate Database to achieve desire results with or without the help of Formulas; Combine them with interactive Pivot Charts to make the decision making process effective

 

45. Power Pivots: An amazing ad-in feature available in Excel 2010 & 2013 - Perform powerful Data Analysis and create Data Models like never before; Pull data from DAX sources; Combine it with Pivot Tables and make Customized Reports

 

46. Conditional Formatting To Reports: Extend your Conditional Formatting knowledge and apply it to various Rreports such as Inventory Aging; Write Off; Balance Sheet Scorecard, etc.; Combine it with Edate(), Today() functions to become champion

 

47. Charts and Graphs: How to create effective charts and graphs using advance techniques; Use of advance formatting tools; Create advance dynamic and interactive charts; Waterfall charts; Use sample techniques to create effective charts in Excel

 

48. Conditional Formatting To Charts: Further extend your Conditional Formatting knowledge and this time we will apply to charts; show Negatives in Red and Positives in Green using Inverts options; or Formulas in 2007

 

49. Sparklines: Use interactive Sparklines to do Trend Analysis; Use small charts to reveal patterns in large datasets in a concise and highly visual way; Analyze different types of Sparklines - Lines, Columns, Win/Loss

 

50. What-if Analysis: Take your knowledge beyond next level using Whatif and create Scenario analysis; Use Scenario Maager to create multiple scenario; Create P&L, Balance sheet based on demands; Create various Forecast models; define goals and much more

;