Advance Excel with Business Analytics Training

0 student

|| Advance Excel with Business Analytics Training in Vadodara

|| Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel. The tutorial has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner.

|| You will Learn:

  • The structure of Excel and how to navigate through the user interface
  • Entering data and understanding the different data types which can be used
  • Mathematical operators and functions such as SUM, COUNT, MIN, MAX and AVERAGE
  • How to utilise the different cell referencing present in Excel
  • Introducing conditions and constraints in formulas by using functions such as IF, OR, AND, SUMIF, COUNTIF and AVERAGEIF
  • How to work across multiple worksheets and reference them correctly in formulas
  • How to create and modify graphs
  • Applying simple and more complex filters on tables
  • Naming cells and tables and utilising them in formulas
  • How to format cells in a table based on different conditions being met
  • Applying string formulas by applying functions such as LEFT, RIGHT, MID, LEN, UPPER, LOWER and CONCAT
  • How to make string formulae more dynamic

|| Who this course is for:

  • Students wanting to learn about Excel’s application to data analytics

|| Requirements

  • There are no requirements! We will be going through everything from the beginning. We just require you to have Excel installed onto your computer
  • We will be going over a lot of practice exercises in this course, so you need to make sure to work along with us and go back to practice so that you master this course!
Curriculum is empty

0.00 average based on 0 ratings

5 Star
4 Star
3 Star
2 Star
1 Star