Microsoft Office Courses Online

About

This course aims to be a comprehensive reference for the use of Microsoft Office for Windows, Microsoft Office for Mac, and Microsoft’s Office Online and Office 365 services.

While this course doesn’t teach basic computer skills or general Windows or OS X usage, it will cover a few core techniques that complement the use of Microsoft Office. In addition, many of the concepts in this course can be applied to other office packages; however, please note that the Microsoft Office user interface is relatively unique, so if you use another office package, you’ll need to find ways of performing the same task that work in that program.

Content

• Computing Basics
• Word
• Excel
• Access
• Powerpoint
• Publisher

About

This course covers a collection for scripting Microsoft Word using Visual Basic for Applications.

Contents

• Overview
• Part 1: Macros
  •  Creating a file under directories
• Macro Recording
• Text Editing
• Moving Cursor
• Selecting
• Formatting
• Copying and Pasting
• Clipboard
• Various
• Related Courses

About

VBScript, short for Visual Basic Scripting Edition, is a Microsoft-supplied scripting language similar to Visual Basic and Visual Basic for Applications. It can be used via Windows Script Host (WSH) as a Windows scripting language. Furthermore, it can be used as a client-side scripting language in web pages instead of JavaScript, but such pages will only work with Internet Explorer. Moreover, it can be used for server-side web scripting as part of Active Server Pages (ASP), and in other environments.

This course focuses on the language use via WSH.

Contents

1    Data types
2    File operations
3    Excel
4    Constants
5    Clipboard
6    External processes
7    Regular expressions
8    Versions
9    Comparison to VBA
10    COM components
11    Related courses

This course is intended for those who have an existing interest in VBA coding. It provides working code. Many of the procedures have good generality, for example, code for logging data, returning a file address, hashing, and others.

In most cases the code can be copied into a standard VBA Excel module, though in many cases will work in other Office applications, with or without slight modification.

Contents

1    Introduction
2    VBA Editor Settings
3    Selecting Long Listings
4    Interest Areas
4.1    Arrays (1D) for Characters
4.2    Arrays (2D)
4.3    Charts
4.4    Clipboard
4.5    Codes and Ciphers
4.6    Error Handling
4.7    Files and Folders
4.8    Fonts and Formats
4.9    Games
4.10    Hashing Strings and Files
4.11    Logs and Text Files
4.12    Message and Input Boxes
4.13    Numbers
4.14    Range
4.15    Sorting
4.16    Sound
4.17    Statistics
4.18    String and Array Shuffles
4.19    Text Backup and Validation
4.20    Times, Dates, and Waits
4.21    User Forms
4.22    VBA Editor Projects
4.23    Viterbi Project
4.24    Procedures for MS Word
4.25    Worksheet Transfers
4.26    Worksheet Utilities
4.27    ASCII Log Data from LAS File
5    Related Courses

Contents

1    Introduction to Spreadsheets
2    Anatomy of a spreadsheet
3    Inputting and Manipulating Data in Excel
3.1    Using formulas
3.2    Performing Operations on Groups of Cells
3.3    Special Functions in Excel
3.3.1    Mathematics Functions
3.3.2    Statistics Functions
3.3.3    Programming Functions
4    Solving Equations in Spreadsheets: Goal Seek
5    Graphing Data in Excel
5.1    Scatterplots
5.2    Performing Regressions of the Data from a Scatterplot
6    Further resources for Spreadsheets

Contents

1    Before you start
2    Getting ready
3    Checking the functionality
4    Checking the logic
5    Identifying the risk factors
6    Checking the inputs
7    Checking the calculations
8    Running tests
9    Reasonableness tests
10    Test in chunks
11    Spreadsheet testing tools
12    Is it usable?

Contents

1    Excel spreadsheet to XML
    1.1    Converting the spreadsheet
    1.2    Creating an XML spreadsheet from scratch
    1.3    Export from XQuery to Spreadsheet
    1.4    Reading and Writing XML Spreadsheet 2003 Format

This course summarizes information from many sources in one place and presents the information in a format to help a decision maker see the financial "big picture" for the company. Over half of financial management reporting is performed with spreadsheets.

Because of the ease of use, flexibility, and power of spreadsheets, they support many critical business functions and often fill roles where other solutions would be too slow or costly to implement. Years ago accountants and payroll specialists used to input all of their information into long hardcopy documents. Now companies can get the work done with half the amount of staff.

Application Software is a single or group of programs that allow access for specific tasks to be performed. Users of a computer should familiarize themselves with the variety of applications that are available. The purpose of computer applications is that it can greatly simplify a task for a user. Applications can help create and modify word processing, spreadsheets, databases, presentations, along with graphics and multimedia. 

Contents

1    Application Software Basics
    1.1    Installed vs. Web-based
        1.1.1    Advantages and Disadvantages
    1.2    Creating Application Software
    1.3    Software Ownership
