Advanced Excel

Get the basic knowledge of computers

Advanced Excel

Category:
Literacy Courses/
₹0.00
excel_classes_excel_vlookup_excel_macros_course_advanced_excel_classes_vesu_citylight_surat

₹0.00

Duration: 1 Month
Course Fee: 3500*/-
Lectures: 30
Certificate of Completion
Learn online through app
Download Curriculum

CURRICULUM

Module 1

   Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets and
   Difference between Excel 2003, 2007, 2010 and 2013
   Saving Excel File as PDF, CSV and Older versions
   Using Excel Shortcuts with Full List of Shortcuts
   Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
   Using Paste Special Options
   Formatting Cells, Rows, Columns and Sheets
   Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
   Page Layout and Printer Properties
   Inserting Pictures and other objects in Worksheets
   Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc
   Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
   Database Functions
   Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc
   Information Functions :
   Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc
   Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc
   Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc
   And More
   Using Conditional Formatting
   Using Conditional Formatting with Multiple Cell Rules
   Using Color Scales and Icon Sets in Conditional Formatting
   Creating New Rules and Managing Existing Rules
   Sorting Data A-Z and Z-A
   Using Filters to Sort Data
   Advance Filtering Options
   Creating Pivot Tables
   Using Pivot Table Options
   Changing and Updating Data Range
   Formatting Pivot Table and Making Dynamic Pivot Tables
   Creating Pivot Charts
   Types of Pivot Charts and Their Usage
   Formatting Pivot Charts and Making Dynamic Pivot Charts
   Advanced Filtering
   Data validation
   Consolidation
   Groups
   Subtotal
   What is Excel Macro ?
   How to Record / Run Excel Macro ?
   How Add Developer’s Tab in Excel 2007 / 2010
   How to add different types of controls like Text Box, Radio button, button etc. in Excel

Module 2

   Visual Basic Editor in Excel
   VBA Control Property
   How to write Excel Macro – Your First Excel Macro
   Excel Macro Tutorial : Excel User Form
   VBA Spin Button
   Toggle Button in Excel
   ComboBox / Drop Down List In Excel
   ListBox In Excel
   How to Open Excel Workbook using Excel Macro
   Using RANGE Object in Excel Macro
   What is difference between CELLS() and RANGE()
   Excel Macros, Excel Terms, Macro comments
   Userforms
   Variables in Excel VBA
   Implicit and Explicit declaration of variables in Excel Macro
   Important : Declaring multiple Variables with one Dim Statement
   For Next Loop in Excel Macro
   While Loop and Do While Loop in Excel VBA
   VBA Programming : If Then Statements / If else Statements
   VBA Programming : Decision – Select Case in Excel VBA
   Variables in Excel VBA
   Implicit and Explicit declaration of variables in Excel Macro
   Important : Declaring multiple Variables with one Dim Statement
   For Next Loop in Excel Macro
   While Loop and Do While Loop in Excel VBA
   VBA Programming : If Then Statements / If else Statements
   VBA Programming : Decision – Select Case in Excel VBA
   Events, Error Handling
   Excel Objects, Programming Charts
   Message box, Input box
   Introduction to SQL
   Creating New Tables
   SQL SELECT Statements
   Manipulating Data(Insert, Delete, Update)
   Distinct, Order By, Join clauses and Aggregate Functions
   Using Primary keys, Foreign keys
   Get Data from Multiple Tables
   Using DDL Statements
   Restricting and Sorting Data
   Using Single-row Functions
   Conversion Functions
   Conditional Expressions
   Using the Group Functions
   Subqueries to solve queries



Course Description

Why Take excel Course?

  • Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the excel programme with ease and confidence at work and become known as an expert excel user? Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using excel formulas, excel vlookup, excel macros creating impressive graphs and charts like a pro, plus much more.
  • Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, excel vlookup, graphing tools, pivot tables, and a excel macros programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced.
  • Microsoft Excel is the most wide-spread computer software for cell-based spreadsheets, used in virtually all larger companies and organizations around the world. Excel schooling will teach you calculations, formulas, analysis, macros, diagrams, graphs, charts and tables. Below you will find a list of some of the advantages of participtaing in Excel classes and VBA macro programming training.

