Course Detail
IT Office
[Download Free Outline]
Introduction to Ms Excel
Microsoft Office (IT Office) is a collection of software and services developed by Microsoft. Stepping into the world of Microsoft and learning will benefit you in every aspect of life. Ms Office consists of many software like Excel.
Microsoft Office 2019
Microsoft Office 2019 will facilitate with security updates and will only run on Windows 10 and on the most recent versions of macOS. On the other hand, Ms office 365, gets updated regularly with new features.
Microsoft Excel
Excel is an electronic spreadsheet program that is utilized in recording and analysing numerical data. The sheet is spread as a collection of columns and rows that form a table. Alphabetical letters are usually allocated to columns and numbers are assigned to rows. A cell is represented by the letter which addresses the column and a row is represented by the number. Learn ms excel which has many functions to extract and analyse the data that range from basic mathematical functions to complex statistical analyses will help in managing accounts, etc.
Why Learn Advanced Microsoft Excel?
Excel is a universal language that is used worldwide to deal with numbers in many ways. So, for the ease of people, Microsoft Excel is used if we want to record, analyze and store numeric data. Excel training will enable you to work efficiently and make the process of organising and manipulating data quite fast. If you acquire the great analytical skills of excel, the chance of higher employability increases. On top of that, starting with excel basic training will help you to understand the concepts and functions of this application.
Microsoft Office certification
Demonstrate your skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. There are 3 steps to get Microsoft office certification:
Step 1: Empowering skills
Step 2: Select any MOS Excel exam to get certified in that program
Step 3: Attempt Certification Exam
Microsoft Office course in Lahore, PK
ICT-training institute trains the complete ms office course applications to candidates in a precise manner by the hand. Candidates will get MS Excel training using the program from scratch! As you gain confidence in word, excel, powerpoint and outlook, you will learn ms courses with more advanced features that will be deeply explained by the trainees.
After completion of the course, the participants will be able to use the computer, including Internet services, will be able to create documents, develop reports, make presentations, data analysis, charting, and can perform various other tasks for everyday home or office use.
Microsoft Excel Course Contents
Microsoft Office curriculum follows the Microsoft standards and is designed to meet the requirements of every home & office user needs.
Intro to IT & Computers
- Basic Concept of IT
- What is a Computer?
- Components of a Computer
- Classification of Computers
- Computer Software
- System Software [Operating System – Ms Windows]
- Application Software [MS Office]
- Operating System
- The Windows Desktop
- Desktop Wallpaper
- The Taskbar
- Setting the Date and Time
- Toolbars
- The Windows Start Button
- Share your computer with others
- Setting Parental Controls in Windows
- Copying Pictures to a New Folder
- How to take a screenshot in Windows
Microsoft Excel
Getting Started With MS Excel
- Excel rows and columns
- Workbook & worksheet
- Enter text and numbers in a cell
- Edit text in a cell
- Cell formatting
- Font formatting
- Merge cells
- Save your work
Formulas and Functions
- Entering formulas
- Copying data and formulas
- Using AutoSum
- Understanding functions
- Using simple aggregate functions (Sum, Count, Average, Min, Max)
- Copying formulas
Editing Features
- Using cut , copy, and paste operations
- Using paste special with values
- Selection techniques
- Navigation techniques
Working with the Large Workbooks
- Freezing and unfreezing panes
- Splitting windows
Inserting page breaks for printing-
Working with Charts
- Creating charts using Chart Wizard
- Creating different types of charts
- Including titles and values in charts
- Formatting of charts
Inserting Graphic Objects
- Insert and modify pictures and clipart
- Draw and modify shapes
- Illustrate workflow using smartart Graphics
Previewing and Printing
- Previewing worksheets
- Page setup
- Printing of worksheets in multiple pages
- Repeating rows and columns for multiple pages
- Printing multiple worksheets
Practical Approach
- The real-life examples will be given throughout the lectures.
www.ict-trainings.com/curriculum/msoffice-leaflet.pdf