Overview
Master the Basics of Excel: how to navigate Excel, create a spreadsheet and save your work, Learn about the Text, Mathematical, Date and Time, Logic, Financial, Informational Excel Formulas, Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!, We teach you how to use Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!, Create interactive Excel Dashboards that will get you noticed by top management & prospective employers
Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and more, People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!, People who work with large volumes of data and want to quickly sift through, analyze, and chart the data in a professional way, Import data into Excel from an external source e.g. ERP System like Oracle, SAP, PeopleSoft, company database, Access, Web etc...and need to quickly & accurately analyze that data and extract valuable information
Compatible with Excel 2011, 2016 and Office 365 for Mac, This course was recorded using Excel 2010, 2013 & 2016, so you will get every new feature covered, Compatible with Microsoft Excel 2007, 2010, 2013, 2016, 2019 & Office 365
Welcome to "Excel Mastery: The Ultimate Excel Course for Power Users"! This comprehensive course is designed to take your Excel skills to the next level and transform you into an Excel power user. Whether you are a beginner or have some experience with Excel, this course will provide you with the knowledge and techniques to become proficient in advanced data analysis and automation.
Throughout this course, we will explore a wide range of topics and functionalities that will empower you to tackle complex data analysis tasks with ease. You will learn advanced formula and function usage, including array formulas, nested functions, and statistical analysis functions. We will dive deep into data visualization techniques, demonstrating how to create dynamic charts, sparklines, and conditional formatting.
Moreover, this course will equip you with the skills to harness the power of PivotTables and PivotCharts for in-depth data summarization and analysis. You will discover how to work with large datasets efficiently, apply filters, and use slicers to extract key insights from your data.
Automation is another crucial aspect covered in this course. You will learn how to create macros and use Visual Basic for Applications (VBA) to automate repetitive tasks and streamline your workflow. From recording simple macros to writing custom VBA code, you will gain the ability to automate complex processes, saving valuable time and effort.
Throughout the course, you will have hands-on practice with real-life examples and exercises, allowing you to apply your newfound knowledge immediately. Additionally, you will have access to downloadable resources, including exercise files and reference materials, to support your learning journey.
By the end of this course, you will have mastered advanced data analysis techniques, gained proficiency in Excel automation, and acquired the skills to become an Excel power user. Prepare to unlock the full potential of Excel and revolutionize the way you work with data. Enroll now and embark on your journey to Excel mastery!
Akhil Vydyula
Hello, I'm Akhil, an Associate Consultant at Atos India with a focus on the Advisory Consulting practice, specializing in Data and Analytics. My professional journey has led me through various facets of data analysis and modeling, particularly in the BFSI sector, where I've had the privilege of overseeing the full lifecycle of development and execution.
My skill set encompasses a wide range of data-related tasks, including data wrangling, feature engineering, algorithm development, model training, and implementation. I thrive on leveraging data mining techniques such as statistical analysis, hypothesis testing, regression analysis, as well as both unsupervised and supervised machine learning processes to extract meaningful insights and drive data-informed decisions. I'm particularly passionate about risk identification through decision models, and I've honed my expertise in Machine Learning Algorithms, Data/Text Mining techniques, and Data Visualization to effectively address these challenges.
Currently, I'm immersed in an exciting Amazon cloud project that involves end-to-end development of ETL processing. In this role, I craft ETL processing code using PySpark/Spark SQL to extract data from S3 buckets, perform necessary transformations, execute scripts using EMR services, and load consolidated data into Postgres SQL (RDS/Redshift) on a full, incremental, and live basis. To streamline this process, I've automated it by creating jobs in Step functions, which trigger EMR instances to run scripts in a specific order and send notifications upon execution status changes. The scheduling of these Step functions is achieved through event bridge rules.
Additionally, I've worked extensively with AWS Glue, using it to replicate source data from on-premises systems to raw-layer S3 buckets via AWS DMS services. One of my key strengths lies in my ability to understand the nuances of data and apply the right transformations to convert data from multiple tables into key-value pairs. Furthermore, I've optimized the performance of stored procedures in Postgres SQL to execute second-level transformations by efficiently joining multiple tables and loading the data into final tables.
I'm passionate about harnessing the power of data to drive actionable insights and improve business outcomes. If you share this passion or are interested in collaborating on data-driven projects, feel free to connect with me. Let's explore the endless possibilities that data analytics has to offer!