Advanced Excel Training in Nepal Microsoft Excel Courses

Advanced Excel Training

Advance MS-Excel Training in Nepal

Advance MS-Excel Training course is targeted for data analysts, business managers, accountants, research scientists, students and other professionals for enhancing their analytical skills and strategic decision making ability. The course aims to make trainees familiar with advance MS-Excel features that are useful in performing complex business operations and overall management functions.

Course Highlights

  • Familiarity with advance features and functions of MS- Excel spreadsheet

  • Learning complex calculation and data analysis process using  various MS-Excel tools

  • Practical knowledge on using advance MS-Excel features in business environments

  • Project Work

Benefits of Advance Excel Training at Broadway Infosys Nepal

We have designed the course after assessing the genuine need of Advance Excel training in Nepal. The key benefits of pursuing Advance Excel course at Broadway are:

  • Experts with decade of experience as instructors

  • Availability of Excel certifications

  • Placement opportunity for deserving trainees

  • Career opportunity as data analysts, data entry operators, accountants and so on

  • Sufficient training resources

  • Regular practical classes to implement Advance Excel skills in real work scenario

Syllabus Outline

  • Introduction to advance MS-Excel features

  • Understanding  of conditional statements and  formulas for conditional formatting

  • Understanding practical implications of Pivot Tables, Charts and Macro operations

  • Learning advance Excel functions for data analysis and solving complex problems

  • Advance financial calculations

  • Working with Macros

Please reach out to us anytime via email, online forms, our social media pages or telephone to ensure your seat for upcoming Advance Excel training session. Our Excel instructors are excited to provide this special Excel training to you and your friends.

 


Duration: 1 Month

Courses Outline- Advance Excel

Customizing the Excel Working Environment

  • Set file properties
  • Define custom properties
  • Add a button to the Quick Access Toolbar
  • Customize the Ribbon
  • Change default number of worksheets, fonts and default view in workbook
  • Protect Workbook
  • Protect Sheet
  • Set a password for a workbook
  • Saving a worksheet as a PDF file

Essential Worksheet Operation

  • Creating a new workbook is a straightforward process
  • Rename a worksheet
  • Copy a worksheet to another workbook
  • Change the order of worksheets in a workbook
  • Hide a worksheet
  • Unhide a worksheet
  • Make a sheet very hidden
  • Delete a worksheet
  • Change a row's height or column's width
  • Insert a column or row
  • Delete a column or row
  • Hide a column or row
  • Unhide a column or row
  • Insert a cell
  • Delete a cell
  • Move a group of cells to a new location
  • Zoom in or out to a specific zoom level
  • Change to another open workbook
  • Arrange all open workbooks in the program window
  • Display copies of the same workbook
  • Activate a worksheet
  • change the color of a sheet tab
  • create a hyperlink
  • edit a hyperlink
  • delete a hyperlink
  • Comparing sheets side by side
  • Splitting the worksheet window into panes
  • Keeping the titles in view by freezing panes

Working with Data

  • Entering data automatically with auto fill
  • Selecting Ranges
  • Selecting special types of cells
  • Placing Information into multiple cells simultaneously
  • check spelling
  • Using AutoCorrect for shorthand data entry
  • Hiding or grouping rows and columns
  • Entering numbers with fractions
  • Formatting numbers
  • Formatting numbers using the Format Cells dialog box
  • Changing text alignment
  • create a name using name dialog box
  • create a named range from a selection
  • display the Name Manager
  • edit a named range
  • Working with dates and time
  • Pasting in special ways
  • Performing mathematical operations without formulas
  • Skipping blanks when pasting
  • Transposing a range
  • Paste Link

Exploring Excel Database Feature

  • Sort a data list
  • Sort a data list by values in multiple columns
  • Add a sorting level
  • Delete a sorting level
  • Sort worksheet data by a custom list of values
  • Organize worksheet data into groups
  • Show and hide levels of detail in a grouped data list
  • Remove grouping levels from a data list
  • Apply a filter to a worksheet
  • Clear a filter
  • Display the top or bottom values in a column
  • Create a custom filter
  • Special Filter for Dates, Text, and Numbers
  • Advance Filter
  • Calculating formulas across worksheets
  • Import data from an external source

Data Table

  • Create a data table
  • Changing the Look of a Table
  • Add new rows or columns
  • Setting table options
  • Removing duplicate rows from a table
  • Multiple-column sorting
  • Converting a table back to a range

Data Validations

  • Data Validation
  • Create a validation rule

Conditional Formatting

Creating Dynamic Lists with PivotTables

  • Display data bars in one or more cells
  • Display a color scale in one or more cells
  • Display icon sets in one or more cells
  • Apply a conditional format to a cell
  • Edit a conditional formatting rule
  • Delete a conditional formatting rule
  • Create a PivotTable from a data list
  • Pivot a PivotTable
  • Show or hide the PivotTable Field List task pane
  • Rename a PivotTable
  • Control how and where subtotals and grand totals appear in your PivotTable
  • Change the PivotTable summary function
  • Filter a PivotTable
  • Apply a number format to a PivotTable
  • Apply a conditional format to a PivotTable
  • Create a new PivotTable style
  • Apply a PivotTable Style to a PivotTable
  • Consolidate data with Pivot Table
  • Change Pivot Table Calculations
  • Make manual calculation in Pivot Table

Analyzing Alternative Data Sets

  • Using auditing to diagram
  • Using Evaluation in Excel
  • Working with Goal Seek
  • Using Scenarios in formula

Printing

  • Printing row and column titles
  • Scaling printed output
  • Force Excel to print using a specific number of pages
  • Printing cell gridlines
  • Change the order in which worksheets print
  • Print part of a worksheet
  • Center material on the printed page
  • Print a chart
  • Add a header or footer to a worksheet
  • Create an Auto Header
  • Add an image to a header or footer
  • Format an image in a header or footer

Collaborating with Colleagues

  • Add a comment to a cell
  • Edit a comment
  • Delete a comment
  • Adding Comments to Cells
  • Changing a comment’s shape
  • Printing Comments

Creating Charts and Graphics

  • Create a chart
  • Choosing Chart types
  • Change how Excel plots your data
  • Remove a series from an axis
  • Add a series to an axis
  • Move a chart to its own worksheet
  • Apply a Chart Style to a chart
  • Apply a different layout to a chart
  • Change the appearance of a chart's gridlines
  • Select a chart element for formatting
  • Select a data point in a series
  • Format a chart element
  • Save a chart as a chart template
  • Add a trendline to a chart
  • Create a PivotChart
  • Change the chart type of a chart or PivotChart

 

 

Manoj Aryal
Advanced Excel

Advance Excel Training to me was compulsory when I was joining to INGO for my job. Bulk data sent from our donors should be managed well. I was in trouble. All I get relaxed when I completed Advance Excel Course from Broadway Infosys Nepal.