Advanced Excel

by H&B Computer Education Claim Listing

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

H&B Computer Education Logo

img Duration

Please Enquire

Course Details

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.

 

Course Lessons:

  • Microsoft Excel Course Introduction
  • Microsoft Excel Fundamental
  • Entering and Editing Text and Formulas
  • Working with basic Excel Function
  • Modifying an Excel Worksheet
  • Formatting Data in an Excel Worksheet
  • Inserting Images and Shapes into an Excel Worksheet
  • Creating Basic Charts in Excel
  • Printing Excel Worksheet
  • Working with Excel Templates
  • Working with an excel list
  • Excel List Function
  • Excel Data Validation
  • Importing and exporting Data
  • Excel PivotTables
  • Working with excel's powerpivot tools
  • Working with Large sets of excel Data
  • Working with excel's conditional functions
  • Working with excel's Lookup functions
  • Working with excel's taxt based functions
  • Auditing an excel worksheet
  • Protecting excel worksheet and workbooks
  • Mastering excel's "what if?" tools
  • Automating repetitve taska in excel with macros
  • Microsoft excel macros and VBA course introduction
    • Project 1: using excel's Macro recorder tools
  •  Excel VBA concepts
  • Working with excel VBA logic statements
    • Project 2 : Moving beyond the basics and into VBA
    • Project 3 : preparing and cleaning up data with excel VBA
    • Project 4 : using VBA to Automate excel formulas
    • Project 5: Bringing it All together and a weekly report
    • Project 6: working with excel VBA user forms
    • Project 7: Importing Data from taxt files
  • Gandhinagar Branch

    302 , Kailash Sagar Complex ,Above SBI Bank,Nr.GH-5 Cricle, Gandhinagar
  • Anand Branch

    Shiv Complex, 3rd floor, Mota Bazaar Rd, Anand

Check out more MS Excel courses in India

Vedanta Computer Training Institute Logo

MS PowerPoint

MS PowerPoint course is offered by Vedanta Computer Training Institute. We have a team of highly experienced trainers for computer classes in Patna that are expert in the field of providing quality education in various courses of the computer.

by Vedanta Computer Training Institute [Claim Listing ]
CMIT Computer Education Logo

Diploma In Microsoft Office

Diploma in Microsoft Office course is offered by CMIT COmputer Education for all skill level. Our core strength is our team of Expert Trainers / Faculties / Instructors consisting of MCAs/ Engineers / Graduate’s in Computer Science having strong domain knowledge.

by CMIT Computer Education [Claim Listing ]
Parjain Infotech Logo

Office 365

This course focuses on skills required for IT Professionals who take part in evaluating, planning, deploying Office 365 services and set up an Office 365 tenant including its identities, dependencies, requirements and supporting technologies.

by Parjain Infotech [Claim Listing ]
ICS India Group of Institutions Logo

MS Access

MS Access course is offered by ICS India Group Of Institutions. The goal of ICS Group of Institutions is to mould the student in the right way as they can analyze themselves and explore the hidden talents and helps the existing talents improved.

by ICS India Group of Institutions [Claim Listing ]
SIAT (Smart Institute Of Advanced Technology) Logo

MS Access

MS Access course is offered by SIAT (Smart Institute Of Advanced Technology). 'SIAT' here plays the vital role of such a knowledge center. 'SIAT' is place where detailed training and skill development Courses are provided in IT, NON IT, and Automation fields.

by SIAT (Smart Institute Of Advanced Technology) [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy