Posts Tagged ‘Technology’

The Cloud and Microsoft Office 365

February 14, 2012

[tweetmeme source=LANSystems only_single=false]Guest blog by Geoff Rigsby, Microsoft Account Manager at Synnex

On a weekly basis I am asked, “What is Office 365 and how can it help me?”

For instance, if you’re running a small business with 5-10 employees, setting up your own IT infrastructure can be a monumental task.  First, you have to purchase the hardware and software like an HP Server and Windows Server 2008 software.  Second, if you want to have your own email domain, you’ll need to purchase Exchange Server software.  And if you want to share files between employees, you will need SharePoint Server software and you can’t run that without SQL Server software.  It adds up and before you know it, you’ve just spent $50,000!  In addition, you will need someone to configure and maintain.

This is a great deal of expense for just a few employees to communicate, collaborate, and work.  Here is where Office 365 is beneficial.  It eliminates the need for a large infrastructure investment and allows you to take advantage of enterprise IT tools for a fraction of the cost. Office 365 will give you the same productivity and collaboration tools delivered in a subscription based service.  It is licensed on a per-user per-month plan and allows you to scale up or down easily and as-needed.

Depending on the needs of your company, you can obtain every option; Exchange Online, Lync Online, SharePoint Online, and Office Professional Plus in a nice, neatly bundled package or as separate units.  This allows  all of your employees to easily and securely access the same information, from anywhere, anytime – whether it be on a PC, phone, or web browser. User management is made easier by using a single administration access point that allows you to set up new user accounts, control access to features, and receive status updates on all services and tools in real time.  Support is available directly through Microsoft but I recommend working with a Microsoft Partner.  Partners can help you choose the right services, provide added capabilities, and assist with the transition.  They can efficiently manage your network and provide ongoing support for Office 365 giving you more time to run your business.

Paying for Office 365 is easy!  Just work with a Partner. They will send you a quote.  Then you accept the agreement and submit your credit card information in a secure transaction.  Payments are scheduled automatically each month to the card on file.

For more information on Office 365 and how it can help your company, visit www.microsoft.com/office365 and make sure to work with a Microsoft Partner in your area.

Geoff is a Microsoft Partner Account Manager working at Synnex.  You can contact Geoff at: v-grigsb@microsoft.com

Advertisements

Talk Like a CIO

August 1, 2011

Talk Like a CIO[tweetmeme source=LANSystems only_single=false]The Chief Information Officer (CIO), sometimes called Chief Technology Officer (CTO), coined in the early 1980s is a rather recent addition to the corporate governance structure. It makes sense that the position coincided with the technology explosion as companies implemented IT to gain competitive advantage. Arguably, what was once IT competitive advantage is now essential for daily operations. Even so someone has to evaluate IT investment to be sure that it serves the organization by providing benefits at an affordable cost. Without that oversight, technology projects would be rapidly become science projects that few, other than the IT department, could understand.

No disrespect to IT folks. As an engineer, I have seen this phenomenon many times. A concept to make the organization more efficient, a product more user-friendly or automate manual tasks spirals into the depths of a techno-black hole with little hope of escape. As an engineering manager, I always put two engineers on a project as a way to get a product suitable for the end-user. Often one engineer working alone would come up with solutions too complicated for the casual user. Technical elegance usually trumps corporate benefit in the technology mind. For the company to realize a return-on-investment from any technology project, someone has to watch the ROI and that’s where the CIO is essential.

The CIO doesn’t have to be a technology expert. In fact, many of today’s top CIOs don’t have a computer science, engineering or programming background, they have a business background and leadership skills. They have learned how to apply technology to solve business problems, foster change and manage the bottom line.

Although definitions will vary, here is a short list of common terms so that you can – Ay oh whey oh, Talk like a CIO.

ROI – Return on Investment is not a uniquely CIO phrase, it is spoken freely by all C-levels and is specific to the investment efficiency required by an organization. Every company defines its payback period and specifics for an acceptable ROI. Often a technology project does not generate revenue so the ROI can be tricky to quantify. Here is where the CIO can be creative and use avoided costs or cost savings to frame the ROI discussion.

Payback Period – The amount of time that it takes to make up or payback the cost of the project. Usually used for revenue projects, but the same rules as in ROI can apply.

Technology Proposal – Whether you are developing a Request for Proposal (RFP) to bid the job or completing the job in-house, you need a proposal that has a statement of need and cost-benefit justification. The CIO is critical in ensuring that the proposal meets the organizational needs and obtains budget approval.

