Best practices for designing and managing worksheets
Creating formulas and functions
Performing statistical, what-if, and other data analysis
Core to advanced charting techniques
Using graphics and sparklines
Managing databases and tables
Automating Excel with macros and custom functions
Collaborating in Excel online, in the cloud, and more
Extending Excel
Microsoft Excel 2013 Inside Out
You’re beyond the basics so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Learn how the experts tackle Excel 2013 and challenge yourself to new levels of mastery. Includes companion eBook and sample files. Download eBook Free »
Microsoft Excel 2013: Building Data Models with PowerPivot
Transform your skills, data, and business and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You’ll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results no programming required!
Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI
Extend your existing data-analysis skills to create your own BI solutions
Quickly manipulate large data sets, often in millions of rows
Perform simple-to-sophisticated calculations and what-if analysis
Create complex reporting systems with data modeling and Data Analysis Expressions
Share your results effortlessly across your organization using Microsoft SharePoint
Transform your skills, data, and business and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You’ll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results no programming required! Download eBook Free »
Experience learning made easy and quickly teach yourself how to manage the complete project life cycle with Project 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you need them! Experience learning made easy and quickly teach yourself how to manage the complete project life cycle with Project 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you need them!
Work with Project 2013 on your PC or touch-enabled device
Build and fine-tune your project plan
Schedule tasks and milestones, and assign resources
Track progress and costs, and manage variances
Troubleshoot delays and budget overruns
Customize Gantt chart views, tables, and calendars
Learn project-management best practices
Experience learning made easy and quickly teach yourself how to manage the complete project life cycle with Project 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you need them! Experience learning made easy and quickly teach yourself how to manage the complete project life cycle with Project 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you need them! Download eBook Free »
Experience learning made easy and quickly teach yourself how to stay organized and stay connected using Outlook 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook. Experience learning made easy and quickly teach yourself how to stay organized and stay connected using Outlook 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook.
Set up your email and social media accounts
Send, search, filter, and organize messages
Manage one or more calendars, and share your schedule
Help protect your inbox and outbox
Create and track tasks, to-do lists, and appointments
Experience learning made easy and quickly teach yourself how to stay organized and stay connected using Outlook 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook. Experience learning made easy and quickly teach yourself how to stay organized and stay connected using Outlook 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook. Download eBook Free »
Experience learning made easy and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.
Work with Excel 2013 in touch mode
Write formulas, create macros, and organize data
Present data visually and add images to worksheets
Consolidate multiple sets of data into a single workbook
Analyze data using the Quick Analysis Lens
Collaborate with colleagues and present workbooks online
The smart way to learn Excel 2013 one step at a time!
Experience learning made easy and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook. Download eBook Free »
Experience learning made easy and quickly teach yourself how to build your own database with Access 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook.
Build a database from scratch or ready templates
Create easy-to-use data-entry forms
Write queries to extract and manipulate data
Design reports to summarize data in effective ways
Import data from other databases and documents
Experience learning made easy and quickly teach yourself how to build your own database with Access 2013. With Step by Step, you set the pace building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook. Download eBook Free »
Entries
