We aim for the participants of the training to use Microsoft Office applications more efficiently and make use of their time well, accelerate their daily workflow and create added value with correct analysis.

Participants who have completed their PEAKUP training keep getting information about Microsoft Office with videos, articles and regular monthly journal contents after the training.

egitim_servisi
Training ServicesThey are applied trainings given by our professional consultants to use Office programs effectively, correctly and fast.
danismanlik_servisi
Consultancy ServicesLet us take care of the macro files you are unable to work out, forms that you want to improve, and all Microsoft Office arrangements in a very short period of time!
destek_servisi
Support ServicesConsult us anytime you have an issue with the Microsoft programs, get quick answer from our live support line and keep working without losing any time!


We will analyze your Office knowledge the most correct way possible! Enjoy participating a training with people who have similar level of knowledge as you!

Get prepared to learn non-standard information that will bring you ahead with the custom training content!

Let's work on real work scenarios with expert instructors!

Don't worry about taking notes during the training. We give you our training materials!


We don't say goodbye after the training! We are expecting you to training evaluation survey and the test where you can learn your level that you can reach from the portal special for you.

We have prepared dozens of video training material for you to revise any time you want! Watch and learn after the training with the user account special for you!

Even if you don't come, we are with you. We send our journal that contains short surveys and articles that will help you to remember what you've learned to your e-mail address every month!

You can call the live Office Help Line when you come across a problem while studying. Just ask, and we will answer. And you keep enriching your company in the meantime!

Send your contact information to get an informative call from our expert staff, and let us create the best solution for the training you need as soon as possible together.

Why PEAKUP Microsoft Office trainings?

Excel

Excel basically is a comprehensive application that allows you to do a lot of actions from entering data to making financial calculations. A lot of companies like banks, public institutions, medicine and textile industries etc. use Excel and keep a lot of lists like Financial Analysis, Sales Statistics, Personnel Salaries, and Social Security Premium, and make calculations on them. For Excel that a lot of companies use to follow critical work to be correct and fast, users should use Excel on the best level possible. But with years of experience from our trainings, we can easily say that most workers including those in Sales, Accounting and even Budget and Reporting Departments who have been working on Excel like , apart from some conventional methods, they don’t know about new methods that will make them work faster. Users learn a lot of features and methods that will facilitate their job, explore the depth of Excel and leave the training with satisfaction since they have learned useful information. Excel training is one of the most important trainings that can affect the productivity of a lot of departments like HR, Accounting, Sales, Finance, Administrative Affairs, Budget and Reporting. 

  • You can highlight the rows where growth rate between last year and this year is under 5% in red on a table where you list your annual sales. 
  • You can automatically create custom pages special for each group on a table that shows all the sales based on product and sales representative.  
  • You can join Off-days that are in different pages in one single page with VLOOKUP.
  • You can print only the part you want in an Excel page.
  • You can automatically open a lot of Excel files coming from your sales team, copy the data and paste one under the other with just one button with macros. 

Word

Do you use Word in your Company? Then, we have a lot of accelerating recommendations for those who write plain texts! We come across a lot of problems on Word even while we are writing a plain text. When tables, charts and images come into the play, things get a bit more complex. But when you start to learn the program, you will see why you have these problems and that there are a lot of methods to prevent them. Also, you will be able to do complex actions that you could never think that can be done on Word with just a few clicks. Considering that pretty much all of us use Word to prepare a document, making your workers prepare documents fast by improving their Word abilities will not only save the employee sometime of his/her shift, but also will make the departments who start working when the written documents are ready take action and  contribute to the company productivity 

When we want to move a text to the beginning of the next page, most of us press Enter and just when we think that the document is complete, we see that the text has moved to the middle of the page. When you do the same action with cut and put (CTRL + Enter) method, you will see that the text doesn’t move. 

  • You can send e-mails starting with their names to hundreds of people on your customer lists during special times like religious holidays/new year in just a few minutes with the Word working integrated with Outlook feature. 
  • Word offers efficient methods to accelerate your communication on documents that you need to correspond with people within or outside the company. For example, on an analysis document going between the software team and the analyst or on a contract you share with your customer, you can track changes and what they write on the document and add notes. 
  • You can change the alignment of the page as horizontal instead of reducing and fitting the schema when you add a wide horizontal schema to a vertical page on your document and it doesn’t fit. 
  • You will be able to add objects like logos, page numbers, background images that protect the corporate image of your documents in just a few minutes. 
  • You will be able to easily arrange Charts, Tables, Images and SmartArt by having good control and enrich your documents. 

PowerPoint

