TRAINING PROVIDES COMPREHENSIVE AND NECESSARY BASIC SKILLS FOR EFFECTIVE DAILY USE IN EXCEL

Although most of us are working with Excel, there are many things that are missing knowledge and have not been clear on our own. In Training, you may be repeatedly thinking that “… I would have known it before! “.

Training is highly appreciated by both beginners and long-term Excel users.

We have prepared the test you can use for recognize how much do you need the Excel Basic Course. 

---

BASIC EXCEL TRAINING TOPICS

OPEN, CREATE, CLOSE, AND SAVE AN EXCEL WORKBOOK

Options and quick commands of open and close the workbook
Create a workbook as blank and use templates
Options for saving a workbook, including protecting opening or changing by password. Choosing a default folder for save and open documents

EXCEL TOOLS
Show menus and commands
Excel Help
Use the Quick Command Bar to work more efficiently
How to set views of document, including changing the view with mouse
Move between Documents and open programs using the keyboard

EXCEL TABLE, MARKING AND NAVIGATING
Excel table structure, cell coordinates
Use the Name Box to move around the table and mark the cells
Marking columns, rows and cells with a mouse and keyboard
Move and mark cells in a table by using the Ctrl and Shift keys

ENTERING DATA AND FORMAT CELL IN EXCEL
Entering and formatting texts
Wrapping lines
Change column width and row height based on text length and size
Merge cells
Use of the indent in cells
Entering numbers and use AutoFill
Show decimal places
Number formats, including creating a new format code
Enter the date and use date formats, including displaying the days of the week in the
cell
Enter time and use time formats
Use the Format Painter

EXCEL FORMULAS AND FUNCTIONS
Creating formulas by right way
SUM, AVERAGE, COUNT(A), MAX and MIN functions
Copying formulas by using AutoFill
Display and read function responses in the Status Bar
Relative and Absolute referencing
Use data from other worksheets in formulas
Use data from other workbooks in formulas

WORK WITH WORKSHEETS IN EXCEL
Move, copy and delete worksheets
Renaming and changing the tab color
Hiding and unhiding
Change content at the same time in different worksheets

ACTIONS WITH COLUMNS, ROWS, AND CELLS IN EXCEL
Insert, delete, and move columns, rows, and cells
Hiding and unhiding columns and rows
Grouping and ungrouping columns and rows

DISPLAY OPTIONS OF WORKSHEET AND WINDOW IN EXCEL
Freeze rows and columns
Split a table view
Open same workbook in multiple windows
Auto-matching open workbooks in screen

PASTE OPTIONS IN EXCEL
Paste content and cells format
Preserve and remove formulas when pasted
Preserve and remove formatting when pasted
Paste as a Link
Pasting as a picture
Exchange rows and columns as a paste option

FORMAT CELLS AND TABLES IN EXCEL
General formatting tools and more detailed options
Use ready-made Cell Styles and save new ones
Use Conditional Formatting to format cells automatically based on content
Meaning of Format As Table command. New tools we have if to use Format As Table

UNDO AND REDO ACTIVITIES IN EXCEL
Undo and Redo commands in the menu, keyboard shortcuts
Undo and redo to multiple actions at once
How to undo activities when working with multiple workbooks the same time

SORTING AND FILTERING IN EXCEL
Using the sorting tools
Using the filtering tools, including number, date and text filters
Reapply filters for new added rows

FIND AND REPLACE DATA IN EXCEL
Tools for finding and replacing cell contents, main and advanced options
Find and replace formatting in cells

WORK WITH COMMENTS IN EXCEL
Add, edit or delete comments
Difference of comments and notes in new Excel versions
Display all comments or one by one
Print comments

ADDING PICTURES AND GRAPHIC OBJECTS IN EXCEL
Add, change, and manage pictures and graphics elements
Using a background picture

ADDING CHARTS AND SPARKLINES IN EXCEL
Choosing chart style according to source data
Change the source data and move the chart
Change chart style and items to show
Use templates when designing new charts
Add sparklines and sparkline options

SPELL CHECK IN EXCEL
Specify the spelling checker area
Options for accepting and rejecting corrections
Manage dictionaries and auto correct options

PRINTING IN EXCEL
Different layouts and page break views
Print the top row(s) and left column(s) on all pages
Specify a printing area
Manage header and footer

EXCEL MACROS TRAINING WLL CHANGE YOUR LIFE AND SAVES SO MUCH YOUR WORKTIME.

In the Macros training you can learn step by step all about macros from very basic to deep level. It is totally suitable and affordable training for everyone who is interested in about using macros to make a life more easy.

---

EXCEL MACROS TRAINING TOPICS

GETTING STARTED

SUMIF function
Introducing macros and giving samples of macros
Attention! Can’t use the Undo command
Macro Training versus VBA Programming Training

CREATING AND SAVING A MACRO
Macro recording options
Naming, choose location and describing a macro
Saving the workbook with a macro
Absolute and relative references
Record and save a macro as a part of a workbook
Record and save a macro as a part of my Excel (1)
Record and save a macro as a part of my Excel (2)

USING MACROS
Distinguishing a workbook with a macro from a usual Excel workbook
Available macros in a open workbook
Options to open a window with a list of macros
Changing or deleting a macro in the macros list window
Running a macro with a keyboard shortcuts
The keyboard shortcut for pasting values only
Running a macro on the quick access toolbar
Running a macro with the toolbar from a menu
Running a macro with a button, a shape or an image
Editing security settings of using files with a macro

VISUAL BASIC EDITOR
Visual Basic Editor (VBE)
The layout and elements of the VBE
Arranging macros in the VBE

GETTING TO KNOW MACROS CODE
Getting to know Macros code
Testing parts of a macro
Testing changes in a macro code
Cleaning a code
Supplementing the VBE toolbars ribbon
Following how the code is created during recording a macro
Relative reference in a macro code

WORKING WITH THE MACROS CODE
Creating a macro in VBE
Referencing cells by a size of a table
Referencing ranges by a size of a table
Referencing in a table with a empty cells
Using a shorter code
Samples about replacing references in a macro code
Repeating a part of a macro by Do Loop and For Loop
Using IF statement in a macros code
Blocking and adding a pop-up window
Adding a pop-up window as a input box
Searching a code from the web and adding a new function

EXTRAS
Fixing macros code of a Pivot Table
Solve the problem with a Personal Macros Workbook
Protecting macros

POWER QUERY IS REALLY POWERFUL WORKTOOL YOU JUST HAVE TO KNOW WHAT IS IT FOR

With Power Query we can collect data from separated tables into one table. So we can continue filling separated tables and still analyse all data as one whole database. It is also good worktool for importing data from other files  so that we can transform data first time we import data and later all transforming steps will be done automatically.

---

POWER QUERY TRAINING TOPICS

Why to use the Power Query?
Power Query in the different Excel versions
Merge columns and get data from tables
Merge columns and get data from files
Editing the combined table
Refreshing data in the combined table
Changing setting of source data
More options to merge columns
Append rows and create new queries from the table
Append rows and create new queries from files
Unpivot columns
Add new tables into combined queries
Creating the combined table from a folder
Organizing queries and create tables from queries
Spliting data to columns
Adding the conditional column
Using formulas in the Power Query
Clean tables with the Power Query
Import and transform data from a csv file
Import and transform data from a pdf file