Excel Certificate Training - Weekendr Bootcamps

Basic Details

When: 19th August 2017 to 9th September 2017 (Weekend Batch, 7 Training Sessions, 3 hours each)

Where: 1st Floor, 2230, Outram Lines, Delhi (Above Vijaya Bank, 5 mins walk from Exit-2 GTB Metro Station, Yellow Line)

Timings: 10 am to 1 pm

Fee: Rs 5,500, 10% Group discount for a group of 3 or more

Support and Assessment: 2 mandatory internal assessments

Who should attend: Excel forms the heart of any Industry, across all verticals and hierarchies. Hence the need to learn Excel is of paramount importance for freshers and experienced folks alike. After doing 20 successful Advanced Excel Trainings, Weekendr is back with a refined and more exhaustive version of Excel Learning which includes VBA, Macros and a lot more.

Course Material: Ebooks, PPT's, Handouts and Practice datasets included for a sound practical learning experience.

Faculty profile: To be announced

Course details :

SECTION 1: GETTING STARTED

  • Basic mathematics in excel
  • 1.2 Basic Excel Features: Auto Sum, Auto Fill, Series Fill, Flash Fill, Wrap Text, Merge And Center, Number Formatting, Increase And Decrease Decimal, Inserting Pictures, Shapes, Cliparts, Smartart, Hyperlinks, Wordart & Textbox, Inserting Headers & Footers, Inserting Symbols, Inserting Signature Line, Margin Setting, Changing Page Orientation, Password Protecting The Workbooks

SECTION 2: EXCEL FORMULAS & FUNCTIONS

  • Working with Formulas and Functions, Reference Styles: Relative, Absolute & Mixed
  • FINANCIAL FUNCTIONS: DB, SLN, PMT, PPMT, IPMT, CUMIPMT, CUMPRINC
  • MATHEMATICAL FUNCTIONS: ABS, EXP, LN, LOG, RANBETWEEN, ROUND, SQRT, SUM, SUMIF, SUMIFS, PRODUCT, TRUNC, SUMSQ
  • STATISTICAL FUNCTIONS: AVERAGE, CORREL, COUNT, COUNTA, COUNTBLANK, COUNTIF, DEVSQ, FREQUENCY, INTERCEPT, SLOPE, MAX, MIN, KURT, SKEW, STDEV
  • LOGICAL FUNCTIONS: AND, OR, NOT (COMBINING IF WITH AND, OR, NOT)
  • CONDITIONAL FUNCTIONS: IF (ADVANCED IF, NESTED IFS)
  • TIME FUNCTIONS: DATE, DATEVALUE, DAY, DAYS360, EDATE, EOMONTH, HOUR, MINUTE, MONTH, NETWORKDAYS, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR, YEARFRAC
  • MOST USED FUNCTIONS: VLOOKUP, HLOOKUP, OFFSET
  • How to combine formulas and use them in the real world
  • Hands-On Experience – Creating: Loan Repayment Worksheets, Payroll Statements, Bank Reconciliation Statements, Frequency Distribution & calculation of Statistical Parameters, Linear Regression Analysis, Creating Depreciation Schedules
  • TEXT Functions (LEN, CONCATENATE)
  • INDEX and Match Function

SECTION 3: CHARTS

  • Introduction to Charts
  • Learning Different types of Charts: Line Graphs, Pie Charts, Histograms & Bar Diagrams, XY-Scatter Diagrams, XY-Line Graphs

SECTION 4: PIVOT TABLES & PIVOT CHARTS

  • PIVOT TABLES
  • PIVOT CHARTS

SECTION 5: ADVANCED EXCEL ANALYTICAL TOOLS

  • SORTING, FILTERING - AUTO FILTERS & ADVANCED FILTERS, CONDITIONAL FORMATTING, DATA PARSING
  • REMOVING DUPLICATES, CONSOLIDATING DATA, DATA VALIDATION: Creating & Managing Drop-Down Lists, GROUP, UNGROUP & SUB-TOTAL
  • WHAT-IF ANALYSIS - GOAL-SEEK ANALYSIS, SCENARIO MANAGER, DATA TABLE
  • SOLVER: for Linear Programming Problems
  • DASHBOARDS & DYNAMIC DASHBOARDS - Introduction to Dashboards, Introduction to Slicers, Interactive Dashboards with slicers, pivot tables & pivot charts, Data Visualization, Hands-On Experience: Creating – Call Center Dashboard & Executive Dashboards
  • DYNAMIC NAMED RANGES
  • FETCHING REAL TIME DATA FROM WEB TO EXCEL - Hands-On Experience: Fetching Real-Time Data from Websites and learning to update the Real Time

SECTION 6: DATA ANALYSIS TOOLPAK: ANALYTICS

  • Descriptive Statistics
  • Correlation
  • Regression
  • Covariance

SECTION 7: VBA & EXCEL MACROS

  • Introduction to VBA & Excel Macros
  • VBE in Excel
  • Developing Macros in the VBE
  • Testing Macros in the VBE
  • Excel Macro Recorder
  • VBA Events
  • VBA Coding Tips
  • Dealing with errors
  • Hands-On Experience: Creating – Budget-Expenses Calculator using Excel VBA & Macros

Click to register How to pay ?



Excel is back at Weekendr in an all new enhanced format with VBA, Macros and a lot of application oriented hands-on modules. Register today! In over 50+ Analytics (SAS, SPSS, Excel, SQL & R) engagements conducted so far in last 12 months, we have had over 1000+ participants from some of the most prominent colleges and courses from Delhi University (DSE,SRCC, Stephen's, DRC, SSCBS, Miranda, Dept. of OR, Stats and many more), JNU, Jamia, Ambedkar University, IIT Delhi etc. and working professionals from companies like American Express, RMS, Mercer Consulting, WNS, Koncept Analytics, KBR and many more with an average rating of 9/10 across all our engagements.

Click to register How to pay ?