Advance Microsoft Excel Course
Price $99

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 20 super advance modules learn the advance funcationalities and formulas 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

 

 

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

;