Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Basic Excel Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: gotomeeting or meetingburner

Course ID: 26816

Course type: Online Instructor led Course

Platform: gotomeeting or meetingburner

Students Interested 0 (Seats Left 0)

₹ 4,500

No Reviews Yet

Date and Time

Not decided yet.

Umasankar Natarajan picture
Umasankar Natarajan

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

20 Years of Experience

About Umasankar Natarajan

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.
No reviews currently Be the First to Review

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 is looking to learn 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 and connect the system to the internet.

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

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.

Pre-requisites

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

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

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 4,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 4,500 Enquire

Enquire

Submit your enquiry for Basic Excel Training

Please enter valid question or comment

Please enter your name.

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