Excel Master

In this first sprint of MS Excel Skills for Real world, you will learn the essentials of Microsoft Excel. You will be able to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.

• First step into Excel
  You will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets
• Calculation World
  Will introduce to Formulas and Functions
• Aesthetics
  Aesthetics tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes
• Play with data
  Day in Day out data – this sub sprint will walk you through find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting
• Print it to see it
  How to optimize your spreadsheet for printing by managing margins, orientation, headers & footers

In this second sprint of MS Excel Skills for Real world, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.

• Workbooks and Worksheets
  Combine data, manage datasets and perform calculations across multiple sources.
  
  
  
• Date and text functions
  This module discusses ways you can extract information and manipulate data to fulfil specific business requirements and will be pro in text and date functions
• Whats there in name ?
  Everything you need to know about Name Range
• The Synopsis of data
  Learn how you can use functions like SUMIFS, COUNTIFS and more to extract information from data, as well as generate graphical representations of it
• Book me a table
  Make you excel work faster by using Tables in excel
• More Slices, More Tables , More Charts
  Tools to make you PRO

In this last sprint of our Excel for Real World, we will prepare you to become a power user of Excel.

• All I need is Documentation
  Advanced sprint focuses on creating and maintaining accurate, flexible, responsive and user-friendly spreadsheets. You will learn how to design flexible and auditable spreadsheets, construct transparent calculations, create user-friendly navigation, and use styles, themes and formatting to tie it all up in a nice bow.
• Going 5th gear on Formula
  Use of array formulas, how to build them and use them effectively.
• Good start, Half work done
  Data cleansing and preparations
• Financial Modelling
  This to know in Financial modelling
• Going 5th gear on Functions
  Automate your work with nested and advance functions
• The final Stone - Dashboard
  Build a breathtaking professional Dashboard. Start building your story with data.

In this third sprint of MS Excel Skills for Real world, you will be one step closer to become a pro.

• Your data
  We kick off this course with data validation and conditional formatting and more
• If this then that..
  Start by building sense to data.
• Lookups and you
  Learn the lookups and more lookups. All you need is this
• Security and Audits
  Learn to protect your work
• Teach me Modelling
  Learn data modelling. Learn to model different scenarios based on input, assumptions and/or outcomes. Also learn the use of functionalities like Goal Seek, Data Tables and the Scenario Manager to make your models more robust.
• Macros!!!!
  Catalyst in excel work. Learn this and you will be 10x ahead
• World of visuals
  
  
  Charts is what excel makes this software worth learning. Learn how to present visually by charts