Cost Benefit Analysis – Exactly what the name implies, to determine if the project is worth funding. In any economic analysis, do nothing is always a choice.

Bleeding Edge Technology – Technology so new that the risk and expense is high.

State of the Art, Leading Edge (or Cutting Edge) Technology – Technology that is at the pinnacle of available solutions. It may or may not provide competitive advantage. This term can be synonymous with Bleeding Edge Technology.

Buy In – The commitment of stakeholders to support the decision.

Send me your terms and definitions that help you “Talk like a CIO.”

A Giant Leap for Quantum Computing

July 24, 2011

[tweetmeme source=LANSystems only_single=false]Today’s computers are the product of a digital revolution.  When we talk about computing, we talk about an environment of ones and zeroes that add up to all the programs, graphics and communications that we use. Often we tease, it’s just ones and zeroes but that small concept has enormous and far-reaching implications. 

In the early days of computers, there was a competition between analog and digital computing for a practical, supportable, calculating machine.  Actually, analog computers go back to ancient times and were used to calculate the position of stars and planets.  Probably the most familiar example of an analog computer is a slide rule. But as analog slide rules were replaced by digital calculators so were analog computers replaced by its digital competitor. Analog computers are powerful because they have multiple states and are not constrained by just ones and zeroes.  They can solve very complex equations. But in that power is a complicated framework not easy to mass produce.  Transistors and later solid state and integrated circuit technology made the digital computer ubiquitous.

The digital computer has a new competitor in the quantum computer. Quantum computing is not really new, the concept has been around since the 1970s, but it is a complicated structure based on quantum mechanics. Most of the work in quantum computing has been theoretical because the technology was not available to take the idea from a dream to reality. 

The recent announcement that Lockheed Martin will purchase a quantum computer from D-Wave Systems is a giant leap for this emerging technology.  Experts are already speculating on the quantum gains in computing speed as exponential and tens of thousands of times as fast as the fastest digital computer.  It is an exciting time to be a technology aficionado. It is a time when anything is possible and the universe has no limits.

Get In Touch With Your Creative Side Using Microsoft Office

February 23, 2011

[tweetmeme source=LANSystems only_single=false]Not that long ago, the only way to get high-quality, professional materials was through a graphic designer.  Printing was a complicated, expensive process that was left to the print shops.  Each project required assembling pictures, graphics and content that was camera-ready. 

Today, we have access to everything needed to make agency-quality marketing materials with full-color and amazing graphics. Brochures, mailers and newsletters can be printed on-demand or in the perfect quantity to reducing waste and keep the offering fresh.  To save more and reach the online audience, electronic files are brilliant and easy to distribute.  If you have an idea, a good eye and the right tools, you can make magic. 

Microsoft Office offers the right tools with its Office 2010 Suite of Applications.  Word, PowerPoint, Excel and Publisher provide improved and enhanced features for creating and publishing. Many of the features are cross-platform so you can learn a skill in one application and use it in another.  There are a host of classes for beginner, intermediate and advanced users that can be taken in a classroom environment or online depending on your best learning method.  Microsoft, Hewlett-Packard and others offer free, online classes that are perfect for the self-learner.

Word is the standard for creating and formatting documents of all types from simple letters to documents with a table of contents, index and glossary. It makes the task of creating and editing documents easy.  Tools like spell check and thesaurus make us look smart and polished. New and improved photo-editing tools let you transform pictures right in Word 2010 – no extra software needed. Change color saturation, temperature, brightness, and contrast to turn a simple Word document into a work of art.  Turn text into visual effects with enhanced text effects and SmartArt graphics. Change basic bullet-points into compelling visuals and add text effects like shadow, glow, reflection, and 3-D in just a few clicks.  With co-authoring, you can edit at the same time as others, even if you’re working from different locations, and keep versions in sync with version control. This is a great way to eliminate typos (ever used a there for their or your for you’re?) by having others review your work for content and correctness.

PowerPoint is not just for presentations, it also makes a great coordinating tri-fold or handout.  Use the same theme for marketing materials that you can leave with the prospect to reinforce your message and offering. Creating your presentation in PowerPoint allows you to gather all your thoughts and ideas in one tool.  You have many slide choices and can move, cut, paste and organize to create a coherent flow of information without leaving the program.  Adding graphics, diagrams, video and sound is easier than ever. 

Excel graphs, charts and sparklines explain trends and comparisons with strong visuals.  Whenever numbers are involved, visuals are powerful tools to simplify the message and give at-a-glance significance. Use sparklines to graphically display data in a single cell.  You can display data in line, column or win/loss format to highlight trends.

