Use Goal Seek to Perform What-if Analysis Use Date &Time Functions and Freeze Panes Use CountIF and IF Functions and Apply Conditional Formatting Use the Sum Button to Sum a Range of Cellsįormat Cells with Merge & Center, Cell Styles, and ThemesĬhart Data to Create a Column Chart & Insert Sparklines MOS Prep - Basic Certification Exam Practice Study Guide

Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas How do you Export Access to Excel and Apply Conditional Formatting Insert Page Numbers Starting from a Specific PageĬreate, Save, and Navigate an Excel Workbook Use Continuous Section Breaks for Page Layout Reorganize Document Text Using the Navigation PaneĬollapse and Expand Body Text in a Document Review Document Headings in the Navigation Pane Microsoft Office Specialist Certification Exam Practice Study Guide Plan the Organization of Files and Folders Use File Explorer to Access OneDrive and Upload Student Data FilesĮxplore the Control Panel and the Settings App Here is a full list of tutorial videos available on my channel:Įxplore the Windows 10 Desktop, Taskbar, and Start Menu This tutorial is for beginners who want to learn more about Microsoft Word, I hope it helps you out. You can specify which page in your Office 365 documents that you'd like to automatically place headers and footers in, and the page that displays when you insert this. This tutorial shows you how to insert page numbers from a specific page on Word 2016.

Linking text boxes in word 2013