• English
  • Polski

EXPO Katowice S.A.

Microsoft Office suite in company

shutterstock_2236981173

Microsoft Office suite in company

Participants take an active part throughout the class, performing a number of practical exercises that I tailor for a specific group of participants, according to their needs and activities in MS Office programs.

Target group

The three-day workshop is designed for those people for whom the computer is a tool for everyday work. The workshop is intended for those who have experience working with computers, use Microsoft Office programs on a daily basis, and have often already participated in training courses and workshops on computer use. I recommend them mainly to office workers, secretaries, assistants, employees in human resources, sales or production departments. I also recommend them to executives and managers, for whom daily work is the creation and management of business information.

Training methods

The course is conducted using interactive methods, with the use of a multimedia projector, All exercises are conducted on the basis of examples taken from practice (so-called case studies). Classes, despite the presentation of complex factual knowledge, are conducted in an understandable manner, ensuring the assimilation of transmitted knowledge by each participant of the course (regardless of previous experience with Microsoft Office). Each participant receives a set of written materials (scripts, supporting materials for exercises) and copies of data with all exercises conducted as part of the course.

Training program

  • Microsoft Word text editor – a modern creation tool and management of various text documents
  • History of program development, versions, program organization
  • Adapting the user interface to your own requirements.
  • File saving options – locally, on a local network, in the data cloud, Word file formats, file conversions from previous versions of Word and other text editors
  • Elements of computer typography – the language of letters; professional folding text, paragraphs, sentences.
  • Creating corporate templates – text document templates,
  • Using Word fields and updating them in text documents.
  • Advanced document formatting, use of styles to simplify formatting, formatting a large document
  • Building a document outline, table of contents
  • Automatic signatures, references, cross-references
  • Spelling and grammar check of text, dictionaries
  • Advanced tables and their formatting, table lists
  • Improving work through the use of forms, wizards.
  • Registering, running, editing macro commands.
  • Graphics, charts and other objects in the document, their formatting.
  • Preparing a text document as an e-mail attachment.
  • Collaboration with documents from other programs (e.g. Excel)
  • Preparing a database and mail merge in Word
  • Prints on envelopes and self-adhesive labels.
  • Managing the circulation of text documents in the company.
  • Overview of the capabilities of the Microsoft EXCEL sheet, program organization, document organization – workbook
  • Saving files – locally, in the local network, in the data cloud, Excel file formats, file conversions from previous versions of the program
  • Optimal “personalization” of the work program, Excel settings options
  • Building, modifying, formatting sheets, using functions
  • Using relative, absolute, and mixed references in formulas (e.g. A1, $A$1, $A1, A$1)
  • Organizing and building a data table on a sheet, entering data, selecting data using criteria.
  • The use of local and global names in the sheet, the use of names in formulas
  • Conditional formatting, application variants, editing conditional formats
  • Multiple nesting of functions, numeric constants
  • Use of Excel functions from the categories: mathematical, date and time, search and address, databases, financial, logical, text, information, etc.
  • Formula inspection, error checking
  • Technologies for downloading data from external sources (Excel data sources, database queries, using the MS Query module, downloading data from various sources)
  • Using pivot tables as a business data analysis tool, principles of creating pivot tables
  • Create and modify PivotTables based on different data sources, custom calculated fields, data grouping, custom data formatting in PivotTables, conditional formatting in PivotTable
  • Database functions, examples of practical applications, selection of criteria, alternative and conjunction of criteria
  • Import of data from text files to Excel – analysis of text data, automation of data refreshing.
  • Sheet protection, workbook protection, data validation
  • Optimizing solutions to complex problems with Solver, forecasting
  • Speed up your work thanks to Excel templates, templates with macro commands
  • Creating electronic forms in Excel, using control elements in forms (lists, drop-down lists, buttons, knobs)
  • Recording, running and editing macros
  • Consolidation of data from different sheets, various methods of consolidation
  • Organization of work with Excel on a computer network: simultaneous work of many users on one sheet, combining sheets and workbooks via a computer network, merging data from multiple sheets, limiting editing of ranges in a sheet
  • A brief overview, versions and development of Power Point
  • Elements of the presentation creation process: slides – slide layouts, slide formatting notes and information materials – preparation, printing
  • Organizing the document, saving the file in the selected format – *.pptx, *.pptm files, *.ppsx, *.ppsm files, saving – locally, in the local network, in the data cloud, packaging presentations
  • Using templates and wizards to create a new document.
  • Charts in presentation, chart type, formatting
  • Inserting a chart from MS Excel, editing and formatting the object
  • Organizational chart, diagram in presentation
  • Creating and formatting a table
  • Graphic objects – inserting and formatting
  • Inserting and formatting drawings, photos, engravings (including searching for files on the Internet)
  • Creating a photo album
  • Insert and play videos and sounds in your presentation
  • Hyperlinks – insertion and formatting
  • Global changes in the presentation – settings and formatting of slide templates, notes, information materials
  • Font replacement
  • Saving and using presentation templates, saving project templates
  • Presentation outline – construction, displaying views
  • Import outline from MS Word
  • Dynamics in presentation – slide transitions, object animation, slide animation, animations throughout the presentation, role of presentation design and pattern
  • Presentation screen settings, show preparation, presentation show options

Benefits of training

After completing the workshop, the participant will be able to:

Certificate

After the training, the participant will receive a certificate confirming participation in the training and acquired knowledge.

Coach

Projekt bez nazwy-41

Janusz Gach

He has been providing training for years, explaining the intricacies of spreadsheets and accessibly showing the possibilities behind them. He specializes in Microsoft Excel, as well as other elements of the MS Office suite. His training courses are aimed at employees in the financial sector, as well as other office workers, engineers, salespeople of various professions. The trainer’s training courses and classes are used by all who wish to expand their practical use of the spreadsheet: both at a basic and more advanced level.

Trainings EXPO Katowice S.A.

Individual training

If you have not found a training course in our offer that perfectly suits your company’s needs, we encourage you to contact us. We will create a personalised offer for you, taking into account the specific needs and preferences of your company.