Do you have departments that presents on behalf of your company to your customers or to your managers within the company? Excel, Word, PowerPoint and Outlook are 4 basic programs that help the business continuity of companies. Your personnel’s skills on these programs will positively affect you on different aspectsThe most helpful assistant of your sales teams or other people that represent your company is the presentations they prepare. Your sales personnel preparing impressive presentations with short sentences and correct chart and image usage will affect your customers positively. Also, when you are presenting a successfully completed IT Project to executives, having a well-prepared presentation will help you to express your success well and be supported in new project initiatives. But users usually leave preparing presentation to the last minute and thus they don’t have enough time. PowerPoint has a lot of features to help you create successful presentations in a short period of time 

  • Don’t let slides where you cannot click the logo bother you, the logo is probably added to the slide master. Learn about the slide master and take the control of the presentation! You can work on the background of your presentation and add the company logo to all slides with the slide master.  
  • If you use Power BI, you can display your current Power BI Charts on your PowerPoint presentations with one click. This way you don’t have to update the charts. 
  • You prepare multi-slide presentations too? Don’t lose time while sorting your slides. It is easier to do with the Slide Sorter! 
  • A lot of slides, one PowerPoint presentation! If you are presenting the same presentation to different groups, you can hide/show specific slides to specific groups. In the Istanbul location 1,2,3,10,11,12… slides can be shown and in the Izmir location 1,2,5,6,7,12 slides can be shown of the same presentation! 
  • You can have control of Charts, Images and SmartArt objects and prepare impressive presentations with high visual quality in a short time. 
  • Adding action to your presentations and enchanting your audience is very easy now with the Morph feature! Distribute all the mechanical parts of the product you are presenting with one click, talk about them separately and make them a whole again with one click! 

Outlook

Outlook is one of the gears of your company motor in some way and is the door that opens to the outer world from your company. Also, it works as a bridge within the company when it comes to making decisions, teams cooperating and works flowing. It would be wrong to think that such an important application for the workflow offers simple mail sending and receiving actions. This program that most of us use frequently during the day regardless of the sector or department we work in, has a lot of features that will let us customize and make our mail sending/receiving actions faster. Also, you can plan all your work life with your contacts within and outside your company with the Calendar feature. You can quickly create and update a meeting and create recurring meetings. Using Outlook efficiently which is the biggest communication tool with your customers after telephones is one of the keys of healthy corporate communication.  

  • Your mails being grey when you are in CC will make it easier for you to focus on more important mails. You can highlight mails that meet specific conditions with Outlook conditional formatting and group the mails in your mailbox with one look.  
  • When you receive an “Offer” themed mail from your customers, you can send a mail stating “I have received your mail, I will be contacting you as soon as possible” with one click.  
  • You can create files for your mails with Outlooks, set rules and makes mails coming from your teammates/managers come to the relevant file. 
  • You don’t have a Survey application? If you have Outlook, just keep going! You can do surveys within your team or company with the voting buttons and make fast decisions by seeing all the answers on one single screen. 
  •  You can give yourself an error margin in the mails you send on Outlook, make your mails go a few minutes later before you press the send button. 
  • You have written “You can find … attached” and there was nothing attached? You can recall and e-mail from the mailbox if the receiver hasn’t read it yet in order not to feel embarrassed when we forget the attachment or write incorrect content.  

Contact

Visit Our Training Content page to analyze the updated content of our Microsoft Office trainings and create your training plan.

office_egitim_yol_haritasi
Word

Basic Word

You can format your documents fast, fix your mistakes, add graphics and figures and edit them by learning the advanced tools of Word. Also, you can print correctly by using print settings. With this education you will learn methods that will increase your control over the document and complete your actions in a very short time.

Duration: 1 Day

Module 1: Overview of Word

  • Use the Backstage Button
  • Customize the Ribbon
  • Use Office Menus
  • Use the Quick Access Toolbar
  • Use the Help Menu
  • Use the “Tell me what you want to do” feature *New

Module 2: Document Control

  • Enter a text
  • Insert and Delete a Text, and use Different Fonts
  • Copy and Paste the Text
  • Move and Copy a Text Between Documents
  • Undo changes

Module 3: Formatting

  • Use the Ribbon
  • Use Quick Format Toolbar
  • Edit Paragraph Options
  • Copy Formats
  • Use Automatic Correction
  • Insert Bullets And Numbering

Module 4: Version Management and Text Functions

  • Use the Navigation Pane
  • Version Management
  • Split a Text into Different Columns
  • Change the Capitalization or case of a Text
  • Use Tabs
  • Insert Symbols and Special Characters
  • Find and Replace a Text
  • Insert a Text Automatically
  • Insert Date and Time

Module 5: Proofing a Document

  • Use the Thesaurus
  • Spell Check
  • Checking the Number of Words

Module 6: Working with Tables

  • Create a Table
  • Use the Table Tools Section
  • Add and Delete Columns and Rows
  • Enter Data to the Table
  • Create Automatic Formatted Tables
  • Transform a Table into a Text
  • Use Formulas within the Tables

Module 7: Inserting Graphical Objects

  • Insert a Clip Art
  • Insert a Watermark
  • Ink Equations *New
  • Insert a Symbol

