Step up your Excel skills with our 6-page laminated guide focusing on tips and tricks for using data efficiently while ensuring data quality. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. This is the second in the Excel 2016 series. Suggested uses: Workplace -- Kept conveniently at your desk for easy reference; Company Training -- reduce help-desk calls and keep productivity flowing for a team or for your entire company; Students/Teachers/Parents -- help for classroom or homework; College Professors/Students -- offers a range of guides for different levels.

Develop the Excel skills that you need to produce spreadsheet solutions to your business needs - instantly! There are an estimated 400 million Excel users, but the majority of them haven't worked out a way to effectively use Excel VBA (Visual Basic for Applications). This book is for those that use Excel at work and who want to use the advanced features of Excel but don't have the time to have extensive training. It takes you through each task (as all Brilliant books do) and describes everything you could want to find out, for example: - how to use the macro recorder - how to take that recorded code and turn it into something useful that will really help you day to day - how to automate reports and design applications Users will then improve their Excel skills so they can in the end save a lot of time and get more done. Brilliantguides allow you to find the info you need quickly, easily and without fuss. It guides you through all the tasks using a highly visual, step-by-step approach - providing exactly what you need to know when you need it.

The quick way to learn popular Microsoft 365 apps! This is learning made easy. Get more done quickly with Microsoft Word, Excel, PowerPoint, and Outlook. Jump in wherever you need answers-brisk lessons and detailed screenshots show you exactly what to do, step by step. * Discover new time-savers and usability improvements for Word, Excel, PowerPoint, and Outlook * Format and organize high-impact documents and use Word's enhanced coauthoring tools * Build powerful, reliable Excel worksheets and analyze complex data sets * Prepare highly effective presentations with PowerPoint's newest visual tools * Improve your productivity with Outlook email, scheduling, and contacts * Make the most of the latest Accessibility Checker and other new features * Look up just the tasks and lessons you need Download your Step by Step practice files at: MicrosoftPressStore.com/MSOfficeSBS365/downloads

The quick way to learn Microsoft Excel! This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answers-brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for effective visual impact Perform calculations and find and correct errors Manage, filter, summarize, validate, reorder, and combine data Identify trends, illustrate processes and relationships, and dynamically analyze data Build sophisticated forecasts, key performance indicators (KPIs), and timelines Visualize data with customized charts, 3D maps, and other powerful tools Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query Use powerful Excel Data Models for advanced business intelligence

The quick way to learn Microsoft Excel 2019!

This is learning made easy. Get more done quickly with Excel 2019. Jump in wherever you need answers--brisk lessons and many screen shots show you exactly what to do, step by step.

Quickly set up workbooks, enter data, and format it for easier viewing

•Perform calculations and find and correct errors

•Filter, sort, summarize, and combine data

•Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver

•Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps

•Build data models and use them in business intelligence analyses

•Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps

•Look up just the tasks and lessons you nee

Now in full color, with easy lessons for essential tasks, big full-color visuals and skill-building practice files, this is the quick way to learn Excel! This is learning made easy.

Get productive fast with Excel 2016 and jump in wherever you need answers--brisk lessons and colorful screen shots show you exactly what to do, step by step.

• Work with Excel 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
• Create appealing charts and graphs and summarize with Sparklines
• 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. Discover how to: 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

This is learning made easy. Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step.

• Covers Word, Excel, PowerPoint and Outlook

• Format Word documents for maximum visual impact

• Build powerful, reliable Excel workbooks for analysis and reporting

• Prepare highly effective PowerPoint presentations

• Use Outlook to organize your email, calendar, and contacts

• Includes downloadable practice files

Now in full color! This is learning made easy. Get more done quickly with Office 2016. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook Includes Office 365 subscription information Discover how to use cloud storage with OneDrive and your Office 365 subscription Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files