NAS Solutions provides high quality computer education at a very high standard at a very low cost.
Our mission is to create a pool of high quality software professionals who will meet the demanding needs of multinational organizations for tomorrow’s challenges.
We believe that training in the latest computer technologies combined with life-long learning are the essential ingredients for building a successful career in the IT Industry. Students are trained in a multi-cultural atmosphere providing student-centered interactive learning which is centered on today’s computerized business environment.
NAS emphasis is given to the maximum extent on the projects by maximum practical learning through simulated projects designed to the needs of the industry. “Practice makes a man perfect”.
Classes are scheduled for Monday to Saturday between 10-07. Special Fast Track and Weekend batches are also available.
Microsoft Office Specialist
Microsoft Office Cetification gives you the tools to build a bright future.
- Gain valuable Microsoft Office computing skills
- Achieve industry-recognized certiication
- Assure employers of your qualiications
- Boost your workforce resume
- Differentiate yourself from other applicants
- Advance your career
Advanced Excel Training Course Content
1 Pivots and Pivot Graphs:
- Creating of Pivot Table
- Using Summary function in Pivot Table
- Pivot Table Calculations
- Creating own formulas in Pivots
- Grouping and Ungrouping in Pivot Tables
- Creating Pivot Graph
- Custom Filter on Pivot Table
- Formatting Pivot table (Removing old data, grand total, subtotal …etc.)
2 Working on Objects:
- Inserting Objects
- Inserting different files into Excel (like .doc, .pdf, .txt files)
- Hyper linking to different sheets
- Providing screen tips in hyper link
- Hyperlink to send emails
- Inserting symbols
- Sending working file to an email
3 Data Management in Excel - Sorting:
- Rearranging of Data
- Sorting by alphabets, numbers and time
Filtering Data:
- Using Auto filter option
- Custom Filtering with different options
- Advanced Filtering
- Find Unique records using advanced filtering
- Filter using operators AND/OR
- Filter by color
Grouping and Outlining Data
- Group and ungroup rows and columns
- Auto outlining the data
- Freezing and Unfreezing
Data Validation:
- Use Data Validation in Excel
- Using Input Message in Data validation
- Using error message in Data Validation
Removing duplicate records:
- Remove duplicate records in a spread sheet
- Customize to remove the duplicate values
Split Texts:
- Split texts to different columns
- Remove special character from a string and split the string
Data Consolidation:
- Combining different spreadsheet using data consolidation
- Using summary function in data consolidation
Conditional Formatting:
- Use of conditional formatting
- Custom formatting
Copy Data:
- Use of format painter
- Use of paste special
- Strike through a value
- Find and Replace
View Multiple Files:
- Arrange multiple windows to view in one time
- Split big sheet into sub sheets for better analysis
Working on Tab:
- Hide/ Unhide a tab
- Color a tab
- Move /Copy the tab to another sheet/workbook
4 Advanced Functions:
- V-Lookup
- H-Lookup
- IF
- ISERROR
- Index Match
- Rows
- Columns
- Match
- Offset
- Get Pivot Data
- Date and Time Functions
- Text Functions
- Operators
- Mathematical functions
- Calculation options
Name Manager:
- Define a name to a range
- Use of name manager
- Using formulas in name manager
- Editing name range
5 Data Connection from External Data:
- From access
- From SQL
- From Web
- From ODBC
6 Customize your Excel view:
- Customize Excel view
- Developer Option
- Trust Centre
- Add-Ins
- Save directory options
- Language Setting
- Quick access toolbar
7 Security options in excel:
- Protecting the worksheet
- Protecting the workbooks
- Sharing the workbook
- Allow users to edit ranges
ADVANCED FUNCTIONS
- Logical (ANd, IF, Or)
- Text ( Clean, Concatenate, Exact, Len, Lower, Proper, Replace, Substitute, Trim, Upper)
- Date & Time(Now, Today)
- Lookup & Reference (Vlookup, Hlookup, Transpose, Rows, Columns)
- Math &Trig(Ceiling, Even Odd, Fact, Floor, Gcd, Int, Lcm, Mod, Product, Sum,Quotient, Roman, Round etc.
Become an Expert and learn to use Excel like a professional with our Advanced Excel Training.
BENEFITS OF JOININGUS
- Real Time Trainers
- Complete Placement Assistance
- Small Training Batch
- Flexible Timings
- Practical Guidance
- Excellent Lab Facility
- Resume Preparation
- Hands on Experience
- Certification Support
For more Details Visit our website:-
https://nassolutions.in/services/professional-training/advanced-excel-training/
Contact:- 9919999638, 8188800505
NAS SOLUTIONS
D-307,Vibhuti Khand,Gomti Nagar
Lucknow-226010(UP)
Landmark:- Opposite Urdu Academy, Near Madhurima Hotel
