Advance Excel Training Course

About Course

Advance Excel Training Course

Learn advance excel from scratch. Our course is planned by industry specialists. You will get 100% practical clarification in our live classes. You will get numerous assignments and projects incorporated with every subject of this training program. Learn the important aspects of advance excel like working with functions, data validations, sorting and filtering data, working with reports, formatting, charts and many more essential things while learning advance excel. We will also prepare you for excel certification. Once the completion of this training you will also get Paathfind certification.

Our MS Excel and Advance Excel Training Course in Jaipur are certified and experienced working professionals with hands on real time knowledge. Therefore We have designed our course content and syllabus based on students requirement to achieve everyone career goal. In our Microsoft Excel (MS Excel) training program, you will learn to work.

In conclusion this helped them to continue Microsoft Excel (MS Excel) training Online without any delay in course completion. We offer both combination of Classroom / Instructor-led training and Excel & Advanced Excel online training in Jaipur. Whenever you can travel, you can attend the Excel & Advanced Excel classroom classes or choose to attend our Excel & Advanced Excel online classes. You can also switch to Classroom from online classes without any additional course fees.

As a result you have great experience with Paathfind Institute. Paath find is a eminent computer classes in Jaipur for all computer courses In jaipur.

 

Mode of Training  Online Live Classes

Certificate In Advance Excel Training Course

Show More

What Will You Learn?

  • Every basic thing in advance excel
  • Learn to work on MS Excel
  • Learn sorting and filtering data
  • Learn to work with functions and formulas
  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • Create nice, clear and proper sheets and tables in MS Excel
  • Learn to work with short-cut keys
  • Start learning advance excel from anywhere

About the instructor

A

Course Curriculum

Introduction

  • What is Advance Excel?
  • Importance and benefits of Advance Excel?
  • Requirements of Advance Excel
  • What does Advance Excel consist off?
  • How Advance Excel works?

Excel Formulas

  • Introduction: Excel Formulas
  • Excel Formula Syntax
  • Writing Efficient Formulas with Fixed & Relative References
  • Common Excel Error Types
  • Navigating Excel Worksheets with Ctrl Shortcuts
  • Saving Time with Function Shortcuts
  • Accessing Tools with Alt Key Tips
  • Creating Drop-Down Menus with Data Validation

Introduction to the Advanced Microsoft Excel Formulas & Functions

  • Draft Rand between Function
  • Convert Function
  • Workday & Workdayintl Functions
  • Rand Function
  • Mixed REF
  • Absolute & Relative REF
  • Adding zero in MS Excel
  • Automatic Serial number gate
  • Autosum Function
  • Vlookup Function
  • Hlookup Function
  • Choose Function
  • Transpose Function
  • Rank Function
  • Countblank Function
  • Index & Match Function
  • Convert from Numbers to Words
  • Create Data Entry Form in Excel

Entering and Editing Text and Formulas

  • Entering Text to Create Spreadsheet Titles
  • Working with Numeric Data in Excel
  • Entering Date Values in Excel
  • Working with Cell References
  • Creating Basic Formulas in Excel
  • Relative Versus Absolute Cell References in Formulas
  • Understanding the Order of Operation

Modifying an Excel Worksheet

  • Moving and Copying Data in an Excel Worksheet
  • Inserting and Deleting Rows and Columns
  • Changing the Width and Height of Cells
  • Hiding and Unhiding Excel Rows and Columns
  • Renaming an Excel Worksheet
  • Deleting an Excel Worksheet
  • Moving and copying an Excel Worksheet

Inserting Images and Shapes into an Excel Worksheet

  • Inserting Images
  • Inserting Excel Shapes
  • Formatting Excel Shapes
  • Working with Excel SmartArt

Formatting Data in an Excel Worksheet

  • Working with Font Formatting Commands
  • the BackgroundChanging Colour of a Cell
  • Adding Borders to Cells
  • Excel Cell Borders Continued
  • Formatting Data as Currency Values
  • Formatting Percentages
  • Using Excel’s Format Painter
  • Creating Styles to Format Data
  • Merging and Cantering Cells
  • Using Conditional Formatting
  • Editing Excel Conditional Formatting

Assignments

  • Adding Borders to Cells
  • Formatting Data as Currency Values
  • Formatting Percentages
  • Merging and Cantering Cells
  • Inserting Images and Shapes into an Excel Worksheet
  • Modifying an Excel Worksheet
  • Entering and Editing Text and Formulas
  • Using all Excel Formulas & Functions
Open chat
1
Hi! We have Upto 70% off on all courses. WhatsApp Now. (Online & Classroom Training Available)