advanced_excel_advanced_excel_course_excel_training_excel_vba_course_in_vesu_citylight_surat

Why Excel Matters:

We all know Excel training is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.You will have more value to employers Protects a significant amount of Time Increase your Knowledge and Management Skills Better Salary Aspects And Many More…

What are you going to get from this advanced Excel data analysis course?

  1. Learn about the structure of Excel
  2. Learn how to adjust the way data and information are displayed in Excel
  3. Learn how to apply excel formulas with function facts.
  4. Learn how to use relative, absolute, and mixed references in Excel
  5. Learn how to create powerful calculations with Excel functions
  6. Learn how to visually represent your data with charts and other tools in Excel
  7. Learn how to use Excel data tools like excel vlookup, excel macros, excel vba, Group, subtotaling, and filtering
  8. Learn how to remove duplicates from data in Excel
  9. Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
  10. Learn how to automate Excel tasks with recording Macros.
  11. Learn how to use printing and sharing in Excel
  12. Learn to use excel Pivot table with slicers, Grouping and various tricks
  13. Learn how to organise your data based on Condition.
  14. Learn to validate proper entry in the data.
  15. Mastering Date and time related formulas and format.
  16. Mastering all important Text function with nested methodology
  17. Mastering excel Logical and excel Lookup and excel reference Function.
  18. Mastering Operators use and Math Functions.
  19. Create sophisticated outputs for financial analysis, including beautiful tables, charts, and graphs
  20. And Many More…

excel_data_analysis_excel_course_excel_academy_excel_classes_courses_vesu_surat

Master shortcuts, functions and formulas that save time and increase productivity

  • Combine excel formulas functions into useful excel  formulas and use in calculations
  • Cut hours of labour by using Pivot tables to do excel data analysis – also reduces or eliminates the need to type in formulas
  • Discover new tools to share your work
  • Find new and more efficient ways for excel data analysis
  • Save minutes every day by using short-cut keys

Learn how to produce professional-looking charts and diagrams for reports, presentations and printouts

  • Learn the tricks to produce professional charts and graphs
  • Add colour and images to improve readability and get messages across to the audience more effectively
  • Go from raw data to model to presentation with professional charts literally within minutes
  • Include diagrams in marketing reports and sales presentations to boost sales and readability
  • Find new ways to visualize data

Shorten workdays using recorded and programmed excel macros

  • Reduce workload each month by automating repetitive tasks by using excel macros
  • Learn how to record your actions in Excel and replay them automatically
  • Significantly reduces time spent on repetitive work tasks
  • Macros can also be used to add new functions to Excel

Understand the work of colleagues and Excel solutions found on the Internet

  • Decipher complex Excel models produced by current or former colleagues
  • Being at the same knowledge level makes it easier to communicate ideas with colleagues
  • Reduce the number of dangerous and costly Excel model errors
  • Find and correct calculation mistakes using excel data validation

Career Scope of Advanced Excel:

  • Data Analyst Metrics and Analytics Specialist
  • MIS Executive
  • Financial Analyst
  • Market Research Analyst
  • Big Data Engineer
  • Big Data Analytics
  • Big Data Solution Architect
  • and more Career in MIS Want to have expertise in Excel and data management

excel_google_excel_macros_ms_excel_excel-tutorial_future_vision_computers_citylight_surat

macros_with_excel_vba_excel_excel_vlookup_excel_formulas_future_vision_citylight_vesu_surat

Videos

Learn Advance Excel & Data Analysis

Salary Sheet | Attendance Sheet| Charts | Graphs | Pie Charts, Bar Graphs, Line Charts (Session-4)

Data Validation in Excel | Data List | Data Filtering & Sorting | Advance Filters

Sales Sheet, Conditional Formatting, Data Analysis, Data Labels, Sorting, Filtering

Purchase Sheet, Data Formatting, Number Formats, Data Presentation in excel