Practical Excel Session from FITA Academy Register Now
Fresh graduates and students can explore the Excel fundamentals to pave the way for a data-focused career.
Excel benefits professionals across various fields, including HR, engineering, sales, marketing, statistical analysis, finance, and legal practices. It aids in organizational skills, technical data analysis, data-driven strategy development, data management, financial modeling, and case presentation.
Maximize your business potential through Excel expertise! Learn to crunch numbers, visualize data, and streamline operations for success.
Advance your data skills with our Excel training, perfect for statistical modeling and data visualization enhancement.
Discover the impact of data analysis across fields and unlock new career opportunities or satisfy your data intrigue.
Basics about Excel
Define and apply names
Alignment and Number Formats in Excel
Sorting Data in a List
Filtering Data in a List
Using Formulas Spanning Multiple Worksheets
Freezing of Rows and Columns
Working with IF Function
Working with Nested IF and IFS Functions
Working with AND/OR Functions
Working with IF along with AND/OR Functions
Working with SUMIF, AVERAGEIF and COUNTIF Functions
Working with SUMIFS, AVERAGEIFS and COUNTIFS Functions
Working with VLOOKUP and HLOOKUP Functions
Working with XLOOKUP Function
Consolidating Data
Adding and Formatting elements in Charts
Converting a List to Table
Understanding and working with Charts
Adding and Formatting elements in Charts
Working with Pivot Tables
Working with Field Lists and designs in Pivot Tables
Slicers and Timelines in Pivot Table
Inserting Pivot Charts
Creating basic Dashboards in Excel
Understanding the new Quick Analysis Tool
Yes. This is a beginner friendly program, our trainers guide you to applying this skillset in various careers.
No, It’s a 100% Live Workshop.
Yes, There is no prior math knowledge is required at earlier stage of learning this course.
Once you successfully complete the course and submit the task, you are eligible to receive a certificate.
Having doubts during online classes indicates active learning! In our live webinars, an experienced trainer will be present to address every student's questions individually, ensuring that no doubt, whether big or small, goes unanswered.