HOT
blank

A Beginners approach to Advanced Excel

Office Productivity

A Beginners approach to Advanced Excel, available at $19.99, has an average rating of 4.5, with 136 lectures, based on 26 reviews, and has 120 subscribers.

Rating4.5
Enroll Now

You will learn about Learn A to Z of Excel with hands on demos & practice sessions explaining everything from Scratch to Advance All essential formulas and functions in excel and their application. Data Visualization , Basic and advanced charts and graphs and Dynamic Graphs Conditional formatting, Whatif – Goal Seek and Scenario Manager Solver for resource management and transportation problems This course is ideal for individuals who are This is complete course for all Management Student. or This course is perfect for newbies or beginner who needs to learn much more than just the basics. or This course is very good for intermediate Excel users who needs to update and upgrade their skills pivot table, visualization and advanced charts and graphs. or Professionals looking for a career in data analysis in corporate sector or PhD students and researchers looking for statistical application or Educators and teachers looking forward for teaching excel skills to their students or Administrative assistants, office clerks, information staff Business, management, market analysts looking to upgrade their productivity (Excel) skills or Project managers, Sales, Marketing or training managers who are looking smart formulas, tricks and tips to manage their daily work routine It is particularly useful for This is complete course for all Management Student. or This course is perfect for newbies or beginner who needs to learn much more than just the basics. or This course is very good for intermediate Excel users who needs to update and upgrade their skills pivot table, visualization and advanced charts and graphs. or Professionals looking for a career in data analysis in corporate sector or PhD students and researchers looking for statistical application or Educators and teachers looking forward for teaching excel skills to their students or Administrative assistants, office clerks, information staff Business, management, market analysts looking to upgrade their productivity (Excel) skills or Project managers, Sales, Marketing or training managers who are looking smart formulas, tricks and tips to manage their daily work routine.

Enroll now: A Beginners approach to Advanced Excel

Summary

Title: A Beginners approach to Advanced Excel

Price: $19.99

Average Rating: 4.5

Number of Lectures: 136

Number of Published Lectures: 136

Number of Curriculum Items: 136

Number of Published Curriculum Objects: 136

Original Price: ₹7,900

Quality Status: approved

Status: Live

What You Will Learn

  • Learn A to Z of Excel with hands on demos & practice sessions explaining everything from Scratch to Advance
  • All essential formulas and functions in excel and their application.
  • Data Visualization , Basic and advanced charts and graphs and Dynamic Graphs
  • Conditional formatting, Whatif – Goal Seek and Scenario Manager
  • Solver for resource management and transportation problems

Who Should Attend

  • This is complete course for all Management Student.
  • This course is perfect for newbies or beginner who needs to learn much more than just the basics.
  • This course is very good for intermediate Excel users who needs to update and upgrade their skills pivot table, visualization and advanced charts and graphs.
  • Professionals looking for a career in data analysis in corporate sector
  • PhD students and researchers looking for statistical application
  • Educators and teachers looking forward for teaching excel skills to their students
  • Administrative assistants, office clerks, information staff Business, management, market analysts looking to upgrade their productivity (Excel) skills
  • Project managers, Sales, Marketing or training managers who are looking smart formulas, tricks and tips to manage their daily work routine

Target Audiences

  • This is complete course for all Management Student.
  • This course is perfect for newbies or beginner who needs to learn much more than just the basics.
  • This course is very good for intermediate Excel users who needs to update and upgrade their skills pivot table, visualization and advanced charts and graphs.
  • Professionals looking for a career in data analysis in corporate sector
  • PhD students and researchers looking for statistical application
  • Educators and teachers looking forward for teaching excel skills to their students
  • Administrative assistants, office clerks, information staff Business, management, market analysts looking to upgrade their productivity (Excel) skills
  • Project managers, Sales, Marketing or training managers who are looking smart formulas, tricks and tips to manage their daily work routine

A study by well known analyst group revealed that Excel skills are required for the vast majority (82%) of middle-skill positions. Proficiency in using productivity software also provides a pathway to high paying jobs for workers without a college degree. Certified Excel skills have been found to increase the likelihood of promotions and lift earnings by 14%. Are you ready to land your next job and increase your pay by around 14%?

This course is designed to train the basic, intermediary and advanced theoretical and practical application of Excel.  If you need to update and upgrade your productivity (Excel) skills, then as a beginner or an intermediate user, this course is perfect for you, This course provides training videos along with examples of built-In Functions and formulas and also shows you how to combine these functions with each other, and with different type of operators (like +, -, *, /, etc.), to create Excel Formulas. Along with this, Course also covers practical industry applications of these functions and formulas.

By the time you complete this course, you will be able master the most popular Excel tools and would be able to use these tools and techniques in your daily work and business life. Below given are the few glimpses that you will master after successfully learning and completing this course. You will be able to:-

  • Create basic and advanced problem solving spreadsheets.

  • Handle, Manage and Modify large data sets.

  • Master the use of some of Excel’s most popular and highly sought after functions (LOOKUP formulas and functions)

  • Create dynamic report with using PivotTables and Slicers

  • Use statistical tools, techniques and formulas.

  • Use financial functions and formulas.

  • Work on Data Table, Goal seek and scenario functions and their use in Business activities

  • Work on transportation and resource management problems using advanced tools like SOLVER

  • Work on Excel Array Formulas, which is an essential learning for some of the more complex (but most useful) Excel functions and formulas.

