Will Windows 10’s universal apps make Office 2016 the suite we’ve been waiting for? Recent coverage of Windows 10 has left many a computer geek ruminating about the shortfalls of the current Windows operating system. Not only did the Windows 8 OS upgrade leave us wanting but (even though it wasn’t technically part of the update) so did mobile versions of Office. Those of us looking forward to manipulating Word, PowerPoint, Excel, Outlook, and OneNote across computers, tablets and smartphones were left disappointed.

A lot of hoopla was made over the “metro style” flat and less-cluttered interfaces, and yes the new apps were attractive; their design matched the new Windows 8 touch overlay, for the most part. However, as was the case with the latest Windows itself, while the mobile Office app’s interfaces looked good, the apps weren’t all that robust on mobile devices, and their touch capabilities were lacking. You can’t even swipe your finger to select a group of cells or a block of text in Excel or Word!

This time, though, the new mobile Office apps will be “universal,” in that the code will work across multiple devices, and they will be available for free on smartphones and small tablets. What does that mean for Windows and Office users?

Read the entire article at Digital Trends.

 

Share

Introduction to ExcelOne of the very first personal computer (PC) applications was the spreadsheet, and one of the first spreadsheet creation and editing programs was Microsoft Excel. Nowadays, Excel comes preinstalled on nearly every new Windows machine—PC, tablet, and smartphone—which constitutes about 90 percent of today’s computing device market, and a huge majority of businesses use Excel in one capacity or another.

Increase you viability in the workforce, learn to use Excel. Upon completion of this course, you will understand the basics (and more) of creating spreadsheets, as well as several advanced data manipulation concepts—to prepare you for using Excel in today’s business environment, which will in turn make you a much more valuable employee (or perspective employee).

Here’s the syllabus:

Week 1: Introducing Microsoft Excel

  • Using Excel 2013 Locally or Excel 365 in the Cloud
  • The Almighty Spreadsheet
  • Working with Workbooks
  • Working with Multiple Windows & Views
  • Anatomy of a Spreadsheet – Cells, Columns, & Rows
  • Types of Data Excel Supports
  • Entering Data
  • Data Entering Shortcuts
  • Importing Data
  • Moving, Inserting, & Replacing Data
Week 2: Formatting Spreadsheets
  • Displaying Data Effectively
  • Design, Layout, & Format
  • Freeze Panes & Other Neat Tricks
  • Using Predefined Designs & Templates
  • Headers and Labels
  • Borders and Shading
  • Formatting Columns
  • Formatting Rows
  • Formatting Cells
  • Wrap & Merge
  • Reformatting Worksheets
Week 3: Manipulating Data
  • Manipulating Data in Excel – An Overview
  • Sorting Data
  • Data Validation & Consolidation
  • Working with Formulas
  • What-If Analysis
  • Error Checking
  • Automating with Macros
Week 4: Displaying Data Visually
  • Charting Data – An Overview
  • Using the Right Chart or Graph for Your Data
  • Charting Your Data
  • Titles, Legends, Labels, & So On
  • Reformatting Your Charts
  • Deploying Your Data & Charts in Word
  • Deploying Your Data & Charts in PowerPoint
  • Data & Charts in Portable Electronic Documents
  • Inserting Images & Shapes
  • Review Mode & Comments
  • Working with Your Team in the Cloud
  • Printing Your Workbooks
Share