MS Excel Training
We offer more than 12 days of instructor-led Microsoft Excel courses, both in-person and in a virtual classroom environment.
Our Excel courses include the following (click the course name to view the full course details):
Microsoft Excel: Introduction >
Microsoft Excel: Intermediate / Advanced >
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools >
Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction >
Microsoft Excel: Introduction to Power Query to Get and Transform Data >
Microsoft Excel: Essential Features and Functions in Excel 365 >
You may like
How to Insert or Type O with an Accent Mark in Word (Ò, Ó, Ô, Õ, Ö, ò, ó, ô, õ or ö)
You can insert or type o with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter o can be inserted with an accent in both upper or lower case. The following are common accents in upper or lower case – Ò, Ó, Ô, Õ, Ö, ò, ó, ô, õ or ö.
How to View Document Statistics in Microsoft Word
Microsoft Word automatically tracks statistics about your documents. These statistics appear in Word Properties and include the file name, directory, template, author, editing time, last print date and the user who last modified the document.
How to Create a Table Template in Word
If you insert tables frequently in Word, you may want to create a table template to save time. Keep in mind that tables are affected by themes, styles and table styles so if the table template you insert seems to change formatting, the current document may contain different formatting from the original document when the table template was saved. A table template is saved as a building block and will appear in Quick Tables.
How to Delete a Page in Word (Remove Blank or Extra Pages)
In Word, you can delete a page in the middle or at the end of a document using several strategies. You can delete blank pages or pages that contain text and other content. Blank pages can be caused by unnecessary hard returns (pressing Enter too many times), manual page breaks, section breaks, paragraph formatting and tables so you will need to determine what is causing a blank page to remove it.
How to Clear Formatting in Word (with Shortcuts)
You can use keyboard shortcuts or the Ribbon to clear formatting in a Word document. Since there are two types of text formatting (character and paragraph), you can choose to clear all formatting or just character or paragraph formatting. If you want to clear formatting for text where a specific style has been applied, you'll need to select the text that uses the style first and then remove the formatting.
4 Ways to Delete a Table in Word
You can delete a table in a Word document in 4 simple ways – using the Ribbon, using the context menu, using the Backspace key or by selecting a paragraph and a table and pressing Delete.
How to Make Columns in Word
You can make columns in Word documents in a few different ways. There are two types of columns you can create – newspaper-style columns where the text flows from column to column or tables with columns and rows. You can create documents that contain two, three or more columns. In this article, we'll review how to set up newspaper-style columns. If you want to create a table, check out How to Create a Table in Word (4 Ways).
4 Ways to Create a Table in Word
You can create a table in a Word document in 4 easy ways using the Ribbon. A table is a grid made up of columns and rows that intersect to form cells. You can insert text, numbers and images in a table. Once you have inserted a table, you can easily add and resize columns and rows and change table formatting.
How to Insert or Type E with an Accent Mark in Word (È, É, Ê, Ë, è, é, ê, or ë)
You can insert or type e with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter e can be inserted with an accent in both upper or lower case. The following are common accents in upper or lower case – È, É, Ê, Ë, è, é, ê, or ë.
How to Change Case in Word (Upper, Lower, Title or Sentence Case)
You can change case in Microsoft Word documents using formatting commands or by converting case. If you want to be able to easily change case (like removing All Caps), it's best to change case using the Font dialog box. If someone has created upper case text using hard capitals where they have pressed the Caps Lock key and typed the text, then you can convert case using the Change Case command.
3 Ways to Insert or Type the Euro Symbol in PowerPoint (€)
You can insert the euro sign or symbol (€) in a PowerPoint presentation using built-in PowerPoint commands or keyboard shortcuts (Alt code or AutoCorrect shortcuts).
How to Modify Table of Contents Formatting in Word
If you have created a custom or automatic table of contents (TOC) in a Word document, you can add heading levels to the TOC. You can add or edit levels using built-in heading styles or use custom styles as levels.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca