Adv_excel_Anilcomputers

Learn Advanced Excel from Anil Computers. Best Computer Institute in Udaipur, Rajasthan, India.

adv_Excel_Anilcomputers

Advanced Microsoft Excel

Microsoft  Basic Excel

Introduction of ms excel
Auto Fill
Insert row and column
Change row height and column
Delete row and column
Hide and unhide row and column
Merge and center
Wrap text
Sheet option
Arrange window
Use cut, copy and paste
How to use Format painter
Excel font: changing font, font style, bold,italic, and underline
Text Alignment
How to use Undo and Redo option
Custom sort part 1
Spelling and Grammar
Protect cell
Protect sheet
Comment
Advance printing method
How to insert Water mark
Hyperlink
Remove page break
Grouping Column
Bullet marks
Custom sort part 2
Header and Footer
Chart part 1
Chart part 2
Password protection
Advance page setup
Lock cell
Text Rotation
Number block
Auto sum
Product
Blank formula
Change Case
Freeze panes
Quick Access
Change currency
Average Formula
Fact Formula
And formula
or formula
Round
Sqrt
Count
Today
Now
Mod
Min and Max
Even or odd
Discount
Percentage
Mini Toolbar
Select Blank cell
Find and replace
How to create Border
Convert Excel file to pdf

Microsoft Advanced Excel

Absolute cell reference
Char Function
Clear Function
Code Function
Dollar Function
Left & Right Function
Right Function
Mid Function
Replace Function
Rept Function
Search Function
Trim Function
ABS Function
INT Function
Roman Function
Round, Round up or Round down
PMT Function
PV Function
Rate Function
NPER Function
Future value Function
Due and Advanced Amount
Scenario Manager
Data Table
Remove if Zero
Pivot Table
Sub Total

Attendance Sheet
Insert New tab
Paste Special
Age calculator
Concatenate
Sparkline
Text to cloumn
Format as table
Fill Blank cell in excel
Count if
Vlookup
Hlookup
Pass or fail formula
Goal seek
Excel Error
Find Formula
Rand and Randbetween
Substitute
Mix cell reference
Marksheet
Nested if
Cube Root
Exact
Istext and isnontext
Comma Style
Sumif Formula
 

Industrial Excel

MIS Report
Indirect Function
Index with Match
Sumproduct
Array
Create New Template
Forecast Formula
Simple Interest
Pivot Chart
Index Function
Data Validation
Dget Formula
E Date
Lookup Formula
Small Formula
Consolidate Multiple Sheet
How to use even or odd with if formula
Is even or is odd formula
Macros
DB Formula (Depriciation)
Frequency Formula
Large formula
Formula Auditing
GCD Formula
LCM Formula
Calculation Option
Conditional Formatting
Conditional formatting (part 2)
Conditional formatting (part 3)
Dmax and Dmin
Average if
Daverage
Dcount
Floor & Celling
If Error
How to convert number to word
How to split name or surname
Full screen
Best triks in excel form subtotal
Excel Master Tricks
Excel Magic Tricks
Important setting part 1
Important setting part 2
Important setting part 3
How to create Bill Format
Create Salary Slip

Looking To Finally Be An Advanced Excel User?

Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?

Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.

 

Why Excel Matters:

We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit. We also know how difficult it is to find quality instruction that is:

  • Easy to follow
  • Gets you the results you want
  • Teaches you advanced methods that you can quickly put into practice

 

In this course you will learn:

  • Use advanced graphs in minutes instead of wasting hours trying to figure them out
  • Increase interactivity by automating your spreadsheets with macros and VBA
  • Solve complex problems with superpower functions  
  • Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
  • And more!