Intermediate Microsoft Excel Course
Price $89

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 19 modules learn the 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

 

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

 
;