2    Software Suites
3    Word Processing
    3.1    Constructing a Word Processing Script
    3.2    Word Processing Tools
4    Spreadsheets
    4.1    What is a Spreadsheet
    4.2    Tables, Graphics, and Templates
    4.3    How to use a Spreadsheet
        4.3.1    Charts
        4.3.2    Functions
        4.3.3    Formulas
        4.3.4    Cell Referencing
        4.3.5    Pivot Tables
5    Database
    5.1    Queries and Reports
    5.2    Deciding Which Database to Use
    5.3    Database Protection
6    Presentation Graphics
    6.1    Intro to Presentation Software
    6.2    Powerpoint
    6.3    Inside Scoop on New Presentation Software
7    Graphics and Multimedia
    7.1    Graphic Software
    7.2    Audio Capture and Editing Software
    7.3    Video Editing and DVD Authoring Software
    7.4    Media Players
    7.5    Graphics, Multimedia, and the Web
    7.6    Other Types Of Application Software
8    Review
    8.1    Key Terms
    8.2    Accessibility Software
        8.2.1    Visual Aid Software
    8.3    Review Questions

This course will list, compare and discuss the degrees of openness and/or lack of openness of several popular file formats. These include file formats for the following application areas:

1. office applications
2. graphics
3. audio
4. video

Contents

1    Office Applications File Formats
    1.1    Microsoft Office Formats
    1.2    OpenOffice.org and StarOffice Formats
    1.3    Adobe's Portable Document Format
2    Graphics/Image File Formats
    2.1    GIF
    2.2    PNG
    2.3    XPM
    2.4    TIFF
    2.5    JPEG JFIF
    2.6    SVG
3    Audio File Formats
    3.1    WAV
    3.2    FLAC
    3.3    MP3
    3.4    WMA
    3.5    AAC
    3.6    RealAudio
    3.7    Ogg Vorbis
4    Video Formats
5    Video Containers
    5.1    AVI
    5.2    ASF
    5.3    MOV
    5.4    MP4
    5.5    Ogg
6    Video Compression formats
    6.1    MPEG Compression formats
    6.2    MPEG-1 Part 2
    6.3    MPEG-2 Part 2
    6.4    MPEG-4 Part 10 (H.264/AVC)
    6.5    Sorensen
    6.6    Windows Media Video
    6.7    Theora

Command line in MS-DOS begins with a machine-generated prompt and then is implied to be filled with symbols and words which altogether must be suitable for machine interpretation according to certain syntax conventions. The final ENTER keystroke initializes interpretation of command line by a resident program — the command interpreter. Implementation of syntax conventions by different interpreters is not just the same.

MS-DOS 7 provides 3 interpreters: IO.SYS, COMMAND.COM, and DEBUG.EXE. Each interpreter accepts its own set of commands.

Contents

1     Named objects and their names
    1.1     Reserved words
    1.2     Names and suffixes
    1.3     Filemasks and wildcards
2     Paths
    2.1     Typical path structure
    2.2     The PATH variable
    2.3     Dot(s) in path specifications
3     Tips on command line parsing syntax
    3.1     Separation symbols
    3.2     A slash
    3.3     Percent sign
    3.4     Double quote sign ( " )
    3.5     Square brackets
4     Syntactic marks with command mission
    4.1     Colon
    4.2     Left Arrow
    4.3     Right Arrow
    4.4     Double Right Arrow
    4.5     Vertical bar (or "pipe")
    4.6     The "at" ( @ ) sign

Microsoft Excel is a deep program rich in features and functionality. One of the most powerful features of Excel is the ability to write programs in Visual Basic for Applications that run "behind" your worksheets to turn Excel into a calculation-oriented development platform for creating special purpose spreadsheets which can function as applications in their own right.

Contents

1    Service Pack
2    Macro Security
3    Macro Recording
4    Enabling Developer tab
5    Making an XLA
6    Accessing the Registry
7    Prevent Confirmation Popups In Excel
8    Making Cells Read-Only
9    Finding Non-Empty Portion of Worksheet
10    Using Events
11    Caveat: Uncaught Exceptions
12    Caveat: Online-Help Typos
13    Iterating Over MultiSelected Cells
14    Exporting VBA Code
15    Resize a Named Range
16    Creating a Named Range
17    Reading a File
18    Writing to a File
19    File Existence
20    Directories
21    Grep
22    Clipboard
23    Range
24    Worksheet
25    Searching
26    Cell Formatting
27    Color
28    Visibility
29    Hyperlink
30    Temporary file
31    Command Output
32    Dimensions
33    Comment
34    IsEmpty
35    IsNull
36    Add-Ins at Startup
37    Chart direct from VBA array data
38    Nuking Retained State
39    Related Courses

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics. In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016 from an expert.

In this course, you will learn how to import data from different sources, create mash-ups between data sources, and prepare data for analysis. After preparing the data, you will find out how business calculations can be expressed using the DAX calculation engine. Then, you will see how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.