Module 8: Print Settings

  • Use the Layout Tab
  • Insert Header-Footer
  • Change Margins
  • Insert a Page Break
  • Preview the Document
  • Print the Document
  • Fast Print

Advanced Word

With this education you can use styles efficiently, create professional work by enriching your texts with advanced document techniques, send e-mails with the address letter feature and control a lot of features where you can print labels. In addition to that, you can turn it into a dynamic program by integrating with the other programs. Also, you obtain necessary skills for cooperation by using encrypting methods, document-tracking options, inserting and following a comment features actively.

Duration: 2 Days

Module 1: Definition of Styles and their Applications

  • Define Style Properties
  • Change and Apply Style Properties
  • Transfer Styles Between Files

Module 2: Advanced Document Techniques

  • Use the References Tab
  • Insert Hyperlinks to a Text
  • Add Comments to a Text
  • Add a Bookmark to a Text
  • Add and Update a Field
  • Use Captions
  • Create Cross-References
  • Add Footnotes to a Text
  • Add a Table of Contents
  • Add Page and Section Breaks

Module 3: Print Envelopes and Labels

  • Use the Mailings Tab
  • Use Data Sources
  • Merge Letters and Addresses
  • Create a Name Tag
  • Send a Mass Mail with Personal Names

Module 4: Working with Templates

  • Use Templates
  • Add Fields and Formulas to the Templates

Module 5: Customize Word

  • Customize Quick Access Toolbar
  • Customize the Ribbon

Module 6: Cooperation

  • Add and Delete Comments
  • Track and Print Comments
  • Work on a Workpaper together by Sharing It
  • Tracking Options
  • Accept and Deny Changes

Module 7: Protect and Track the Document

  • Use the Review Tab
  • Track Changes
  • Protect the Document
  • Compare and Combine Word Documents

Module 8: Work with Graphical Objects

  • Use Picture Tools
  • Add Effects to a Picture
  • Remove the Background of a Picture
  • Add Screenshots to the Document
  • Work with SmartArts
  • Add a Cover Page
  • Explore Special Chart Types special for Office 365 *New

Module 9: Data Exchange with the other Programs

  • Create a Link
  • Word & Excel
  • Word & PowerPoint
  • Word & Outlook
  • Save as PDF, XPS, XML

Module 10: Print Settings

  • Use the Version Management
  • Inspect the Document
  • Encrypt the Document
  • Rights Management
  • Insert a Digital Signature
  • Mark as Final
  • Compatibility Inspector
Excel

Basic Excel

You can get the prerequisite information for advanced Excel Education in the Microsoft Office Excel basic education. It is for people who get to know Excel for the first time or who have just a bit of information. You can learn short cuts and methods like Excel interface, cell structure, worksheet, easy calculations, creating tables, basic formatting and print setting that are necessary for the beginner-level and gain experience. Also, you can learn the function and experience basic functions and customize your worksheets.

Duration: 2 Days

Module 1: Introduction

  • Get Started with Excel
  • Use the Backstage field
  • Use the Quick Access Toolbar
  • Customize the Ribbon
  • View Older Versions of the workbook *New
  • Use the “Tell me what you want to do” Feature *New

Module 2: Working within the Worksheet

  • Data Entry and Selecting techniques
  • Undo and Redo

Module 3: Editing on the Worksheet

  • Add and Delete Cells, Columns and Rows
  • Change the Column width and Row Height
  • Hide Columns and Rows
  • Move and Copy Data

Module 4: Make Calculations

  • Create a Formula
  • Use the Pin Feature with the ($) Sign in the Formulas

Module 5: Formatting

  • Use the Ribbon
  • Use the Quick Format Toolbar
  • Format Font, Alignment, and Numbers
  • Format Tables

Module 6: Themes and Styles

  • Create and Apply a Theme
  • Create and Apply a Style

Module 7: Workbook

  • Format Page Tabs
  • Place Worksheets
  • Insert or Delete a Worksheet

Module 8: Print the Content of the Workbook

  • Arrange a Print Title
  • Create a Header & Footer
  • Define the Printing Area

Module 9: Customize Layout

  • Split, Hide or Show a Worksheet
  • Align Worksheets
  • Freeze Columns and Rows

Module 10: Introduction

  • Create Charts
  • Use the Chart Toolbar
  • Add and Delete Data with a Chart
  • Create Trend Charts
  • Explore Charts Special for Office 365 *New
  • Make SmartArt Edits
  • Create Hierarchy and Pyramid
  • Add Ink Equation and Symbols *New

Expert Excel

You need to have completed the advanced level Excel Education before you get this one. You can learn complex function structures, write nested functions, use control functions and functions like If, And, Or of logical functions effectively. Also, you can create criteria and see database function in more detail, import data of different file types and analyze by interpreting them with Excel. You can create relation between tables by using dynamic tables efficiently in your educations, and experience formulation structure in dynamic tables. You can learn how functions are used in Conditional Format and Data Verification with practical examples. Besides, you will learn solver, scenarios, multivariate tables with different examples and discover the Power of Excel.

