Business Data Analysis using Advanced Excel - Weekend and Weekday
ID: 69900

Business Data Analysis using Advanced Excel - Weekend and Weekday

Online Event
Type Price Quantity

Course Fees

INR 3540
Registration Closes : 9m 19d 7h
Your Order
Total 0
Discount (coupon code discount) 0
Have a Discount Code?
Coupon code applied:  clear
Amount Payable 0

Offers & Discounts

15% up to Rs 200 Supercash

Business Data Analysis Using Advanced Excel - Weekend And Weekday

Overview

Call Barin@9051092035 or Shrabana @ 8420594969

Course Outline:

  1. Fill, Conditional Formatting, Advanced Sorting & Filter
  2. Formulas – Writing & Fixing Errors
  3. Working with Data
  4. Creating and Working with Charts
  5. Data Analysis & Pivot Tables
  6. Review & Security
Working with Data Formula Writing &   Fixing Errors
  • Formatting   & Layout
  • Putting   Headers and Footers, logos on Excel
  • Print   Layout
  • Conditional   Formatting
  • Fill   feature
  • Sorting (number. alphabets, color, date, custom)
  • Filter, Advanced Filter
  • Text to column: Importing .txt files / CSV   into excel (Bhav Copy)
  • Data Validation (List, Error Message)
  • Grouping and Sub-grouping
  • Subtotal
  • What if Analysis (Goal Seek, Scenario)
  • Solver (addin)
  • Financial: Time Value of Money (PV, FV, nper, rate, PMT) + IRR, NPV
  • Look up: Vlookup, Hlookup
  • Math: Sum, Sumproduct, Absolute, Integer,   Round, Average, Count, Minimum, Maximum
  • Logical: IF, nested if, sumif, Count, CountIf, CountBlank,   iferror and, or,
  • Text: Case, Position, Search, Trim, Right, Left,   Concatenate
  • Date & Time: Day and Time, Representation of Date   in Excel, Conversion, Today, Day
  • Others: Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower,   Upper, Proper, Now, Power Precedents, Dependents, Error Checking
  • Evaluation of Formula – Stepwise
  • Formula hiding 
Data Presentation using   ChartsData Summarization 
  • Charts (Bar, Column, Line, Pie, Area, 3d
  • Multi-dimension   Axis
  • Moving   & Copying Charts
  • Pivot Table 
  • Pivot Chart
Review and Security Advanced   ExcelMiscellaneous
  • Password Protection
  • Cells Lock
  • Making excel as a form
  • Track Changes 
  • Sharing of excel (Collaboration)
  • Freeze panes
  • Auto Sum on the Task-bar
  • Usage of Top Ribbon Menu
  • Printing Multiple Sheets 
  • Recording macros
other website (tickets, registration, more...)
www.paliumskills.com Click Here
Added By
Palium Skills offers professional training to individuals, corporates and institutes. It conducts courses at its own learning centers or at customer designated locations Read more
Need help?   Call  Support: +91-9555601111
How to use Tickets
  • Once you buy the tickets, your name will be added on the guest list with the event organizer
  • On reaching the venue verify your ‘e-ticket’ with the event organizer
  • And you are good to Enjoy the event!
Benefits of buying from Goeventz
  • Trusted by thousands of event organizers and lakhs of customers
  • 100% Secure payments using industry standard encryption
  • Govt of India Certified Startup
Customer Questions & Answers
Upcoming events from Palium Skills
Loading
Have a Discount Code?
Coupon code applied  clear
Amount Payable
0(including all taxes)
Have a question?