Publisher helps you create eye-catching brochures, newsletters, postcards, greeting cards and email messages.  With the built-in and online templates, you can find a style for any publication. The prebuilt building blocks give an assortment of page parts like sidebars, stories and columns for creating professional newsletters and case studies. Add calendars, borders and advertisement blocks for community or school newsletters. Stunning graphics and images are easily added and use OpenType typography for expert typesetting effects.

Get your creative juices flowing! Experiment with different looks and practice with different styles.  Start with a concept and use Microsoft Office 2010 to create brilliant, flawless materials for your home, school or business.

For more technical notes and information go to: www.lansystems.com/technotes.html

Clouds in an Azure Sky

January 30, 2011

[tweetmeme source=LANSystems only_single=false]Clouds are made of increased bandwidth and storage blended with the advances in virtualization and remote access. Today’s technology allows us to compute anywhere, anytime. The sky is clear blue for cloud computing, but it hasn’t always been that way. 

Cloud computing grew out of the centralized or mainframe model. For those who remember mainframes, it was the only way to compute. We had remote access, but it was cumbersome, slow and expensive. Programmers got in the habit of coding all night long when rates were the cheapest. Then those long, sleepless nights were replaced by distributed computing, a computer for everyone, but somehow programmers still program all night. 

The distributed computing model was embraced rapidly. With amazing graphics and Internet availability, the computer became a household appliance.  But distributed computing had its drawbacks, it was hard to interface disparate systems and collaborate in real-time. Recently, 100% availability and remote connections at LAN speeds have resurrected the centralized computing model with a new name. You could say that computing has come full circle back to a centralized computing model that we call Cloud Computing.  It is provocative, exciting and revolutionary. 

New technology holds a dilemma as most computer users don’t really care about the technology; they just want it to work easily and reliability.  And business owners are only slightly interested in the merits of a distributed or centralized computer model. They want computer systems that are economical, productive and work without needing a staff of IT gurus. 

The cloud or hosted computer solution (called ASP, SaaS, Cloud Services) has been around for years, but has enjoyed only limited success.  Most of the early adopters had sophisticated IT experience and the trained staff to develop and manage cloud solutions. Today, even popular hosted applications have reduced features online or make it difficult to migrate out of the cloud. Microsoft has addressed these issues with Azure.  It is powerful enough to host your world-class enterprise datacenter with the reliability, efficiency and agility you demand, yet provides simple, scalable, portable services. 

Microsoft Azure supports three roles: Web role, Worker role and a Virtual Machine (VM) role.  Enhancements are planned for the Web and Worker roles that have been used by many companies for programming and development. The new VM role will provide a generic environment that can be used for test or production.  It will also compete with Google and Amazon offerings. Learn more about Microsoft Azure and Cloud Power.

Azure SQL provides high-availability, fault tolerant relational database services in the cloud. You can serve local or cloud-based applications and only pay for what you use. Administration is simplified. You don’t have to install, setup, patch or manage software. Built on SQL Server you can leverage the same development and management tools used locally. Learn more with SQL Azure videos.

Azure has great appeal to programmers and developers as is evidenced in the keynote and sessions at PDC10, but for users the cloud is still a confusing concept. Perhaps the average user will never really understand or be awed by the technology that fuels cloud computing, but it will be widely used because of its economy and availability. 

Cloud computing will enjoy widespread use until the next technology revolution replaces it with another better, faster and less expensive solution. Who knows what that might be, but it might look a little like distributed computing.

For more technical notes and information go to: www.lansystems.com/technotes.html

Black Friday and Cyber Monday

December 2, 2010

[tweetmeme source=LANSystems only_single=false]This year just about every retailer is using the term Black Friday and Cyber Monday to advertise their special “specials” and grab the attention of holiday shoppers.  Those seem strange terms, not very glamorous or even illustrative of a bargain.  In fact, they sound more like viruses and cyborg attacks out of a sci-fi movie.  So why have they caught on? 

Used to describe sinister or catastrophic events occurring on a particular day of the week, Black Friday has been used for everything from massacres to meltdowns.  Today, we most often use the term for shopping the day after Thanksgiving.  Coined in the late 1960s by the Philadelphia police because of the choking traffic and crowds, the moniker caught on and by the mid-1970s was being widely used.  Later the term Black Friday was redefined to mean the day that retailers become profitable or put some black ink on the ledger. It is an urban legend that Black Friday is the biggest shopping day of the year.  Actually the Saturday before Christmas handily wins as the top shopping day fueled by procrastinators and bargain hunters alike. But Black Friday has risen as a contender most likely because of all the hype and ads promoting the day. 

