chennai
Date
  • weekwid: false
  • widHeader: false
  • orgName: infoctrlaihub@gmail.com
  • orwid: false
https://www.eventshigh.com/detail/chennai/a64dc27cf24f726aad4f55958d39e77c-workshop-on-advanced-excel-with

Workshop on Advanced Excel - With Ms.Vasanthi B

0.0,0.0
Sun, 22 Dec 2019 11:00AM - 5:00PM
CtrlAiHub
Rs 500
77 people viewed this event.
We’re currently not serving due to Covid-19. Sorry for the inconvenience!
I Am Interested

Get notified when the event happens next time.

Details

Details

 

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. 

TOPICS INCLUDED:

BASIC Microsoft Excel :

  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae 
  • Graphically representing data: Charts & Graphs
  • Analyzing data: Data Menu, Subtotal, Filtering Data
  • Working with functions & formulae 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
  • Sheet Referencing
  • Linking Between Word/Excel/Powerpoint

Functions: LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF

  • What-if-analysis
  • GOAL SEEK
  • NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation

PIVOT TABLES :

  • Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Analyze Data Columns in Pivot Tables
  • Adjust Data to Analyze

MACROS :

  • Macros
  • Definition and use, Record a macro
  • Assign a macro, Run a macro
  • Store a macro, Introduction to VBA Prog.

Develop the Worksheet :

  • Plan a worksheet, Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars, Enhance worksheet Appearance

Special Operations :

  • Use multiple windows: Copy/ paste between Worksheets
  • Link worksheets, Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat: Create, use and modify styles and templates
  • Print features: Create /edit an outline
  • Graphic Operations:
  • Create charts, Enhance charts, Drawing toolbar features

The certificate will be issued.

Snacks will be issued.

Please bring your laptop.

Login to View Organizer Details
Like this event ? Share it with your friends !!
Show

Map & Directions

Map & Directions
CtrlAiHub No 13 D 4/1, 17 th cross street, Varadharajapuram, Tansi Nagar, Velachery, Chennai, Tamil Nadu 600042, India
Organizer Reviews 4.1 (14)
Reviews for Organizer 4.1
Show

Frequently Asked Questions

FAQs
Have any query? Drop your questions here !!
Show
  
EventsHigh Specials, microsoft, financial analysis, data validation, special operations, toolbar, editing, data analysis, reporting, spreadsheet, classes and workshops, tech workshops,