Advanced Excel training

advanced excel training

This Excel 2013 advanced training course, follows up from the Beginners Excel 2013 course by delving even deeper into the features and functions of this powerful spreadsheet software. Microsoft Excel 2013 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Spark lines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros. This advanced Excel video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2013, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the faculty trains you with.

Course Content are as follows:

Spreadsheet basics

  • Creating,
  • editing,
  • saving
  • printing spreadsheets

Working with functions & formulae

  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Formatting worksheets , Securing & Protecting spreadsheets

Formulas & Macros Formulas:

  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas

DATA Analysis:

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Linking Between Word/Excel/Ppt
  • Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
  • What-if-analysis, GOAL SEEK
  • Absolute Cell References
  • Name Manager

Naming cells and ranges

  • Creating and defining names
  •  Making a name list
  •  Advanced technique of using names in formulas
  •  Using Name Manager
  •  Navigating spreadsheet with names

Excel Pivot Tables

  • Create an Excel Template
  • Data Forms in Excel 2007/2010
  • Drop Down Lists in Excel
  • Add your own Error Messages
  • Excel and Web Integration
  • Hyperlinks in Excel
  • Object Linking and Embedding

Database

  • The database components
  • Using Excel Form feature
  • Inputting data
  • Deleting data
  • Finding records
  • Using menu commands to find records

Advanced data sorting and subtotal

  • Multi-level sorting
  • Restoring data to original order after performing sorting
  • Sort by icons
  • Sort by colours
  • Multi-level subtotal

Managing documents with workbooks

Consolidation with several worksheets

  • Consolidating and combining several spreadsheets using the operation addition, subtraction
  • Synchronizing the consolidated table with the source data

Data table

  • One-Input table
  • Two-Input table

Lookup table

  • Lookup()
  • Vlookup()
  • Hlookup()
  • Application of exact match and approximate match
  • Creating an order form using vlookup function

Document protection

  • Files protection
  • Protecting cells/documents
  • Unprotecting documents

File linking

  • Paste link

Filter and advanced filter

  • Defining single and multiple criteria
  • Combining search criteria
  • Deleting criteria
  • Extracting records

Pivot table

  • Steps to create a pivot table
  • Creating pivot table from Excel
  • Consolidating data from multiple ranges into a pivot table

Conditional format

  • Highlighting data using cell colours, font colours
  • Highlighting data using icons

Data validation

  • Define the data input type
  • Define the warning message
  • Define the error message
  • Circle invalid data

Using Scenario Manager

  • Defining your own scenario
  • Preview the result of scenario
  • Editing a scenario

What-If Analysis

  •  How to apply What-If Analysis

Inserting a hyperlink to a workbook

  •  Creating a hyperlink
  •  Editing a hyperlink
  •  Creating a menu system using hyperlink

Creating a pull down box to facilitate the data entry process
Creating and using Macros

Click Here For Download PDF

 

Next VBA Training

Previous Microsoft Office Training

Web Design MymensinghPremium WordPress ThemesWeb Development

Christmas Celebration @ SouthEx

December 28, 2016December 28, 2016
ldh14 images cth3 christmas-party-2013 chd11 May your Christmas sparkle with moments of love, laughter, and goodwill. Warmest wishes for a happy holiday season and a wonderful new year.

English Workshop Free

September 20, 2016September 20, 2016
English Workshop FreeInteliGenes is organising a FREE workshop on SPOKEN ENGLISH. VOCABULARY WORKSHOP -Free English Grammar and Vocabulary Sessions and Exercises, Date: 22/09/2016 and 23/09/2016 Location :InteliGenes Tilak Nagar Branch Timing: 10am -12 am and 4pm -6pm Register yourself on Whatsapp or Call +91-8826571407 , 011-41040178 Limited Seats [caption id="attachment_1701" align="alignnone" ]english-workshop english-workshop[/caption]

Teachers Day Celebration

September 6, 2016September 6, 2016
teacher dayInteliGenes has come with teachers day special offers. Get up to 40% off various courses like IELTS , PTE , SQl Server , Japanese Language , Spoken English etc. for your friends under the InteliGenes Teachers Day Offer. Offer Valid till 10/09/2016. Teacher of the Month has been awarded to Anamika Rathore (IELTS Faculty (South Ex Branch)) who successfully teaches and placed 2000+ students till now. We are happy to have she as an asset to our organization since 2007 . radhikaplakkot

Most Successful Course of the Month

January 26, 2016January 26, 2016
adv excelWe are glad to announce that we have enrolled 40+ students for Data Analytics Profile course like Advance Excel , VBA (Macro Programming) Excel Automation , SQL Server and MIS Course. Because of rapidly increase demand in the market of Data Analytics and Reporting Software , more and more students are enrolling in our organization for the same and we are also enhancing our course modules depends upon the market standards so that student can avail placement o job opportunities from our institute .

Republic Day Wishes From Inteligenes

January 26, 2016
4-republic-day-wallpaper.previewInteliGenes Wishing you all a very HAPPY REPUBLIC DAY On this special day,lets promise our motherland that we will do everything to enrich and preserve our heritage our ethos and our treasure happy republic day. Justice ,Liberty, Equality , Fraternity May our dream of a new tomorrow come true for us

NDLM Project : Digital Education

January 20, 2016January 20, 2016
NDLMPrime Minister Shri Narendra Modi unleashes a 'digital revolution’ with the launch of the Scheme for IT Mass Literacy .The Scheme is an initiative of Department of Electronics & Information Technology (DeitY), Ministry of Electronics and Information Technology, Government of India. InteliGenes Technologies is the Training Partner of NDLM Scheme. We are glad to announce that we have enrolled 100+ students for the same and provided free education to students .

Independence Day

August 14, 2015August 14, 2015
Independence -DayThe greatest gifts you can give your children are the roots of responsibility and the wings of independence.We think the child who is able to earn her own living and pay her own way should be as happy as anybody on earth. The sense of independence and security is very sweet. We offer Placement Oriented Course for Students who just wanted to Decorate their Life and Career . Give your Life a New motive this INDEPENDENCE DAY.

Whatsapp Counseling For Students

August 4, 2015August 4, 2015
whatsapp counselling for studentsInteliGenes Whatsapp Counseling Sessions for students - A great content marketing tool Marketing to teenagers and young adults is changing at a rapid speed. With the advent of different media in the market, the ways in which brands communicate to their target audience has evolved. At InteliGenes, we have always believed in being cutting edge, innovative and updated with technology and solutions to give you the best value and service. Keeping this in mind, we would like to introduce to you our most successful content marketing product - "Whatsapp Counselling Sessions with InteliGenes" Contact our Whatsapp Number : 8826571407

Services Available Round the Clock

May 21, 2015May 21, 2015
Timing‬ ‪‎Extended‬ We are very happy and pleased to announce our extended services on special demands of our students and aspirants Now we have extended our Training and classes from 8 am to 9 pm.
We are pro founded by joy assisting you more.  

IELTS Success At InteliGenes

May 21, 2015
IELTSStudying‬ ‪#‎Abroad‬ Made a DownHill‬ By US 100% IELTS‬ Registered students cracked the Exam Providing you the best IELTS training we broaden your gateway for your‪ ‎career‬ ‪‎overseas‬ .
Join us with NO Time . ‪‎Registration‬ ‪‎Open‬ For students‬ who are willing for a lucky future across the ‪‎world‬. To know more... Contact us Mobile :+91-8826571407 ,+91-7042106662 Landline :011-41040178 Email :inteligeneit@gmail.com Website :www.inteligeneit@gmail.com

Monday Motivation at Inteligenes

April 28, 2015April 28, 2015
monday@InteliGenes‪#‎MondayMotivation‬ : Enroll in any Accounting Course or Advanced Excel Course at  Inteligenes Technologies. Get Flat 10% Off. Courses Detail are : ‪#‎Basic‬ ‪#‎Tally‬ ‪#‎ERP‬ 9 For 12 th ‪#‎Pass‬ out ‪#‎Student‬ ‪#‎Advanced‬ Tally ERP 9 : For Students who are looking for Job in‪#‎Financial‬ and ‪#‎Accounting‬ Course. ‪#‎EAccounting‬ : For ‪#‎CA‬ ‪#‎Job‬ ‪#‎Oriented‬ ‪#‎Training‬
Books , Assessment , Certificate Available.  

New and Improved Mode of Training

April 26, 2015April 26, 2015
free-online-coursesInteliGenes Technologies has innovates and improvised their mode of conduction according to the needs of Trainees or Candidates. Changes made in the mode of conduction are as follows :
  • Students can enroll for Regular classes
  • Students can enroll for Alternate classes
  • Students can enroll for Weekend Classes
  • Students can enroll for Corporate classes
  • Students can enroll for Online Classes
 
  • For more information , related to whats new at InteliGenes Technologies , Email us at inteligeneit@gmail.com or Call us at +91-8826571407
 

Wednesday with Adobe : Exclusive for Designing Students . Register Now

April 18, 2015April 18, 2015
Wednesday OfferInteliGenes Technologies is launching Exciting Wednesday . Students who wanna Build their Career in Designing such as
  • Diploma In Graphics Designing
  • Desktop Publishing
  • Certificate in Adobe Photoshop
  • Certificate in Corel Draw
  • Certificate in Adobe Illustrator
  • Certificate in Adobe Indesign .
  Get 30% Off this Summer 2015 before July 2015 . Design your Career Successfully in Graphics Designing.

InteliGenes beats all competition in Student Career

