logo

Microsoft Excel Training

Get your hands on excel from our experts.

Basic Excel

Are you new to Excel? This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets

Intermediate Excel

Our intermediate Excel training courses cover more complex Excel functions, charting, and data tools. Go beyond the basics to learn more formatting, more formulas, and more functionality. The intermediate Excel training starts working with functions such as IF, Proper, Roundup and Date and Time functions. It also looks at how to create formulas across multiple spreadsheets in the same document.

Advance Excel

The Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros , embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine them with other functions.

Our best plans

Basic

Nrs 6000.00 / 20 hours
Topic Covered
  • Navigating to accomplish tasks
    • Using the Ribbon, Office Button, and menus (depending on software version)
    • Cells, columns, and rows
    • Keyboard shortcuts
    • Freezing and splitting panes
    • Zooming
    • Hiding columns and rows
  • Entering basic data into Excel
    • Formatting dates and times
    • Spell check
    • Undo and redo buttons
    • Creating and modifying tables
    • Sorting and filtering tables
  • Creating basic Excel formulas
    • Subtraction, division, multiplication
    • Cell references
  • Using functions
    • Manually typing functions
    • AutoSum and AutoCalculate
  • Moving and copying data
    • Cut, copy & paste
    • Fill handle
    • AutoFill
    • Flash Fill
    • Smart Tags
  • Organizing and Working with Multiple worksheets
    • Renaming and coloring tabs
    • Moving, copying, and inserting worksheets
    • Margins
    • Headers and Footers
    • Printing Options
  • Basic Excel Formatting
    • Adjusting width and alignment
    • Formatting text in cells
    • Wrapping and merging
    • Formatting numbers

The basic Excel training is optimal for beginners in this application. It will give you the skills needed to work with spreadsheets and get started in the intricate world of Excel. This training will give you confidence to navigation and enter data into Excel and even create simple formulas.

Enroll Now

Intermediate

Nrs 8000.00 / 20 hours
Topic Covered
  • Formulas & Functions
    • Typing formulas and functions
    • Cell references and reference formulas
    • AutoSum
    • The Functions Library
    • Average, date, and time functions
    • Nested IF Statements
  • Moving and Copying Data in Excel
    • Cut, copy, and paste data
    • The Fill Handle
    • Absolute and relative references
    • AutoFill and custom Lists
  • Working with More Functions
    • Date and Time Functions
    • Calculating dates in years
    • IF Statements in Date Functions
    • The Proper Function
    • The Roundup Function
  • Working with Multiple Worksheets
    • Renaming worksheets
    • Color coding tabs
    • Moving and copying worksheets
    • 3D reference formulas
    • Hyperlinks
    • ScreenTips
  • Formatting Cells and Appearance
    • Formatting text and numbers in cells
    • Merging cells
    • Wrapping text within a cell
    • Custom number formats
    • Copying formatting
  • Viewing Worksheets
    • Showing formulas and references
    • Tracing precedents and dependents
    • Grouping rows and columns
    • Cell comments
    • Headers and footers
  • Introduction to Basic Charts
    • Creating and defining a chart
    • Positioning, rotating, and resizing charts
    • WordArt in charts
    • Editing charts in Excel
    • Changing types
    • Formatting a data series
    • Multiple series charts
    • Sparkline charts

The Intermediate Excel training covers things beyond the basics, to give you more confidence in building your spreadsheets and creating formulas to automate them.

Enroll Now

Advanced

Nrs 10000.00 / 24 hours
Topic Covered
  • Advanced Formulas
    • Viewing available Excel functions
    • Basic text functions
    • Concatenate and “IF” statements with concatenate
    • ISBLANK Function
    • COUNTBLANK Function
    • Arrays
    • Using name ranges in formulas
  • Look Ups and Other Functions
    • HLookup
    • VLookup
    • Calculating days of the week
    • Calculating number of weekdays from a date
    • Calculating months between 2 dates
    • SUMIF Function
  • Data Views, Layouts, and Rules
    • Transposing Data
    • Validations for length and drop-down lists
    • Custom Views
  • Introduction to Macros
    • Developer Tools
    • Saving Macros
    • Absolute vs Relative Macros
    • Recording Macros
    • Creating Macro buttons
  • Additional Tools in Advanced Excel
    • Embedding and linking
    • Editing and embedded object
    • Editing a linked object
    • Linking as an icon
    • Protecting worksheets
    • Locking cells
    • Protecting a workbook

The advanced excel training helps students learn new functions to enhance their spreadsheets as well as tools to make their spreadsheets easier to share with added automation.

Enroll Now