Diploma in Office Automation
MS Word, Excel, PowerPoint and Tally Prime accounting in one programme
WordExcelPowerPointTally Prime
₹16,00050 hrs · Classroom fee
Course content
What you'll learn
Compufield's Diploma in Office Automation covers Microsoft Word, Excel, PowerPoint, Windows and Tally Prime, everything you need for office and accounts work.
1
Microsoft Word
Microsoft Word for Windows is a full-feature Word processor designed to help you work more efficiently. Microsoft Word shows you how to create effective documents using its features. You will learn how to edit, format, print documents, insert and manage tables and graphics into documents.
- Easy and fast tool to create a one-page letter, a hundred-page report, etc.
- Add graphics to your letters and reports to make them more attractive
- Automatic spelling and grammar check
- Freeform table draw
- Document mapping
- Link to Excel numbers and charts
- Link your Word documents to websites or intranet sites
Application: With Word you can create and type letters, reports, memos, proposals, newsletters, brochures, graphical presentations, web pages, etc.
2
Microsoft Excel
Microsoft Excel for Windows is a powerful electronic spreadsheet application that can be used for managing, analysing and presenting data in a graphical manner.
- Three components: the spreadsheet, the data sheet and the chart
- Create formulas on worksheets easily and fast
- Enhanced formatting and layout for printed reports and online forms
- Quickly find information and create automatic subtotals of your data
- Powerful ways to analyse your data visually
- Bring data from outside Excel onto your worksheet in a few keystrokes
Application: Excel is used for preparing company profiles in the form of charts and graphs, and stores accounting spreadsheets in electronic form.
3
Microsoft PowerPoint
PowerPoint in Microsoft 365 is the presentation tool used in every office. Design clear, modern slides quickly with Designer, Morph and Copilot, and present with confidence in the room or on Teams.
- Design professional slides fast with themes, Designer and Slide Master
- Present data clearly with SmartArt, tables and charts linked to Excel
- Add modern motion with animations, Morph and Zoom
- Record narrated presentations and export them as video or PDF
- Rehearse with Speaker Coach and present with Presenter View
- Co-author on OneDrive and draft slides with Copilot
Application: With PowerPoint you can create company presentations, sales pitches, training decks, reports and profiles.
4
Windows
The operating system is a master program that takes care of the proper functioning of the computer. Windows is a graphical user interface (GUI) in which you click icons to perform a task, which increases the speed and efficiency of your computer-related tasks.
- Work with several programs at once and switch between them with a click
- Give any name to a file, including spaces
- Supports very large drives
- Prints your documents in the background so you can get back to work quickly
Application: Nowadays almost all software is Windows based.
5
Tally Prime (Financial Accounting)
Accounting and inventory in Tally Prime, from vouchers and ledgers to GST, TDS, cost centres, budgets and financial statements.
- Maintain accounts in currencies other than the home currency
- Forecasting with budgets: departmental, financial and marketing budgets compared against actuals to show variance
- Handle and maintain the accounts of a manufacturing company
- Cost centres: allocate expenses and income to different branches of the company in Mumbai or across India
- Maintain accounts related to cost centres
- Tally's advanced TDS (Tax Deducted at Source) features
- Saves time and improves accuracy
- Cash book, ledger, purchase and sales books in seconds; Trading, Profit & Loss and Balance Sheet in minutes
Application: Tally is used by all types of business: proprietor and partnership firms, non-profit organisations and MNC companies.