Cyber Monday invented by shop.org (that’s a dead give-a-way) as the Monday after Black Friday where all the returning workers shop online for the bargains they missed over the weekend.  This does have negative connotations in that people are spending otherwise productive time shopping at work and that they don’t have the ability to shop at home. Both of these facts are probably widely exaggerated especially with Cyber Sunday overtaking Cyber Monday as the biggest online shopping day.   But there is no doubt that online shopping is deeply rooted in our shopping psyche especially if free shipping applies. 

We all love a bargain especially as we go into the holiday shopping season.  Our habits as consumers are researched, analyzed and baked into marketing strategies that grab even the most resistant shopper. Successful marketing campaigns are the stuff of legend giving the next generation of business school graduates an idea to admire and study for years to come.  Whether highly orchestrated or completely accidental, Black Friday and Cyber Monday are here to stay at least for a while.

 But it’s not bad to see consumers spend money. It could help our anemic economy and put us all in a festive mood.   Early indications say there might even be a 3% increase over last year’s holiday sales.  So shop in earnest, virtually and physically, but always beware of deals that are too good to be true!

If you have suggestions or comments, please contact me at: mary@lansystems.com.

For more technical notes and information go to: www.lansystems.com/technotes.html

Large or dual monitors mean happier, more productive employees

September 26, 2010

[tweetmeme source=”LANSystems” only_single=false]The NEC commissioned University of Utah study shows increased productivity, job satisfaction and an incredible return on investment. It is not surprising that a monitor manufacturer would recommend larger and multiple monitor arrangements, but what do users think? There are two trends. The first is for smaller, lighter, mobile devices for on-the-go professionals and the second is for more screen real estate for the stationary worker.

On-the-go professionals need access from anywhere, anytime so they can stay connected.  The screen sizes of mobile devices are definitely trending up, but in general they are still much, much smaller than desktop monitors.  Most mobile users don’t need multiple windows. They can switch between applications or use tools to work more efficiently. Mobile devices are great for staying connected and having information at your fingertips.  They are not efficient for programming that requires in-depth analysis or complicated tasks.  Many types of IT systems do not allow access or control from a mobile device because of the chance of errors and security concerns.

Stationary users benefit from larger or dual monitors depending on the work they do on the computer.  If a user has two or more applications that they cut-and-paste between, dual monitors are a great for increased productivity and error reduction. You don’t have to stop with a dual arrangement.  Triple and quad monitors are used in many situations, like control monitoring, that give the user needed information at a glance without having to switch between windows.  But size does become a diminishing return and if the monitor is too big it can be a productivity drain.  The NEC report shows single 26 inch and dual 20 inch as the upper limit.

Desk space is important.  With flat panel monitors, desk space is not a problem as with CRTs.  Usually you can comfortably place two monitors or a larger monitor on a desk without obscuring view.  If you want to be accessible to your customers, co-workers and employees, don’t sit with your back to the door or with a monitor hiding your face.

There is a good bit of research on monitors and productivity that you can use. Read the NEC Study or do some Internet research for more suggestions on how to be more productive with your computer monitors.  Make a list of what tasks cause you and your staff the most irritation and solve them first. 

If you have suggestions or comments, please contact me at: mary@lansystems.com.

For more technical notes and information go to: www.lansystems.com/technotes.html

Microsoft Office 2010: The best new features in PowerPoint

September 10, 2010

[tweetmeme source=”LANSystems” only_single=false]For anyone that has ever presented to a group, you know it is essential to be well prepared and have the right props.  For many, PowerPoint is the prop of choice. 

Creating your presentation in PowerPoint allows you to gather all your thoughts and ideas in one tool.  You have many slide choices and can move, cut, paste and organize to create a coherent flow of information without leaving the program.  Adding graphics, diagrams, video and sound is easier than ever. With just a little time investment, PowerPoint will make you look like a presentation guru!

When creating the perfect presentation, be sure not make your slides too busy or add too much glitz.  If you want to use sound and video, make sure to add at a place in your presentation where it will complement your message.  Video can be a great introduction or it can be used to clarify your points.  Don’t use sound or video in parts of your presentation where you need the attention of the audience.  Don’t let text dominate your presentation.  Use pictures and graphics liberally as people remember points made through visuals much better than they remember words.

Create interesting presentations

