Project Description

Course Duration

3 Months 

Format

Physical/Online Classes  

Internship

1 Month

Class Time

Flexible

Overview

What Will you Learn?

  • IOS 15/16 Development with Swift UI.
  • Build iPhone/Ipad app and publish in the app store.
  • Master Swift 5 programming skills.
  • Essential Design Skills and game dev intro.

Benefits at Urja Tech

  • Highly qualified and experienced IOS instructors
  • Internship and full-time recruitment opportunities for successful trainees.
  • Regular communication with experienced IOS developers.
  • Personalized feedback on projects.
  • Career counseling classes to motivate trainees.
  • International standard course
  • Facilitation for certification exam
  • Affordable and updated training course

Courses Outline

  • Configure file properties
  • Create custom properties
  • Add a button to the Quick Access Toolbar
  • Customize the Ribbon
  • Change the workbook’s default settings for the number of worksheets, fonts, and views.
  • Protect Workbook
  • Protect Sheet
  • Set a password for a workbook
  • Saving a worksheet as a PDF file

  • 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

  • Entering data automatically with autofill
  • 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 dialogue box
  • Changing text alignment
  • Create a name using name dialogue 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

  • 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
  • Advanced Filter
  • Calculating formulas across worksheets
  • Import data from an external source

  • 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 Validation
  • Create a validation rule
  • Dynamic Validation List

  • Creating Formats on the basis of Data
  • Setting rules for Conditional formats
  • Using multiple Formatting
  • Removing or clearing Formatting

  • 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
  • Setting Geographical data in 3D map

  • Using auditing to diagram
  • Using Evaluation in Excel
  • Working with Goal Seek
  • Predict data and generating Visual Forecast sheet
  • Using Scenarios in formula

  • 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

  • Basic principles of using functions and formula
  • Practice with Basic calculations
  • Creating Reference and absolute cells in using Formula
  • Building links among the cells
  • Practice with various Formulas and Functions
  • Nested functions in creating advance formulas
  • Tricks and techniques of using multiple formulas for returning desired output

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

  • 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
  • Setting Geographical data in 3D map
Enroll Now

Other Courses

Subscribed successfully.
There seems to be an error right now. Please try again later.