->
Udemy - Ten Excel Features Every Analyst Should Know
Udemy - Ten Excel Features Every Analyst Should Know

In this course we will learn about some awesome Excel features and how to use them with some examples commonly encountered by every analyst. 


Description

  • Text to Column
  • Flash Fill
  • Recording a Macro
  • Grouping Sheet
  • Deleting Blank Rows
  • Remove Duplicate Data
  • Auto Sum
  • Filling a Range with Ctrl + Enter
  • 3D Sums
  • Advanced Filters
  • Bonus: Conditional Formatting

    These tools should be in every analysts toolbox and will save you a lot of time and effort if you know how to use them should the need arise.

    Who this course is for:
    • For beginners who want to learn about some key features in Excel how to apply them to common data issues.

    Course content

    • Introduction
      • Introduction
      • Text to Column
      • Flash Fill
      • Record a Macro
      • Group Sheets
      • Delete Blanks
      • Remove Duplicates
      • Auto Sum
      • Fill a Range
      • 3D Sum
      • Advanced Filter
      • Bonus: Conditional Formatting


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Themelli   |  

    Information
    Members of Guests cannot leave comments.




    rss