ANS Software Solutions is pleased to launch our new E-Library.
Learn MS Word from Beginner to Intermediate.
This course covers 21 topics and includes practical assignments:-
What is Word? - Click here for sample video
Use Word on a mobile device
Create a document, use templates, and save
Open, view, and close documents
Convert a PDF to a Word document
Add and edit text
Apply Quick Styles and Themes
Create and change styles
Save documents in PDF and other formats
Get to know mail merge
Use an Excel spreadsheet for mail merge contacts
Use Outlook contacts for mail merge
Add and remove page breaks
Add a section, header, or footer
Select a theme and style
Change the margins in your document
Check word counts in documents
Track changes and show markup
Accept or reject changes
Convert text to a table
Convert a table to text
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS Excel from Beginner to Intermediate.
This course covers 44 topics and includes practical assignments:-
What is Excel? - Click here for sample video
Create a workbook
Add, delete, or rename sheets
Hide or unhide columns
Freeze top and left panes
Move or copy worksheets
Apply themes to change the look of a workbook
Add and edit data
Resize and merge cells and align data
Format numbers in cells
Change the look of cells
Copy cell formatting
Select cell contents
Move or copy cell contents
Insert or delete rows or columns
Resize rows and columns
AutoFill time spans
Split and combine data
Build custom numeric formats
Validate cell data
Create reusable lists
Create formulas
Name cells and ranges
Use Trace to fix formula errors
Locate functions
Calculations using functions
Create and format tables
Sort data in a table
Filter data in a table
Add a Total row to a table
Filter data with slicers
Create charts
Format charts
Add sparkline charts
Add trendlines and drop lines
Quick Analysis of data
Create PivotTables
Work with PivotTables
Group data in PivotTables
Filter data with Slicers in PivotTables
Create PivotCharts
Share workbooks
Add and review comments
Password-workbooks
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS PowerPoint from Beginner to Intermediate.
This course covers 39 topics and includes practical assignments:-
What is PowerPoint? - Click here for sample video
Change views
Build presentations from templates
Create presentations from scratch
Add and delete slides
Select and apply slide layouts
Add text to slides
Format lists on slides
Check spelling in your presentation
Add math to slides
Import a Word outline into PowerPoint
Add hyperlinks to slides
Add SmartArt to a slide
Add WordArt to a slide
Add images to slides
Add screenshots to slides
Format images on slides
Apply themes to presentations
Create, merge, and group objects on a slide
Align and arrange objects on slides
Layer objects on slides
Change slide masters
Organize slides into sections
Add footers to slides
Add transitions between slides
Get design ideas for slides
Use Slide Show and Presenter View
Add speaker notes
Practice and time your presentation
Print presentations
Record presentations
Add and record video
Add and record audio
Add and format video
Add animations to slides
Add Excel tables to slides
Save presentations as videos
Remove sensitive information from your presentation
Add and review comments in your presentation
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS Access from Beginner to Intermediate.
This course covers 25 topics and includes practical assignments:-
What is Access? - Click here for sample video
Get started with databases
Get to know database objects
Decide whether to create a desktop database or an Access web app
Create an Access desktop database
Access web app
Build tables and set datatypes
Build tables with Table Designer
Combine fields using the calculated data type
Get started with table relationships
Create relationships with the Lookup Wizard
Create relationships with the Relationships Pane
Create many-to-many relationships
Create one-to-one relationships
Copy data from Excel
Link to shared data
Get started with queries
Create basic queries
Create queries with more than one data source
Create queries with outer joins
Query unrelated data sources
Create navigation forms
Create basic reports
Modify and print reports
Back up databases
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS Outlook from Beginner to Intermediate.
This course covers 44 topics and includes practical assignments:-
What is Outlook? - Click here for sample video
Add email accounts
Import Gmail into Outlook
View email
Create and send email
Sent file attachments with email
Reply to or forward email
Open, preview, or save email attachments
Send automatic reply email
Retract or replace a sent email
Add signatures to emails
Add attachments and hyperlinks to emails
Design personal stationery
Save and reuse email content
Clean up your Inbox
Block unwanted mail
Set an email flag, reminder, or color
Organize email by using folders
Search and filter email
Organize your Inbox with rules
Manage contacts
Organize contacts into categories
Create and use contact groups
Manage contact lists
Import contacts
Export contacts
Use Outlook contacts for mail merge
Recover deleted contacts
Search for calendar items
Email, share, or print your calendar
Open and view multiple calendars
Create calendar groups
Import a Google calendar
Assign a delegate to manage your calendar
Schedule appointments
Schedule an online Skype for Business meeting
Manage recurring meetings
Attach a file to a meeting invitation
Take Outlook meeting notes using OneNote
Create, assign, and complete tasks
View tasks and your to-do list
Create and conduct email polls
Schedule and organize meetings
Share your calendar with other people
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS Excel VBA from Beginner to Expert.
This course covers 28 topics and includes practical assignments:-
What is VBA? - Click here for sample video
Object Oriented Programming Languages
Turning on the Developer Tab
The Macro Recorder
Using Relative References
Recording Simple Macros
Multi-Step Macro Recording
Sort and Filter Macro Recording
Protecting and Formatting Sheets with the Macro Recorder
VBA Interface Setup
Recorder Code vs. Manual Code
Introduction to Editing Macros
Debugging Macros
Grammar in VBA
Macro Scripting Basics
Range
Selection & Color
Value and Clear
ActiveSheet, Sheets, and Name
CurrentRegion
Worksheets Methods
DateSerial and Format
Sheet Template Generator
Move
PrintOut and PrintPreview
Custom Functions (Part 1)
Custom Functions (Part 2)
Custom Functions (Part 3)
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS Forms from Beginner to Intermediate.
This course covers 8 topics and includes practical assignments:-
What is Forms? - Click here for sample video
Create a form in Microsoft Forms
Share a form in Microsoft Forms
View results in Microsoft Forms
Share and collaborate
Format Forms
Integration
Admin tasks
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS Publisher from Beginner to Intermediate.
This course covers 10 topics and includes practical assignments:-
What is Publisher? - Click here for sample video
Make cards and brochures
Build newsletters
Work with calendars and templates
Get a word count in Publisher
Basic formatting
Work with pictures
Work with watermarks
Work with borders, backgrounds, and columns
Print and mail
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS OneNote from Beginner to Intermediate.
This course covers 17 topics and includes practical assignments:-
What is OneNote? - Click here for sample video
Start using OneNote
Take notes
Insert pictures, files, and videos
Create more room in your notebook
Format notes
Format pages
Insert and format tables
Draw and sketch
Create shapes
Search and find notes
Organize your notebooks
Share your notes with others
Password-protect private notes
OneNote on iOS
OneNote for Android
OneNote Online
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn MS Teams from Beginner to Intermediate.
This course covers 45 topics and includes practical assignments:-
What is Microsoft Teams? - Click here for sample video
Get your team up and running
Go-to guide for team owners
Organize your teams list
Overview of teams and channels
Create and use private channels
Show and hide channels
Work in channels
Work on a file together
Tip: Send email to a channel
Create a plan with Planner
Create and format a post
Post a message to multiple channels
Get attention with @mentions
Save a post or a message
Upload and share files
Find and filter files
Start and pin chats
Make calls
Hide chats, delete messages
Set up a delegate to take your calls
Join a Teams meeting
Create instant meetings with Meet now
Tip: Meet in a channel
Manage meetings
Show your screen during a meeting
Tip: Show PowerPoint slides
Move around during a Teams meeting
Plan and schedule a live event
Produce a live event
Attend a live event
Moderating a Q&A
Use apps
Tip: Turn a file into a tab
Use the command box
What is Shifts?
Create a Shifts schedule
Manage a Shifts schedule
Filter your activity feed
Manage notification settings
Activity feed on the go
Join a meeting on the go
5 things to do first with Teams (free)
Invite people to Teams (free)
Upgrade from Teams (free)
Cost
Access to Virtual Classroom Content - Free
Online Live Tuition - TTD$300 | USD$45 per hour
Learn Graphic Design from Beginner to Intermediate.
This course covers 8 topics:-
What is Canva? - Click here for sample video
Design
Branding
Marketing
Tool set
Video
Collaborate with Others
Templates
Duration 6 hours
Cost
Online Live Tuition - TTD$900 | USD $135
In person tuition - TTD$1500.00 | USD $225
Learn Graphic Design for Beginners.
This course covers 8 topics:-
What is Canva? - Click here for sample video
Images
Elements
Text
Audio
Video
Collaborate with Others
Templates
Duration 6 hours
Cost
Online Live Tuition - TTD$600 | USD $90
In person tuition - TTD$1200.00 | USD $180 Trinidad only