April 15, 2015April 15, 2015
LeadersInTrainingInteliGenes .com continues to be the leader in Guiding the Student from The First Milestone of their career to the placement . If you want to make your Career in Software Development / Website Designing / Website Development /Digital Marketing / Financial Accounting / Data Analytic and Reporting / Personality Grooming Sessions and Lots more... InteliGenes Technologies is your ultimate Destination . How do InteliGenes Technologies is beneficial for Students ?
  • All Days Open (Regular/ Alternate /Weekend) Batches
  • Individual/Group/Corporate and Online Classes
  • Online Notes/ Tips and Tricks, Study Material Available. Books, Certification/ Assessment and Mock Test Available
  • Latest Software Training
  • Expert  Team of Trainers.
  •  100% Job Assistance
   

Summer Bonanza : Enroll For One Course get 30% Off on Another Course

April 8, 2015April 8, 2015
summer bonusWelcome Summer with Cool Courses. Summer Special : Enroll For One Get 30 % off on Another Course Valid Course For This Offer: Graphics Designing E Accounting Diploma in DotNet Microsoft Office 2013 MIS Coupon Code :IGT407 Valid Date : 30/04/2015 For more information , Contact Contact :011-41040178 ,+91-8826571407 Email :inteligeneit@gmail.com , info@inteligenes.com Website : www.inteligenes.com

Join Our Blog |Get Updates On Various Technologies

April 7, 2015April 7, 2015
blogInteligenes Technologies has launched a BLOG with a name http://ultimatelearninghub.blogspot.in/ where you can Learn , Explore , Innovate and Expertise yourself in Various Domain of IT and NON and IT world. We will post Tips and Tricks for Most Demanded Courses like Advance Excel 2013 , VBA , MIS , Software Development , Website Designing , Website Development , English Speaking and IELTS etc.   Kindly Join Blog to Get Updates on Various Courses absolutely Free. We always welcome you

Upto 50% Off : Easter Day Week

March 27, 2015March 27, 2015
Easter at InteligenesInteliGenes Technologies offering good discount on IT and NON -IT Courses from 01/04/2015 - 11/04/2015 . Students who wanna grow their career in IT Domain like Data Analytics , MIS Executive , Software Developer , Website Designer , Website Developer , Data Entry Operator , Computer Operator , Aviation Industry , Graphics Designer  and many Other Profile , Contact US . Placement Opportunities head away . Join the Trail of Courses this Year and get placed in TOP MNCs and Banking Sector.

Scholarship for 12th and 10th Students

March 24, 2015March 24, 2015
scholarshipInteliGenes Technologies is announcing scholarship for students who secured more than 85% in their Board Exam. Get 3 Year Degree course IGTDIT (Industry Oriented Course ) with 35% Discount at InteliGenes. Grab the Offer Before It gets Too Late . Join Diploma is Finacial Sector (IGDFM) or Diploma in Software Development (IGDSD) or Diploma in Designing (IGDGW)

Join Republic Bonus Trail at InteliGenes Technologies

January 24, 2015January 24, 2015
Republic Day @ InteliGenesDear all, Join InteliGenes Technologies on 23rd to 26 th of January 2015 and Get upto 30%  discount on the following courses:
  • Tally ERP 9
  • MS Office 2013
  • Advanced Excel
  • VBA
  • MIS
  • Graphics Designing
  • Spoken English and Personality Development
Give your career new wings this Republic Day.  

New Batches Started

December 10, 2014December 10, 2014
admissionNew Batch of Following Course are going to start:
Name of the Course
Days
Timings
Advanced Excel 2013
Sat - Sun (Weekend Batch)
10am-12am
Advanced Excel 2013
Sat - Sun (Weekend Batch)
10am-12am
MIS
Sat - Sun (Weekend Batch)
10am-12am
Tally ERP 9 (E-Accounting)
Mon-wed-fri(Alernate Batch)
4pm-6pm
Tally ERP 9 (E-Accounting)
Mon-wed-fri(Alternate Batch)
5pm-6:30pm
Photoshop CS6 (Graphics Designing)
Mon- Wed -Fri(Alternate Batch)
10am-12am
Software Development (Dotnet)
Mon-wed-fri(Alernate Batch)
10am-12pm
Spoken English and Personality Development
Tue-Thrus-Sat(Alternate Batch)
10am-12am
Spoken English and Personality Development
Mon-Tues-Wed-Thrus-Sat
11am-12am
IELTS
Mon-Wed-Sat
10am-11am
PTE(For Australia VISA )
Mon-Tues-Wed-
2pm-4pm
Spoken English and Personality Development
Mon-Tues-Wed-
11am-12am
VBA(Macro Programming)
Mon-tues-Wed-Thrus-Fri (Regular)
10am-11am
C Language,C++ Language & Data Structure
Mon-Wed-Fri
2pm-4pm