Are you ready to fast-track your Analytics career?
Reading data into Excel using various formats. Basic functions in Excel, arithmetic as well as various logical functions. Formatting rows and columns using Cell locking and Named Ranges. Using formulas, absolute and relative referencing in Excel.
Formulas with Absolute References. IF and Nested Functions. Working with Named Ranges. Array Functions (SUMIF & AVERAGEIF). CountIF(), SumIF(), Iferror(). Hlookup and Vlookup. Index and Match. Formula Auditing.
Tables, and Calculated Fields. VPivot LOOKUP across worksheets. Data filtering in Excel. Use of Pivot tables with categorical as well as numerical data. Introduction to the charting capability of Excel. Using the Classic PivotTable Layout. Slicers.
The Utiva training programmes help you transition to your dream job with the right skills from experienced professionals.
Why Utiva is the
best learning program for you
Data Analytics with Structured Query Language and Advanced Excel for Analytics
1-month training (Weekends Only) with a 3-month virtual internship.
Graduate from this program as a Senior data analyst with real-life work experience.
I am excited about the healthcare industry and that’s because my dissertation was based on designing a predictive model for depression, so applying computing to healthcare is my strong forte. I enrolled into the Utiva Data School with an open mind and that helped me to understand that being an expert in computer science doesn't necessarily give you the golden lux to data analytics.
Utiva has done really for me. Bringing in financial and Business Intelligence into the oil and gas space, when I came to the conclusion that data analytics is something I wanted to delve into, I contacted a friend who did a course, so I attended the masterclass and I was blown away. They have a structured curriculum, you come to classes for 5 weeks and we have online sessions too, it is a total package.
I work with one of the biggest communication brands in Nigeria and since I've taken this class, I have been able to see how data analytics is important to my job. It has positioned me as a better professional. Data analytics changes everything especially when have a client who is always looking for a way to save money and save time. The facilitators simplify every process and I'll say what made the whole difference.