Microsoft Excel - From Beginner to Expert in 5 Hours

Learn Basic Excel — Essential Training

About The Course

What you'll learn

  • Learn Microsoft Excel Fast: Excel formulas and functions, Excel shortcuts and tips, Excel charts and graphs, Excel for beginners & intermediate users
  • Taught by a best-selling New Ace Analytics author, Microsoft Certified Educator, Microsoft Office Specialist Expert, & Tenured College Professor
  • Conditional formatting in Excel, Excel date functions and formatting, Excel templates, Excel for Data Management
  • Data analysis in Excel, Pivot tables in Excel, Excel for data visualization, Excel data validation, Excel macros
  • Excel for business analysis, Excel for finance and accounting, Excel for sales and marketing
  • Excel for budgeting and forecasting, Excel for project management, Excel for inventory management
  • Excel functions: sum, vlookup, xlookup, if, count, average, concatenate, max, min, round, and more
  • Excel documentation: learn how to read Excel's documentation so that you are empowered to find answers
  • Hands-on exercises with solutions, Over 400,000 students taught, Lifetime course access
  • 100% satisfaction guaranteed, Learn at your own pace, This course is tested and proven

This course includes:

  • 5 hours on-demand video
  • 13 articles
  • 13 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

The Course Curriculum

- Overview

- Applications

- Excel Ribbon

- Quick Access Toolbar

- Excel Layout and Environment

- Row and Columns

- Cell and Cell Address

- Range and References

- Sheets and Workbooks

- Entering Data

- Text Formatting

- Color Formatting

- Border Formatting

- Alignment Formatting

- Fill Formatting

- Format Painter

- Merge & Center

- Custom Formatting

- Conditional Formatting

- Shortcuts

- Cut, Copy and Paste

- Insert and Delete Rows/Columns

- Hide and Unhide Rows/Columns/Sheets

- Save Workbook and Rename Worksheet

- Shortcuts

- Sorting

- Sorting Manual

- Advanced /Multi-level Sorting

- Alphabetic Sorting (A-Z or Z-A)

- Sort by Date/Number/Text

- Sort by Color

- Types of Filters

- AutoFilter

- Copying Filtered Data to Another Location

- Paste Values

- Paste Formula

- Coming Soon

- Coming Soon

- Coming Soon

- Mathematical Functions

- SUM, AVERAGE

- MIN, MAX

- COUNT

- Coming Soon

- Coming Soon

Instructor Image

SONU PANDAY

Microsoft Certified Trainer - 1 Million+ Students

4.6 Instructor Rating
579,498 Reviews
1,823,172 Students
26 Courses

Summary:

  • Over 16 years of extensive experience in Data Analysis, Data Visualization, MIS Reporting, and developing macro systems across multiple tools.
  • Certified Tableau Developer with more than 9 years of expertise in Tableau Desktop and Tableau Site Admin.
  • Coordination at various levels to ensure timely project delivery.
  • Proven track record of initiating and implementing process improvement initiatives to enhance related processes.
  • Possess strong critical thinking abilities and communication skills, with proficiency in quickly grasping and utilizing new concepts effectively.

Overall Career Overview:

Experienced Tableau specialist adept at converting business requirements into impactful visualizations. Skilled in Tableau Server administration, performance optimization, and report publishing. Proficient in SQL queries across MySQL, SQL Server, and Oracle. Expertise in creating Data Lakes to centralize offline data management. Strong ability to define data flows and templates in Excel and MySQL environments. Knowledgeable in implementing user filters for row-level security (RLS) and proposing suitable visualization views aligned with KPIs. Proficient in Tableau features like LOD, Parameter, Sets, and Actions. Experienced in end-to-end automation of data and dashboard processes. Well-versed in training team members on new technologies and BI tools. Expertise in converting excel-based reports to BI visualizations and writing VBA Macros/Python Script for data preparation. Analyzes data requirements and designs visualization solutions to meet client needs. Skilled in data analysis and preparing ad-hoc reports.

Additionally, proficient in Python for data manipulation and analysis, including feature engineering, data mapping, data cleaning, and aggregation. Skilled in creating online platforms using Python, HTML/CSS, and JQuery for data file management with LDAP Authentication. Experienced in Exploratory Data Analysis (EDA) and assisting team members with machine learning algorithms for predictions. Utilized Python libraries such as Pandas, NumPy, Sci-Kit, Scikit-learn, OpenPyXL, and ldap3.

Certificate of Recognition:

  • Received SPOT Recognition Award for exceptional performance in project delivery.
  • Recognized with Certificate of Recognition for demonstrating cooperative and collaborative behavior.
  • Received a Thank-You Letter from the Head of Department for dedication, technical expertise, and successful implementation of new initiatives.
  • Peer Recognition for Outstanding Teamwork Contributing to our success.
  • Recognized by Peers as a valuable colleague.
  • Appreciated for Developing Macro Systems to streamline processes and increase efficiency.
  • Consistently praised by higher management for achieving 100% accuracy in dashboards and ad-hoc reports.

Areas of Expertise:

Data Analytics MIS Data Visualization Excel Power Query Power Pivot VBA Macros Python Tableau Power BI SQL

Professional Experience:

  • ScatterPie Analytics Pvt. Ltd. – Delhi, India
  • Ericsson Global India Ltd. – Noida, India
  • OTSi Pvt. Ltd. – Noida, India
  • Future Retail Pvt. Ltd. – Gurgaon, India
  • Overseas Outsourcing Solutions Pvt. Ltd. – Gurgaon, India
  • Salient Business Solution Pvt. Ltd. – Gurgaon, India
  • Tech Mahindra – Noida, U.P.

Professional Experience in Diverse Industries:

Retail (Apparels/Food Chain/FMCG/Footwear), E-Commerce, NBFC, Electric Vehicle (EV) Industry, Manufacturing.

Academic Credentials:

The highest educational qualifications include a Master of Computer Application (MCA) and a Master's degree in English Literature (MA).

Student Reviews

5.0

Total 3 Ratings

  • 5
    3 Ratings
  • 4
    0 Rating
  • 3
    0 Rating
  • 2
    0 Rating
  • 1
    0 Rating

A
Anonymous
1 year ago

This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.

A
Anonymous
5 years ago

This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.


Leave a Comment

Course Information

₹ 3000
  • Course level:
    Beginner
  • Instructor:
    Sonu Pandey
  • Lesson: 13
  • Duration: 3 h
  • Last Updated:
    Oct 17, 2024

Material Includes

  • Videos
  • Articles
  • Downloadable Resources

Requirements

  • Basic computer skills
  • Interest in Excel

Tags

  • Excel
  • Advance Excel

Target Audience

  • Beginners in Excel
2024 © All Rights Reserved | Designed and Developed by NewAceAnalytics