Excel Panther : A Guide To Start Excel

Excel Mastery for Everyone: Unlock Data Power Across All Skills, Industries, and Ages

What you'll learn

Master Data Management

Advanced Formula Skills

Automation and Efficiency

Data Analysis and Visualization

Requirements

Basic Computer Knowledge: Familiarity with using a computer, including opening applications and managing files.

Access to Microsoft Excel: Students will need access to Microsoft Excel (preferably 2016 or later) to practice the lessons.

Willingness to Learn: No prior experience with Excel is required, but students should be eager to explore new features and enhance their skills.

Internet Connection: To access course materials, video tutorials, and download resources, a stable internet connection is recommended.

Description

Step into the wild world of Excel with Excel Panther, the ultimate course designed to empower you with the skills to conquer data, streamline workflows, and master advanced financial analysis. Whether you're a beginner or a seasoned professional, this course will transform you into an Excel expert ready to tackle any challenge with precision and speed.Covering a wide range of topics from Excel basics to advanced formulas and data manipulation, Excel Panther equips you with practical skills and real-world examples that will take your proficiency to the next level.Unlock the full potential of Excel with our comprehensive course, Excel Panther. This program is designed to take you from a beginner to an Excel pro, guiding you through a range of essential tools, advanced features, and powerful formulas for data management and analysis.You'll start by learning how to navigate Excel like a pro, mastering the basics of data editing, formatting, copying, and pasting. We then move on to essential tools that enhance your productivity, including customizing the Ribbon Bar for quick access to features and mastering advanced techniques like Text to Columns. Get hands-on with practical tools such as Speak Cells, managing comments, applying filters, and organizing sheets using Freeze Panes.Our course dives deep into data controls, teaching you everything from basic Fill Series functions to advanced techniques like Flash Fill. You'll explore powerful features such as Conditional Formatting, inserting Hyperlinks, and importing data from various sources to streamline your workflow.For those working with multiple sheets, you’ll explore advanced cell and sheet management, including using cell references, sheet protection, and side-by-side comparisons. We'll guide you on how to organize your sheets with custom names, colors, and groupings for effective project management.We’ll also cover essential Excel formulas, starting with mastering SUM functions, including SUMIF and SUMIFS. Then, you’ll dive into complex data handling using AGGREGATE, SUMPRODUCT, and advanced trigonometric functions. As you move forward, you’ll gain expertise in AVERAGE-related formulas and understand how to use COUNT functions to handle data efficiently.Logical IF formulas are a key part of this course, where you’ll learn how to automate decision-making with IF, IF AND, IF OR, and IFERROR functions. Additionally, you’ll explore text extraction, manipulation, formatting, and conversion techniques to handle any data type confidently.

Overview

Section 1: E1. MS Excel - Start-up

Lecture 1 E1.1 How to Launch MS Excel

Lecture 2 E1.2 Start Screen - Back Stage Screen - Navigating MS Excel

Lecture 3 E1.3 User Interface - Navigating MS Excel Workbook Screen

Lecture 4 E1.4 Home Tab - Basic Editing Tools

Lecture 5 E1.5 Copy and Paste I using Multiple Tools in MS Excel

Section 2: E2. MS Excel – Basic Tools to know

Lecture 6 E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools

Lecture 7 E2.2 Text to Column – Multiple methods

Lecture 8 E2.3 Speak Cells – Data Reading Tool

Lecture 9 E2.4 Comments - Add, Edit, Delete, Copy Paste, Background change

Lecture 10 E2.5 Filters in MS Excel

Lecture 11 E2.6 Freeze Panes and Split Window

Section 3: E3. MS Excel – Fill Series and Data, Sheet Controls

Lecture 12 E3.1 Fill Series - Basics

Lecture 13 E3.2 Fill Series - Advanced

Lecture 14 E3.3 Fill Series - Flash Fill

Lecture 15 E3.4 Conditional Formatting

Lecture 16 E3.5 Hyperlinks to Sheets, Web pages, Files

Lecture 17 E3.6 Header and Footer Settings

Lecture 18 E3.7 Printing and Paper Settings

Lecture 19 E3.8 Import Data from Web

Lecture 20 E3.9 Import Data from Text File with Auto Refresh

Lecture 21 E3.10 Import Objects into Excel

Section 4: E4. MS Excel – Working with Sheets

Lecture 22 E4.1 Characteristics of a cell

Lecture 23 E4.2 Cell References – Relative Ref, Absolute Ref, Mixed Ref

Lecture 24 E4.3 Custom View

Lecture 25 E4.4 Sheet protection

Lecture 26 E4.5 Cell Protection

Lecture 27 E4.6 Compare sheets side by side I View Sheets side by side

Lecture 28 E4.7 Compare sheets from Multiple Files

Lecture 29 E4.8 Working with cells, rows, columns, Specific Size, Auto Fit

Lecture 30 E4.9 Working with sheets rename, colour, copy, move, grouping

Section 5: E5. SUM related formulas

Lecture 31 E5.1 Things to remember before starting formulas

Lecture 32 E5.2 SUM

Lecture 33 E5.3 SUMIF

Lecture 34 E5.4 SUMIFS

Lecture 35 E5.5 SUBTOTAL

Lecture 36 E5.6 AGGREGATE

Lecture 37 E5.7 SUMPRODUCT

Lecture 38 E5.8 SUMSQ

Lecture 39 E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry

Lecture 40 E5.10 DSUM - DATA BASE SUM

Lecture 41 E5.11 IMSUM vs IMSUB – Complex Data Calculations

Section 6: E6. AVERAGE related formulas

Lecture 42 E6.1 AVERAGE

Lecture 43 E6.2 AVERAGEA

Lecture 44 E6.3 AVERAGEIF vs AVERAGEIFS

Lecture 45 E6.4 Weighted Average with VBA Code

Section 7: E7. COUNT related formulas

Lecture 46 E7.1 COUNT, COUNTA, COUNTBLANK

Lecture 47 E7.2 COUNTIF vs COUNTIFS

Section 8: E8. LOGIAL- IF related formulas

Lecture 48 E8.1 LOGICAL TEST with Comparative Operators

Lecture 49 E8.2 IF

Lecture 50 E8.3 IF AND vs IF OR

Lecture 51 E8.4 IFS vs NESTEDIF

Lecture 52 E8.5 IFERROR

Lecture 53 E8.6 SWITCH

Section 9: E9. TEXT EXTRACTION AND MANIPULATION

Lecture 54 E9.1 LEFT, RIGHT, MID and LEN

Lecture 55 E9.2 FIND vs SEARCH

Lecture 56 E9.3 REPLACE vs SUBSTITUTE

Section 10: E10. TEXT FORMATTING AND CONVERSTION

Lecture 57 E10.1 CONCAT vs CONCATENATE

Lecture 58 E10.2 TEXT

Lecture 59 E10.3 UPPER, LOWER, PROPER

Lecture 60 E10.4 TRIM

Lecture 61 E10.5 SPELLNUMBER with VBA code

Lecture 62 E10.6 TEXT-TO-NUMBER with VBA code

Beginners: Individuals with little or no experience in Excel who want to build a solid foundation.,Professionals: Working professionals looking to improve their Excel skills for better productivity and data management.,Business Owners & Entrepreneurs: Those wanting to manage their business data, finances, and operations more effectively using Excel.,Students: Learners seeking to enhance their analytical skills for academic projects and future job opportunities.,Job Seekers: Candidates looking to boost their resumes with advanced Excel skills to stand out in the job market.