BASIC EXCEL

BASIC EXCEL

Training Mode Regular Fasttrack Crash Brochure
Classroom | Online 15 10 5 Download

WHO CAN JOIN BASIC EXCEL COURSE

  • 10th, 12th or Equivalent
  • BCA/MCA, B.Tech, M.Tech, B.sc (IT), B.sc(CS)
  • Diploma Candidates

MS. EXCEL PROCESSING SYSTEM

  • Opening Excel Processing System
  • Title Bar , Menu Bar ,Work Sheet
  • Open New File , Open Save File , Save As ,Print, Prepare ,Send

Home

  • Clipboard :- Cut, Copy ,Paste And Format Painter
  • Font:- Font Family, Font Size, Bold, Italic, Underline, Border, Text Highlight, Font Color
  • Alignment :- Align (Top, Middle ,Bottom), Align Text ( Right, Left, Center), Decrease And Increase Indent, Wrap Text, Merge & Center
  • Number :- Number Format, Accounting, Number Format, Percent Style, Comma Style, Increase Decimal, Decrease Decimal
  • Style & Editing:- Conditional Formatting, Format as Table, Cell Style
  • Cell:- Insert Cell, Delete Cell, Format
  • Editing :- AutoSum, Fill, Clear, Short & Filter, Find & Select

Insert

  • Table:- Pivot Table, Table
  • Illustration :-Picture, Clip Art, Shapes, Smart Art
  • Chart :- Column, Line, Pie, Bar, Area, Scatter, Other
  • Links :- Hyperlink
  • Text :Text Box, Header & Footer, Word Art, Signature Line, Symbol

Page Layout

  • Themes :-Themes, Colors, Font, Effects
  • Page Setup :-Margins, Orientation, Size, Print Area, Breaks, Background, Print Title
  • Scale to Fit :- Width, Height, Scale
  • Sheet Options :- Gridlines, Heading
  • Arrange :- Bring to front, Send to Back, Selection Pane, Align, Group, Rotate

Formula

  • Function Library :- Insert Function, AutoSum, Recently Used
  • Sheet :- Mark Sheet, Attendance Sheet, Sale &Purchase Sheet, Loss & Profit Sheet, Stock Inventory, Salary Sheet, Hospital Sheet, Bank Sheet
  • Defined Name :-Defined Name, Use In Formula
  • Formula Auditing :- Trace Precedence & Dependence, Remove Arrow, Evaluate Formula, Watch Window
  • Calculation :- Calculation Options, Calculate Now & Sheet

Data

  • Get External Data :- From Access, From Web, From Text, From Other Sources, Exiting Connections
  • Connections :- Refresh All Connection Properties, Edit Links
  • Short & Filter :- Filter, Clear, Reapply, Advance Filter
  • Data Tool :- Text To Columns, Remove Duplicate, Data Validation, Consolidate, What-If Analysis
  • Outline :- Group, Ungroup, Subtotal, Show & Hide Details

Review

  • Proofing :- Spelling & Grammar, Research, Thesaurus, Translate, Word Count
  • Comments :- New Comment, Delete
  • Changes :- Protect Sheet , Protect Workbook, Share Workbook, Protect and share Workbook, Allow Users to Edit Ranges, Track Changes

View

  • Workbook Views :- Normal, Page Layout, Show / Hide
  • Zoom :- Zoom, Zoom to Selection
  • Window :- New Window, Arrange All, Freeze Panes, Split, Save Workspace, Switch Window
  • Macros

 

Career Options:

  • Excel Expert
  • Data Entry Expert
  • Front End Executive

CONTACT US

Course Feedback

View More Testimonials

Student Projects

KEY FEATURES OF COURSES

Our team welcome, all our trainees to take free of cost class up to 1 year * after training., if they want to improve their skills or if they feel gap in their knowledge.
If you are facing any type of problem with class, we insure you to give refund ! We always takes a feedback with our trainees after classes. Further they don't love our classes after 3 or 5 , we will try to resolve it other wise we refund less amount.
Our team always committed to your success, so our institute offers students to pay their fees installment in monthly basis, rather than full amount*.
Equipped with more than 5+ years of industry experience our instructors will assure a successful leap in your knowledge, improvement and preparation. Know about our Instructors.
Our team always committed to your success, so our institute offers students to pay their fees installment in monthly basis, rather than full amount*.
Students at Next-G Education can do maximum practice in lab as they wish with proper internet connection. Our Lab Instructors helps during practice. Students can frequently ask any doubt if they are facing issue during practice session.
At Next-G Education,we make sure for PG or Lodge or Room in very low cost. We always care our students which are coming from different location either they are from India or Outside India. So if your are interested to join our course and looking for Room or PG we definitely provide you in affordable cost. You can also share your arrival details with us in advance for proper adjustment ion few days.
We offers assured job placement to our candidates opting for our all courses. As Next-G Education, associated partner of Web services, Info web tech, Global Sites Solution. You are invited to do paid internship with us after completion of course or our associated placement departments team provides job for you...
Are you interested to book free demo classes or looking for free counselling give us call on 783837033, 7683072463 or mail us on : [email protected] or [email protected]