Duration: 2 Days

Module 1: Analyze Data

  • Solve with Goal Seek
  • Model with the Solver
  • Create One-variable or Multivariate Tables
  • Create Prospective Projection with Scenarios
  • Define Special Criteria Fields for Advanced Filter
  • Define Data Range and Use It in Functions

Module 2: Advanced Functions

  • Make Dynamic Searches (Index, Match)
  • Use Nested Searches (Vlookup, Hlookup)
  • Financial Payment Functions (PMT, PPMT, IPMT)
  • Merge Different Data Types (Dollar, Text)
  • Advanced Text Splitting and Merging Techniques (Rept, Len, Search, Trim)
  • Auditing Functions (If, Iserror, Isna, Isblank, Isnumber)
  • Create a Pivot Table with Multiple Criteria
  • Look up and Database Functions

Module 3: Working with External Data

  • Database Query
  • Excel Query
  • Web Query
  • OLAP
  • XML

Module 4: Practical Techniques

  • Shortcuts
  • Practical Techniques in Functions and Data Analysis
  • Effective Solutions with Record Macros

Module 5: Security

  • Protect a Workbook, Worksheet and Cells
  • Provide Security in the Workbook
  • Document Encryption
  • Rights
  • Other Practice Examples
  • Highlight Duplicate Records
  • Highlight Unique Records
  • Highlight the Row that Meets Specific Conditions
  • Block the Reentering the Existing Records in the List
  • Sort out Duplicate Records
  • Turning Grouped Lists by Filling the Gaps into Excel Tables
  • Define Special Sorting Criteria in Lists
  • Design Dynamic Charts by Using Dynamic Names

Macro Excel

Excel Macros are programs written with the VBA (Visual Basic for Application) language. You can develop your custom applications correctly and in a very short period of time by using VBA codes in Excel. Normally when you are using available Features in Excel for your actions, you can reach a certain point but if you need to automatize these actions or want to run a few actions connected to each other, using macros would be the best solution. This way you can customize your work and do your long-time consuming tasks in a very short time.

Duration: 4 Days

Module 1: Overview of Macros

  • General Information about Macros
  • Macro Types, Saving Macros
  • Change Macro Options
  • Run Macros
  • Connect Macros to Objects
  • Edit Macros
  • Security in Macros
  • Create and Publish Numeral Signatures
  • Delete Macros
  • Overview of the Macro Codes

Module 2: Explore the Visual Basic for Application (VBA) Window

  • Toolbars (Debug, Edit, Standard, User Form)
  • Code Window Properties Window
  • Project Explorer Window
  • Module, User Form, Class Definitions
  • Procedure Definitions
  • Module 3: Operators
  • Arithmetic Operators
  • Modula Operators (^, *, /,\, +, -, &)
  • Comparison Operators
  • =, <>, ≤,≥, Like, Is Operators
  • Logical Operators
  • Not, And, Or, Xor, Eqv, Imp Operators

Module 4: Explore the Procedures

  • Sub Type Procedures
  • Function Type Procedures

Module 5: VBA Programming Structures

  • Variables and Variable Types
  • Range of Variables
  • Constants
  • Conditionals If… Then… Else…
  • Select Case… End Case
  • One-dimensional and two-dimensional Arrays
  • Loop Types
  • For…Next
  • For Each…Next
  • Do Until…..Loop
  • Do While…Loop
  • Goto Statement

Module 6: Introduction to Programming with Excel

  • Property, Method and Event
  • Select Cells
  • Select Rows
  • Select Columns
  • Select Rows of Selected Cells
  • Select Columns of Selected Cells
  • Select Full Cells Around the Active Cell
  • Find Out the Number of Selected Cells
  • Find Out the Number of Columns and Rows of the Selection
  • Find Out the Number of Selected Fields
  • Run a Formula in a Cell
  • Assign Value to a Cell
  • Assign Value to the Selected Cell
  • Automatically Fill Cells
  • Assign a Random Value to a Cell
  • Fill Target Cells with the Reference of Source Cells
  • Change Cell and Font Type

Module 7: Check Errors

  • Error Checking Statements
  • Error Codes and Their Meanings

Module 8: Functions

  • Create a Function
  • Assign Parameters to the Function Type Procedures
  • Create Custom Functions for Personal Reasons
  • Use Functions in Excel

Module 9: The User Form and its Functions

  • Create a New User Form
  • Form Properties
  • Form Events
  • Add Controls to Forms
  • Control Properties
  • Control Events

Module 10: VBA Practice Examples

  • Copy Tables between Pages
  • Conditional Formatting
  • Sorting
  • Create Subtotals
  • Create Charts
  • Create Pivot Tables
  • Create Data Entry and Query Form