Use built in video power tools – Create extraordinary presentations by embedding video that was created using tools that give a professional multimedia experience.  You can fade, add formatting effects, bookmark scenes, and trim your videos with ease.  Sharing is easy because the embedded video is part of the PowerPoint presentation. You only have to share one file.

Embedded videos can now become part of your PowerPoint presentation

Picture editing made easy – Use new and improved picture editing tools—including versatile artistic effects and advanced correction, color, and cropping tools—to fine-tune every picture in your presentation to look its absolute best.

Built in graphic effects – You don’t have to be a design expert to create professional-looking graphics. Use dozens of additional SmartArt® layouts to create organization charts, lists, and picture diagrams. Transform words into impressive visuals that better illustrate your ideas. Create diagrams as easily as typing a bulleted list or convert text and images to a diagram in just a few clicks. All the tools you need to create stunning graphics are built into PowerPoint.     

PowerPoint 2010 SmartArt Example

3-D transitions and improved animations -PowerPoint 2010 offers new, dynamic slide transitions and animation effects that look similar to graphics you’d see on TV. Easily access, preview, apply, customize, and replace animations. You can also use the new Animation Painter to easily copy animations from one object to another.

Quick and easy presentation management 

Microsoft Office Backstage view – This is the tool palette you see when you select File. This is where you manage your files and the data about them — creating, saving, inspecting for hidden metadata or personal information, and setting options. In short, it is everything that you do to a file that you don’t do in the file.

Compress video and audio – Select File and then Info to compress video and audio in your presentation.  This reduces the file size and can increase playback performance.  Select the quality option from the drop-down choices.

The option to compress media is one of many new features available from the new Backstage view

Customize the Ribbon – Use customizations to personalize the ribbon the way that you want it. For example, you can create custom tabs and custom groups to contain your frequently used commands.  Note:Ribbon customization is specific to the Microsoft Office program you are working in at the time. Ribbon customization does not apply across the Office programs.

Work together from anywhere

Live broadcast – Broadcast your slide show to people in other locations, whether or not they have PowerPoint installed. Create a video of your presentation—including your transitions, animations, narration, and timings—to share with virtually anyone, any time after your live broadcast.

You can broadcast your slide show to people remotely, whether or not they have PowerPoint installed

Microsoft PowerPoint Web App is an online companion to Microsoft PowerPoint which enables you to extend your PowerPoint experience to the browser. View a high fidelity version of your presentations, make light edits, or view your presentation slide show. Use the familiar PowerPoint interface and some of the same formatting and editing tools, from almost any computer with a Web browser.

Microsoft PowerPoint Mobile 2010 enables you to do light editing for your presentations and is especially designed for easy use on your Windows phone. You can even run your slide show right on your phone.

For more technical notes and information go to: www.lansystems.com/technotes.html 

If you have any questions or need help with the instructions, email me at: mary@lansystems.com.

Microsoft Office 2010: The best new features in Access

August 22, 2010

[tweetmeme source=”LANSystems” only_single=false]If you have never used a relational database because you felt it was just too complicated, give a look at Access.  Access 2010 has simplified database functions and added ready-to-go templates to get you started. Information stored in spreadsheets and documents can be easier to understand and less time consuming to manage in a relational database model.  Not only can you save time, but you can make your data more meaningful and perform more meaningful analysis.  And if you are using a product that uses Access to store your data, you will be able to better understand the tables, reports and relationships.

Fast, easy database creation

Ready-to-go Templates – Use the available templates to create a marketing list or sales pipeline without being a database expert.  The templates are designed to give you the structure you need to get started and let you expand as you become more familiar with using Access.

Use modular components – These prebuilt components allow you to build the most common tasks into your database.  Go to Create – Application Parts after making your selection, the wizard will guide you through the setup and make your choices obvious.  There are on-demand help videos that explain how to use Access. The videos are surprisingly easy to follow with clear language and demos that take you through the screens step-by-step.

  Application Parts provide modular components for your Access databases 

Forms and reports with realistic, targeted analysis  

Conditional formatting – Use data bars to manage your rules and create professional reports that are understandable and informative. Rather than trying to “crowbar” your data into available formats, you can customize the presentation and make your data mean more to organization.  Stay focused at your sales and marketing meetings by using reports that everyone will recognize and appreciate.

Conditional formatting now supports data bars 

Office themes – Choose themes with fonts, colors and designs that match your other Microsoft Office products that demonstrate consistency and branding.

