Microsoft Excel tricks (MacBook & Windows) beginner-advanced

Microsoft Excel tricks (MacBook & Windows) beginner-advanced

Became advanced user today! Hack 2010, 2013, 2016, Excel 2019, Office 365: functions & formulas, data analytics, charts!

What you’ll learn

  • More then 40 Microsoft Excel tricks ( for Windows and Macbook)
  • Microsoft Excel Functions & formulas – XLOOKUP, FILTER, CONVERT, UNIQUE, CHOOSE, PMT (and a lot more)
  • Microsoft Excel Beginners tricks – 3D references, Transpose, Filled Map, Autofit, how to ad your own picture in a charts (and a lot more)
  • Microsoft Excel features for data analysis and visualization – Getting  data from web, Advanced filter, Pivot tables, Analysis Tool pack
  • Microsoft Excel features for business, finance and forecast – What if analysis, Scenario manager, Payment (PMT), Goal seek
  • Microsoft Excel ittle useful tricks, such as – tracking changes, Excel translator, Excel Ideas and how to do VLOOKUP on left side
  • You will know a lot of Microsoft Excel SHORTCUTS
  • Learn the most common Excel functions and formulas used in the Office
  • Maintain large sets of Excel data in a list or table ( plus data analysis )
  • Learn how to use Pivot Tables, Slicers and other Excel visualization tools for Interactive Excel Reports
  • Get lifetime access to Excel quizzes and exercises

Requirements

  • You need PC, notebook or MacBook
  • You have to have Microsoft Excel or access to Google Spreadsheets
Who this course is for:
  • People who want to start study Excel and have no any experience in it
  • Excel users who have basic skills but want to be BETTER
  • Data analytics, Marketers, Business owners, Investors, Finance specialists, Insurance agents
  • Entrepreneurs, Teachers, office workers,
  • Anyone who works with huge data
  • Students, who want to develop their skills, and make their labor and life more effective
  • Anyone who want to expand their analytics skills, work more efficiently with data
  • Anyone who want to take their career to a new level
  • And you are also 🙂

Tags:

Tutorial Bar
Logo