Module 11: Excel – Access Relation

  • Active Data Object (ADO)
  • ADO Objects
  • Connection Object
  • Recordset Object
  • SQL Query Language
  • Move Data from Access to Excel

Excel Productivity Training

“Excel Productivity Training” is a special learning content considering the most frequent scenarios workers in the Finance, Budge-Reporting, Production, Planning, Business Development, Human Resources, Sales, Marketing, and IT departments face in the daily-used applications. You will learn the most important features in Excel, do your actions way faster and explore to ways that will increase productivity in your work life with this training.

Duration: 1 Day

Sequels: Excel Advanced, Excel Expertise, Excel Macro

*Sequel trainings are applied trainings and a placement test is done beforehand.

Module 1:

  • We do not need shortcuts; we need the shortest cut. What are the most useful shortcuts?
  • Create very long nested if formulas in one row with VLOOKUP!
  • Get rid of error messages like #N/A, #Div that pollute your Excel Tables
  • Convert values converted to text in calculation to numbers with (-)
  • Methods that increase performance in formulas
  • Create a Dependent Drop-Down List
  • Highlight whole row using Conditional Formatting
  • Highlight multiple cells in different field at once with format painter
  • Write values into blank fields you have filtered at once
  • Create New Custom Pivot Pages based on desired value in the PivotTable Report with one click!
  • Eliminate duplicate records in the table
  • Edit all the data in a row at once with Flash Fill
  • Quick Filtering and Writing Including Formula with Wildcard Characters (*, ?)
  • Learn quick formatting and custom formula structure by creating Dynamic Tables
  • Make Table Title Renew on every page
  • Prevent errors while printing the document
  • Define custom names for cells to use tables easier in formulas
  • Vertical/Horizontal pasting etc. with Pasta Special Options
  • Quickly fill reports with blank cells coming from other programs
  • Use mini charts
  • Encryption in Excel
  • Add Legends to Cells with Conditional Formatting in Tables
  • Select visible cells only
  • Limit the value entered in a cell by creating a Confirm Value rule with formula
  • Prevent scientific number problem while writing very long numbers
  • Display all formulas with one button to have a command of the document
  • Have a command of the document by displaying source of formula with the Watch Window
  • Quickly add date and time to cells
  •  Change the cell format without changing the number/date/text valus of cells with cell formatting codes! For example, adding spaces into phone number.
  • Make calculations in cells that contain errors like #N/A, #Name?
  • Meet the Power BI Reports!

MODULE 2: NEW FEATURES IN EXCEL!

  • Filter with automatically created buttons based on the data in tables *New
  • Use the map chart *New
  • Improvements of features that existed before but are way better now *New
  • Create relations between tables in PivotTable *New
  • Use Treemap Chart and Funnel Chart *New
  • Use the new Ifs formula instead of the Nested If Formula *New
  • Use Maxifs and Minifs *New
  • Use Textjoin instead of Concatenate in Office 365 *New
  • Recover not-saved workbooks *New
  • Quickly display the last saved file *New
  • Time grouping Date/Time Fields in the PivotTable like Quarter, Year, Month, Hour, Minute

*Module 2 will be explained as long as the company has the compatible MS Office version.

Advanced Excel

You can color your rows with your rules with Conditional formatting methods, add data entry rules to your cells and prevent incorrect data entry. You can make more comprehensive test with nester if functions. You can import data from a table and compare tables with the VLOOKUP function. You can shorten your functions with correct use of True-False statements. You can create report you want with just a few clicks by doing a detailed data analysis with Pivot Table, add filter buttons to your reports and charts filtered based on these buttons and thus make your reports impressive.

Duration: 2 Days

Module 1: Tables and Data Management

  • Shortcuts/techniques that allow you to navigate, choose and enter data quickly
  • Sort Based on Cell Value, Color, Alphabetic/Numeric/Custom Lists
  • Group and Outline
  • Filter
  • Use the Advanced Filter Feature
  • Use the Subtotal Function
  • Eliminate Duplicate Values in Lists
  • Data Merge

Module 2: Data Validation and Conditional Formatting

  • Apply Data Validation to Cells
  • Fix Excel Error Messages Concerning Data Validation
  • Highlight Cells with the Desired Color with Conditional Formatting Settings
  • Insert Symbols to the Cells with Conditional Formatting Settings
  • Use Formulas in Conditional Formatting

Module 3: Functions

  • Access Desired Values from Different Pages or Book with Look up and Database Functions (VLOOKUP, XLOOKUP, DSUM, DCOUNT, DAVERAGE, DMIN)
  • Create Conditional Formulas with Logical Functions (If, And, Or, Nested If, SUMIF, COUNTIF)
  • Use Logical Functions Special for Office 365 (Switch, Ifs, Maxifs, Minifs, TextJoin) *New Text Functions (Uppercase, lowercase, from Left, from Right, TextJoin, Crop)
  • Use the Quick Fill Tool

