- +91 9925712903
- support@kavitasolanki.com
70 + Excel Tips and Tricks.
Course Information
Trainer
Kavita MS
Microsoft Office Certified and BA
Course Curriculum
Excel 70+ Smart Tricks and Hacks
- How to Edit the Selected Cells
- View All Shortcuts From Excel Excel Worksheet
- Autocorrect the Spelling Mistake
- Custom Auto fill
- Count Numeric Only
- Count Blank Only
- Create Table With ShortCut
- Custom List
- Enter the repetitive data entry within a column
- Format Cell
- Create new Chart Shortcut
- Capitalize each word in a given string
- Create Random Value
- Create Custom Random Value
- Zoom in Zoom Out in Excel- Shortcut
- Create Theme in Excel
- Remove Extra Space from String
- Hide Data In Cell
- Hide Formulas
- Advance Select
- copy of WorkSheet
- Consolidate
- Custom Header Footer
- Change Gridline Color
- Convert number
- Change Default File Location
- Large
- Diagonal Cell
- Drag Data
- Formula text
- Find and replace
- REPT
- Multiple selection
- Insert Gif
- Multiple Rows and Cols
- Count Holidays by specific day
- Create Table With ShortCut
- T Function
- Count Holidays
- Format Cell
- QAT
- Find 2nd or 3rd Smallest value
- Indirect Function
- Transpose
- Transpose Dynamic
- Change Reference
- Insert Gif
- Subtotal
- Flash fill
- Roman
- Select all data
- Resize
- Status bar
- Text to Column
- Yearfrac Function
- Show formula
- Format Painter
- Use of Slicer
- Select Data From Different WorkBook
- Date Custom Format
- Sort and Filter
- Sum in multiple way
Increase your excel skills and knowledge within hours which will get you noticed by top management & prospective employers! Become more productive at using excel which will save you hours per day & eliminate stress at work! Practice with fun, interactive, and highly effective lessons from a best-selling excel instructor. Become an absolute excel power user.
- Fresher
- Students
- Working Professionals
- Business owners
- HR
- CA
- Sales Person
- Managers
- Those who have Passion for developing Excel Skills
Learning excel can assist you to build complicated computations and reporting effortlessly. It is used in each workplace in the world, so offers a great scope. MS Excel is a powerful analysis tool that represents valuable data into the graphical form. MS Excel will assist you to predict your budget and income while building your own business that could save you an abundance of money. MS Excel training for sales and marketing professionals will support their data related tasks seamlessly. This MS Excel course for hr Professionals has been customized by industry leading experts with real-time data and dashboards.
MICROSOFT CERTIFICATION
1250
WORKING PROFESSIONALS TRAINING
1500
CORPORATES TRAINING
120