Backstage – The Microsoft Office Backstage view replaces the traditional file menu with an ergonomic approach that uses In and Out features for efficiency.  The improved Ribbon lets you access your favorite commands quickly and create custom tabs to personalize the way you work.

Developer quality without writing code

Expression Builder – Enhanced functionality with IntelliSense to greatly simplify formula and expression building. With these intuitive tools you will spend less time troubleshooting relationship errors and more time building a valuable database.

Make your databases available on the Internet with new Web databases 

Macro Designer – Add basic logic to your database, quickly and easily even if you are not familiar with databases. If you’re an experienced Access user, you’ll find the enhancements allow you to use the complex logic move efficiently than ever. Extend your database application with increased performance and confidence.

The revamped Macro Designer makes easier for you to add basic logic to your database

Work from anywhere

Online – Post your database online and then access, view, and edit them from the Web. Users without an Access client can open Web forms and reports via a browser and their changes are automatically synchronized.

You acn post your databases online and then access, view, and edit them from the Web

For organizations of all types and sizes, Access 2010 allows you to be more productive, flexible and cost-effective. You can combine tasks in Access that previously required several programs and labor intensive analysis to make better decisions for your business.

For more technical notes and information go to: www.lansystems.com/technotes.html 

If you have any questions or need help with the instructions, email me at: mary@lansystems.com.

Microsoft Office 2010: The best new features in Excel

August 2, 2010

[tweetmeme source=”LANSystems” only_single=false]Excel is arguably the most under-utilized Microsoft Office product when it comes to advanced features.  Ask people what features they most like in Excel and they usually describe the spreadsheet and graphing tools.  But that is just a very small part of the capabilities built into Excel.  From tools for statistical, engineering and financial functions, to pivot tables, to Visual Basic for Applications (VBA) programming, you can use Excel for simple to complex data analysis and display with easy to read graphs and charts. 

If you haven’t used the advanced tools in Excel, start by trying the new features to get the most from your software investment. Analyze your data to discover patterns or trends, then display with graphs and charts that illuminate the best course of action.  With a little practice, you will improve your ability to study large data sets and make the most informed decisions. 

Make fast, effective comparisons 

Sparklines – Use sparklines to graphically display data in a single cell.  You can display data in line, column or win/loss format to highlight trends. On the Insert tab, choose the type of Sparkline and your data range.  Customize your sparklines for optimum effect by selecting the sparkline and choosing the Design tab. 

 

 

 

 

  

Slicer – Slicers are filtering components that allow you to slice-and-dice your data without having to open drop down lists.  Slicers make it easier to segment and filter data in PivotTables for high powered business intelligence. 

Step up your analysis

  

Search Filter – Use the new Search Filter to quickly and easily narrow your search in tables, PivotTable, and PivotChart views. You can instantly sort through a million or more items.

  

PowerPivot (formerly called Project “Gemini”) Add-In – Groundbreaking technology that allows you streamlined integration of data from multiple sources and lightning-fast manipulation of large data sets with up to millions of rows. Effortlessly publish and share analysis through Microsoft SharePoint Server 2010 and have other users enjoy the same Slicer and fast-query capabilities when working on their Excel Services report.

 

 

 

Backstage – The Microsoft Office Backstage view replaces the traditional file menu with an ergonomic approach that uses In and Out features for efficiency.  The improved Ribbon lets you access your favorite commands quickly and create custom tabs to personalize the way you work.

 

Jazz up your data presentations

Conditional Formatting – Excel 2010 adds sophistication to conditional formatting.  Give your document a professional look by adding eye-catching formats.  You have more choices and control over styles and icons, improved data bars, and the ability to highlight specific items in a few clicks. You can also display data bars for negative values and use color for effect.

Work from anywhere

Online – Post your spreadsheets online and work on them from virtually anywhere from the Web or your Windows Mobile-based Smartphone. With Excel 2010, you can take advantage of a best-in-class spreadsheet experience across multiple locations and devices.

Excel Web App – Extend your Office experience to the Web, and view and edit your spreadsheets through the Excel Web App when you’re away.

Excel Mobile 2010 – Stay up-to-the-minute and communicate on-demand by using a mobile version of Excel specifically suited to your Smartphone.

For other interesting features and functions, try Goal Seek to give you a what-if analysis to test your scenarios, experiment with linear regression to understand relationships in your data or just play with the new formatting tools. But once you uncover the “hidden” features in Excel, you will be enthusiastically hooked.

For more technical notes and information go to: www.lansystems.com/technotes.html 

If you have any questions or need help with the instructions, email me at: mary@lansystems.com.