Module 4: Cooperation

  • Add and Delete Comments
  • Display and Print Comments
  • Share the Workbook and Co-author
  • Tracking options
  • Accept or Reject Changes

Module 5: What-If Analysis

  • Use the Watch Windows
  • Watch the Formulas

Module 6: Pivot Table and Pivot Chart

  • Create a Pivot Table
  • Edit a Pivot Table
  • Find Out the Percentage of the Values on the Pivot Table Based on Desired Criteria
  • Create Automatic Report Pages from the Pivot Tables Based on the Desired Criteria
  • Update the Pivot Table Database
  • Use Slicers
  • Exploring New Slicer Features Special for Office 365 *New
  • Create Custom Charts

Module 7: Distribution

  • Inspect Document
  • Mark as Final
  • Run the Compatibility checker
  • Add or Delete a Worksheet

Module 8: Security

  • Protect a Workbook, Worksheet and Cells
  • Provide Security in the Workbook
  • Encrypt a Document
  • Manage Permissions

Module 9: Macros

  • Create Macros
  • Save Macros
  • Edit Macros

Module 10: New Applications in the Reporting Fields

Define the Relation between Excel and Power BI *New

Discover the Potential of Reporting with Power BI Dashboards

PowerPoint

Basic PowerPoint

In this PowerPoint training, you will learn the basic rules you should pay attention to while presentation, how to add visual, auditory and graphical objects, use themes, see practices of applying formatting and editing settings and design impressive slides. You can add tables, charts, audios and videos to your presentations and learn how to edit them. Also, you can print slides in different formats and print it the way you want by learning printing settings. You can leave an impressive impression in your presentations by having control of the programs with what you have learned.

Duration: 1 Day

Module 1: Introduction

  • Use the Backstage Button
  • Use the Quick Access Button
  • Customize the Ribbons
  • Edit PowerPoint Options
  • Use the “Tell me what you want to do” feature *New
  • Display the older versions of the workbook *New

Module 2: Create a New Presentation

  • Create a Presentation with Templates
  • Analyze Slide Design Ideas
  • Create a Custom Presentation
  • Add and Edit a Text

Module 3: Display Presentations

  • Navigate Between Slides
  • Display Slides
  • Use the Slide Show Display

Module 4: Slide Essentials

  • Choose the Design Theme
  • Work with Text Boxes
  • Use Bullets and Numbers
  • Work with Tabs
  • Auto-correction Options

Module 5: Advanced Report Options

  • Use the Spell Check
  • Use the Synonyms & Lookup
  • Work with Speaker Notes
  • Add a Header & Footer
  • Print the Slides

Module 6: Work with Images and Shapes

  • Create a Photo Album
  • Use the Insert Tab
  • Insert ClipArt and Images to the Slides
  • Work with Automatic Shapes
  • Work with the Format Tab

Module 7: Work with Audio and Videos

  • Add Audio and Videos
  • Crop Videos
  • Add a Bookmark to a Video
  • Use Image Frame
  • Reduce the Presentation Size by Compressing Videos

Module 8: Work with Tables

  • Insert a Table to a Slide
  • Use the Table Tabs
  • Navigate and Choosing in a Table
  • Add and Delete Columns & Rows
  • Format the Table
  • Add an Excel Table to the Slide

Module 9: Outline

  • Add a Slide in the Outline View
  • Edit Slides in the Outline View
  • Send the Outline View to another Document

Advanced PowerPoint

You can create professional presentations with PowerPoint by bringing audio-visual expressions (audio, video, Charts, Images, Shapes, Smartart, 3D Objects) together and creating impressive animations and intriguing expressions. In addition to that, you can crate main templates that express your corporate identity, spice up your presentation with Smart Art, Morph and 3D Objects and leave a strong impression on the audience.

Duration: 2 Days

Module 1: Work with Animations

  • Use the Animation Tab
  • Insert Entry & Exit Animation
  • Add Emphasis
  • Use the Motion Paths
  • Edit the Animation Effects

Module 2: Duplicate and Arrange the Presentations

  • Copy and Delete Slides
  • Hide Slides
  • Rearrange Slides
  • Add Slide Transitions
  • Morph *New
  • Add 3-D Slide Transitions

Module 3: Manage the Slides

  • Add Slides from other Slides
  • Use the Find-Replace Feature

Module 4: Work with Charts

  • Add a Chart
  • Use the Chart Tab
  • Format and Resize a Chart
  • Connect the Power BI Charts *New
  • Explore the New Chart Types Special for Office 365 *New

Module 5: Word Art & Smart Art

  • Insert a WordArt Object
  • Create a List
  • Create Hierarchy
  • Create Pyramid
  • Modify SmartArt

Module 6: Work with Templates and Slide Masters

  • Create and Edit a New Slide
  • Add a Logo to Every Slide with Slide Master
  • Change the Title Font of Every Slide with Slide Master
  • Make Changes on Specific Slides with Slide Master