For beginners, this course provide a strong understanding of the basic Excel features, which will help you to get the best use of Excel functions and formulas. There is also a section on Excel Errors which will help you to diagnose and fix any errors that you encounter.

For intermediate user and for those who want to become avid advanced user,  With the help of our step-by-step lectures, Excel will become a natural part of your spreadsheet development, enabling you to perform complex analysis and automate repetitive tasks.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Why Excel

Lecture 2: Launching Excel and creating Shortcut

Lecture 3: An Introduction to Excel Interface

Lecture 4: A study of where is everything…!!

Lecture 5: Creating and Saving Excel Document

Lecture 6: Very common ShortCuts-Cut, Copy Paste Undo and Redo

Lecture 7: Row Column Cell Formatting

Lecture 8: Basic Font Formatting and Format Painter

Lecture 9: Alignment Formatting

Lecture 10: Number Formatting

Lecture 11: Formatting Example

Lecture 12: Data Behaviour in cells

Lecture 13: Working with Numeric Data and Dates

Lecture 14: Working with Text/AlphaNumeric Data

Lecture 15: Find and Replace

Lecture 16: Quick Access Toolbar

Lecture 17: Creating your own Tab

Chapter 2: Basic Formulas & Functions

Lecture 1: Creating Basic Formulas

Lecture 2: Basic Group Functions – SUM

Lecture 3: Basic Group Functions – MAX, MIN, AVERAGE, COUNT, PRODUCT

Lecture 4: Adding/Deleting Comments

Lecture 5: Intersection Operator and SUM function

Lecture 6: USING AUTOSUM

Lecture 7: Auto Fill: Fill Series Part 1

Lecture 8: Auto Fill – Flash Fill Part 2

Lecture 9: Create Custom List

Lecture 10: Clear, Goto and Goto Special

Lecture 11: Control(CTRL) Key Shortcuts

Lecture 12: ALT Key ShortCuts

Chapter 3: Managing Worksheets

Lecture 1: Link Data in different sheets

Lecture 2: Hide, Move and Copy Worksheets

Lecture 3: Freezing Rows and Columns

Lecture 4: Comparing Same sheet Side by Side

Lecture 5: Splitting Sheets Pane

Lecture 6: Link Data in Different Excel files-1

Lecture 7: Excel Options

Chapter 4: Paste Special

Lecture 1: How to use Paste Special

Lecture 2: Paste Special with Maths Operators-1

Lecture 3: Paste Special with Maths Operators-2

Lecture 4: Paste Special-Other Options

Lecture 5: Tranpose using Paste Special

Chapter 5: Graphs and Charts-An Introduction

Lecture 1: Column Chart

Lecture 2: Different Elements of a Chart

Lecture 3: Editing Charts – 1

Lecture 4: Editing Charts – 2

Lecture 5: Line – BAR – AREA Chart

Lecture 6: Stacked Area Chart

Lecture 7: Pie and Doughnut Chart

Lecture 8: Combo Charts

Lecture 9: Add Trendline and Forecast

Lecture 10: Handle Missing data in Graphs

Lecture 11: Change Default chart

Chapter 6: Filters

Lecture 1: An Intro to Filters

Lecture 2: NumberFilters

Lecture 3: Date Filters

Lecture 4: Text Filters

Lecture 5: Filter by Colours

Lecture 6: Filter Using Special Characters

Lecture 7: Copy Paste

Lecture 8: Subtotal

Chapter 7: Sorting

Lecture 1: Overview of Sorting

Lecture 2: Multi Column Sort

Lecture 3: Sorting Exercise 1

Lecture 4: Multiple level Sorting

Lecture 5: Sorting By Colour

Lecture 6: Sorting Example 2- Reverse Sorting

Lecture 7: Sorting Example 3 – Inserting Rows

Lecture 8: Sort by Custom List

Lecture 9: Horizontal Sorting

Lecture 10: SORT and SORTN Function

Chapter 8: Basic Data Table

Lecture 1: Create Data Tables with Filter and Sort

Lecture 2: Rename and Resize

Lecture 3: Design Tab

Lecture 4: Table Style Option & Calculations

Lecture 5: Slicer

Lecture 6: Convert back to Range

Lecture 7: Linking files using data tables

Chapter 9: Cell Referencing

Lecture 1: Relative Referencing

Lecture 2: Absolute Referencing

Lecture 3: Mixed Referencing

Lecture 4: Example 1

Lecture 5: Example 2

Chapter 10: Functions1-Logical Functions and Related Formulas

Lecture 1: Logical or Comparison operators

Lecture 2: IF Function

Lecture 3: Nested IF Function

Lecture 4: AND-OR-NOT

Lecture 5: IF-AND

Lecture 6: IF-OR

Lecture 7: IF-NOT

Lecture 8: XOR

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 4 votes
  • 4 stars: 7 votes
  • 5 stars: 15 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

Google Shopping Ads Digital Marketing Course