loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Basic Excel Training

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Umasankar

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Basic Excel Training

BTM Layout 2nd Stage, Bangalore

4,500

No Reviews Yet
1 Interested

About the Course


Basic Microsoft Excel training class is designed for students to gain the skills necessary to work with Excel. Trainees will learn in depth knowledge about excel Ribbons, Tabs and Commands.

Topics Covered

Session 01 - Getting Started
• Starting Excel
• Understanding the Display Screen
• Exploring the Office Menu
• Opening a Workbook
• Managing Open Workbooks
• Using Excel Help
Session 02 - Entering Data
• Moving the Cell Pointer
• Selecting a Range of Cells
• Creating a New Workbook
• Entering Constant Values
• Saving a Workbook
• Editing Cell Contents
• Clearing Cell Contents
• AutoFill and AutoComplete
• Working with Undo and Redo
• Closing a Workbook
• Exiting Excel
Session 03 - Quick Access Toolbar
• Adding Icons to the QAT
• Removing Commands from the QAT
• Customizing the QAT
• Assigning VBA Macros to QAT
Session 04 - Working with Ribbon (Home Tab)
• Working with Clipboard functions
=> Cut, Copy, Paste, Format Painter
• Formatting Worksheets (Font & Paragraph)
=> Formatting Numbers
=> Changing the Font Format
=> Aligning Cell Contents
=> Merging Cells
=> Adding Borders
=> Applying Cell Styles
• Using AutoSum
=> Potential Problems with AutoSum
=> Special Tricks with AutoSum
=> Using AutoAverage or AutoCount
=> Function Reference Chapters
• Modifying Worksheets, Columns and Rows
=> Changing Column Width and Row Height
=> Using AutoFit
=> Inserting and Deleting WorkSheets, Cells, Columns and Rows
=> Hiding and unhiding WorkSheets, Columns or Rows
=> Viewing, Renaming, and Color-coding Worksheets
=> Using Custom Worksheet Views
=> Editing Workbooks
=> Using Find, Replace, Goto
=> Sorting Columns
• Working with Conditional Formatting and Data Validation
=> Creating, Modifying, deleting Formatting rules
=> Using Data Validation
=> Creating and Using Custom Formats
=> Working with Auditing and Error Checking Tools
• Using Protection and Shared Workbook Features
=> Protecting Workbooks and Worksheets
=> Protecting a Workbook
=> Protecting a Worksheet
=> Allowing Users to Edit Ranges
=> Working with Shared Workbooks
=> Configuring a Workbook for Shared Use
=> Highlighting Tracked Changes
=> Creating the History Report
=> Reviewing Shared Workbook Changes
=> Merging Workbooks
Session 05 - Working with the Ribbon (Insert Tab)
• Working with Tables
=> Creating a Table
=> Using AutoComplete
=> Sorting a Table
=> Filtering a Table
=> Working with the Total Row
=> Creating a Calculated Column
=> Formatting a Table
=> Changing table style
• Working with Shapes, ClipArts, SmartArts, Pictures
=> Inserting, Resizing and Styling Shapes
=> Insert & Resizing ClipArts, Pictures
• Working with Charts
=> Creating Charts
=> Changing the Chart Location and Size
=> Changing the Chart Type
=> Modifying Chart Elements
=> Formatting Chart Elements
=> Adding and Removing Data Series
=> Printing Charts
• Working with Hyperlinks and Text
=> Inserting & Modifying Hyperlinks
=> Inserting textbox
=> Adding Workart
=> Inserting Objects
=> Inserting Symbols
Session 06 - Working with the Ribbon (Page Layout)
• Page Layout
=> Setting Margin
=> Setting WorkArea
=> Adding Header & Footer
=> Using Print Preview
=> Using Page Setup Tools
=> Printing Worksheets
Session 07 - Working with the Ribbon (View)
• Working with Views
=> Freezing and Unfreezing Panes
=> Arranging Windows
=> Splitting, Hiding and Unhiding windows
=> Zoom In and Out
=> Switch Windows
Session 08 - Working with the Ribbon (Review)
• Proofing, Comments, Changes
=> Protecting a Worksheet & Workbook
=> Allowing Users to Edit Ranges
=> Working with Shared Workbooks
=> Configuring a Workbook for Shared Use
=> Highlighting Tracked Changes
=> Creating the History Report
=> Reviewing Shared Workbook Changes
=> Merging Workbooks
=> Adding & Editing and Deleting Comments
=> Working with AutoCorrect
=> Checking Spelling
Session 09 - Working with Basic Formulas and Functions
• Formulas and Functions
• Absolute & Relative References
• Creating and Using Named Ranges
• Working with Insert Function
• Using Logical Functions
• Using Date Functions
• Using Math Functions
• Copying & Pasting formulas and functions

Who should attend

Anyone who would like to become expert in Excel Basic (Ribbons, Tabs and Commands).

Pre-requisites

1 ) Student should have basic computer knowledge like working in Windows, Just they should know about logon to the system.

Student can contact me 1 or 2 days before the workshop, I will send the link for online teaching software and make his/her system ready to run the class smoothly.

What you need to bring

As It is online class, Students should have good Laptop or Desktop with good internet connection at least 256kbps. Internet Connection should be work continuous.

Laptop or Desktop should have Windows XP, Windows Vista, Windows 7, Windows 8 or 8.1 OS installed.

Laptop or Desktop should have Ms Office 2007 or 2010 or 2013

If they miss two or three of the sessions / topics, can reach me, I will take separate class to cover the missing sessions.

Key Takeaways

My training will be focused with practical example of Basic Excel (Ribbons, Tabs and Commands).

Students will gather more knowledge about Basic Excel (Ribbons, Tabs and Commands).

Students able to debug their formulae and functions and fix the bugs independently.

Students can directly work excel without any further basic excel training from their supervisor / company.
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Umasankar Natarajan picture

Umasankar Natarajan

B.E., M.B.A., PMP


I have 22 Years experience - 20+ years of software design & development experience and 2 years of Non IT experience.

I have practically worked C, C++ , PHP, MySQL for 18+ years in different software companies like Tata Elxsi, Mphasis, Aricent, Mindtree.

I worked 8+ years as Project Manager, where I worked many excel vba project to create dashboard and automate project reports.

I completed 25+ realtime project in Software Industries. Out of which I have done 21+ C & C++ Real time projects. 15+ Excel Projects for Automation, Dashboard and report generation.

6+ PHP MySQL Real time Projects.

I can teach you Excel VBA Macro Programming in depth with practical examples.

I can teach you C and C++ Programming in depth with practical examples. Also I will teach C & C++ with memory level debugging.

I can teach you PHP - MySQL programming in depth with practical examples.
Seats Left-

Students Interested 1

Course Id: 26817