Module 7: Advanced Slide Options

  • Work with Action Buttons
  • Explanatory Notes for the Presentation
  • Use the Slide Timing
  • Slide Show Options
  • Record Audio Narration of the Slide Show

Module 8: Save the Presentation for Web

  • Save the Presentation as PowerPoint Show
  • Save the Presentation as PDF
  • Publish the Presentation on Web
  • Package the Presentation for CD
  • Save the Presentation as Video

Module 9: Cooperation

  • Access to OneNote Documents and Giving a Link *New
  • Track, Accept and Reject Changes on the Document
  • Compare with Different Presentations
  • Add, Display and Edit Comments
  • Work Synchronously on the Same Document with OneDrive *New
  • Document Protection: Restrict Editing *New
  • Co-author on Slides by Sharing the Presentation *New

Module 10: New Features with Office 2016 and Office 365

  • Add an Ink Equation and Symbols *New
  • Other Features on the Draw Tab *New
  • Work with 3D Models *New
  • Design Ideas *New
  • Auto-save *New
  • Use the Transformation from Ink to Shape Feature *New
  • Align with the Ruler *New
  • Use the 3D Objects with the Morph Effect *New
Outlook

Basic Outlook

You can easily learn how to do your e-mail actions with Outlook and comprehend options like formatting, adding a file, editing, searching for a post, responding, and printing. You can learn what expressions like Contacts, Calendar, Tasks mean and how to use them with practices. You can assign yourself a task and organize meetings in your company. Also, you can customize your Outlook by using the View Tab.

Duration: 1 Day

MODULE 1: EXPLORE THE OUTLOOK PROGRAMS

  • Explore the Outlook Screen
  • Arrange Outlook Menus
  • To-Do Bar
  • Use the “Tell me what you want to do” Feature *New

MODULE 2: PRIMARY E-MAIL ACTIONS

  • Create and Send an E-mail Message
  • Use the Message Tab
  • Save Messages as Draft
  • Add a File to the E-Mail Message
  • Read the Messages
  • Display the Attachments
  • Respond and Forward Messages

MODULE 3: FORMAT THE E-MAILS

  • Use the Format Text Tab
  • Use the Quick Format Mini Toolbar
  • Mark Important Messages
  • Use the Find and Replace Tab

MODULE 4: USE THE CONTACTS SECTIONS

  • Add and Edit a Contact
  • Use the Contact Tab
  • Add a Contact from an E-mail Message
  • Send a Message on the Contact View
  • Create and Use a Distribution List
  • E-Mail Addresses, Send & Receive Options

MODULE 6: MANAGEMENT OF THE E-MAILS

  • Delete a Message
  • Empty the “Deleted Items” File
  • Rename a File
  • Move-Copy Messages and Files

MODULE 7: PRINT E-MAIL MESSAGES

  • Use the Print Windows
  • Print a Table etc. in a Short Note
  • Print Files with Attachments

MODULE 8: MANAGING CONTACTS

  • Find and Sort Contacts
  • Edit and Delete Contacts
  • Print Contacts

MODULE 9: CREATE A TASKS LIST

  • Analyze the Outlook Calendar
  • List the Tasks
  • Assign Categories to Tasks

MODULE 10: ARRANGE A MEETING

  • Respond to a Meeting Invitation
  • View Calendars on Top of One Another
  • Recommend a New Meeting Time
  • Track Meeting Responds
  • Update – Cancel a Meeting Invitation
  • Printer and Calendar

Advanced Outlook

You can do your e-mail actions, move your e-mails to files and to these moving actions with automatic rules with Outlook. Also, you can track appointments and organize meetings by using the calendar. You can add reminders to use your time more efficiently on Outlook, learn how to use categories, how to archive and move -emails and create auto-responds for when you are not at work. In addition to all these, you can work with shaped and images, and customize your Outlook.

Duration: 2 Days

MODULE 1: E-MAIL ACTIONS

  • Sort Messages by different criteria
  • Filter Messages by Multiple Criteria
  • Filter Messages
  • Edit Messages
  • Unimportant E-Mail Options
  • Create and Arrange Rules
  • Edit and Delete Rules
  • Use Conditional Formatting
  • Grouping Options

MODULE 2: ARRANGE THE MESSAGE OPTIONS

  • Change the Message Options
  • Change the Message Format
  • Use the Out of Office Assistant (Automatic Replies)
  • Add “Hyperlinks” to Messages

MODULE 3: ARCHIVE OPTIONS

  • Archive the Messages
  • Manually Archive the Messages
  • Automatically Archive the Messages

MODULE 4: ARRANGE THE CALENDAR OPTIONS

  • Arrange Workdays and Hours
  • Display the Extra Time Fields
  • Arrange the Compliance Options
  • Share and Publish the Calendar

MODULE 5: TRACK DAILY WORK ACTIVITIES AND RSS

  • Auto-save Daily Entries
  • Manually Save Daily Entries
  • Change Daily Entries
  • Use RSS

MODULE 6: TASK MANAGEMENT

  • Assign Tasks
  • Respond the Task Assignment Message
  • Send a Task Update
  • Forward Task Assignments

MODULE 7: USE PERSONAL FILES

  • What Are Personal Files
  • Create Personal Files
  • Move and Copy Messages

MODULE 8: WORK WITH SHAPES AND IMAGES

  • Use the Insert Tab
  • Insert ClipArt and Images
  • Automatic Draw
  • Use the Format Tab
  • Layer the Objects
  • Add a WordArt Object
  • Add a SmartArt Chart

MODULE 9: CUSTOMIZE OUTLOOK

Work with the Quick Access Toolbar

Customize Toolbars

Access

Basic Access

Access is a database program developed by Microsoft. In our training, you will explore the Access interface first and then learn database, table, field, data type and relation notions with practices. You will learn how to add records, search, delete and how to exchange data between different platforms with database. Also, you will learn the basic rules to be careful about in managing the database and actively use table, query, form and report concepts.

Duration: 2 Days

Module 1: Overview of Access

  • Access and Relational Databases
  • Access Environment
  • Use Office Desktop
  • Database Components
  • Use the Navigation Pane
  • Use Help
  • Start and Stop the Access Database

Module 2: Create a Database

  • Data Types
  • Create a Table in Datasheet View
  • Create a Table in Design View
  • Arrange Field Settings
  • Determine a Primary Key
  • Explore the Datasheet
  • Arrange and Choose Table Data
  • Add and Delete a Report
  • Find and Replace
  • Undo and Renew
  • Relation Types
  • Print Relations
  • Sort Records in the Table

Module 3: Share Data

  • Import Excel Files to access
  • Copy the Table Structure and Data

Module 4: Query and Filter Options

  • Use Filters
  • General Filter
  • Apply Filters Based on a Selection
  • Advanced Filter
  • Differences between Query and Filter
  • Create a Query with the Simple Query Wizard
  • Create a Query in Design View
  • Add Criteria to a Query
  • Add a Calculated Field
  • Group the Data
  • Use Parameters in Query
  • Types of Joins

Module 5: Forms

  • Create an Automatic Form
  • Create a Form with the From Wizard
  • Use the Design View
  • Add Controls to the Form
  • Use the Toolbar
  • Add a Textbox
  • Add Labels
  • Add an Option Button
  • Add a Check Box
  • Add a Combo Box and Drop-Down List
  • Add a Calculated Field
  • Add Graphical Objects
  • Create a Subform

Module 6: Reports

  • Create Automatic Reports
  • Create a Report with the Wizard
  • Create a Report in Design View
  • Format Controls
  • Add Date and Time
  • Add Page Numbers
  • Add Graphical Objects
  • Group Reports
  • Sort Reports
  • Use Page Break
  • Create Calculated Controls
  • Print the Report

Advanced Access

Participants will manage the databases correctly by using features of Access, connect with the other programs and exchange data, use advanced query techniques and learn advanced database features and use them. Also, they will be able to create advanced forms and reports, write Sql queries. In addition to this, you can learn how to use macros in Access.

Duration: 2 Days

Module 1: Advanced Table Properties

  • Field Properties
  • Use Input Masks
  • Use the Totals Row on Datasheet
  • Use Rich Text Format in the Memo Data Type
  • Connect Tables
  • Use Linked Table Manager
  • Share Data with Other Office Programs

Module 2: Import Data

  • Import Tables
  • Import XML Data to Access
  • Import Data from a Sharepoint List
  • Import Data from Excel
  • Import Data from a Text File

Module 3: Use Advanced Query

  • Create a Calculated Field
  • Find Duplicates
  • Create a Crosstab Query
  • Action Queries
  • Update Query
  • Append Query
  • Make Table Query
  • Delete Query

Module 4: Advanced Form Options

  • Use Field List Pane
  • Use Form Controls
  • Add and Format Labels
  • Add Charts
  • Add a Command Button
  • Use the Label Wizard
  • Add a Combo Box Field

Module 5: Advanced Report Options

  • Use Report Controls
  • Work with Page and Report Width
  •  Arrange Field Properties
  • Add Charts
  • Put Report Data in Two Columns

Module 6: Advanced Database Properties

  • Database Documenter
  • Analyze the Performance of the Database
  • Change the Version of the Database
  • Compact and Repair a Database
  • Backup a Database
  • Split a Database
  • Convert Access Database to MDE File
  • Create a Switchboard
  • Edit a Switchboard
  • Create a Database Password

Module 7: Macros

  • Create a Macro
  • Run a Macro
  • Create and Run a Group Macro
  • Create a Macro with a Condition
  • Assign Macros to Command Buttons
  • Use Macros on Menu Options
penta
kalyon
hayat
ford
evyap

Contact Us

Start typing and press Enter to search

X