Do you want to get efficient and dynamic preparation for your Microsoft exam, don't you? The Microsoft certification video training course is a complete batch of instructor led self paced training which can study guide.
Build your career and exam 77-420 microsoft excel 2013 free download with Microsoft Excel certification video training course from Exam-Labs! Level exam 77-420 microsoft excel 2013 free download, Section 1 - An introduc Level 1, Section 2 - Create work Level 1, Section 3: Configure wo Level 2, Section 1: Navigate thr Level 2, Section 2: Format works Level 2, Section 3: Customise op Level 2, Section 4: Configure Ex Level 2, Section 5: Utilise cell Level 3, Section 1: Insert data Level 3, Section 2: Format cells Level 3, Section 3: Highlight an Level 3, Section 4: Summarise da Level 4, Section 3: Filtering, S Level 4, Section 4: Utilise cond Exam 77-420 microsoft excel 2013 free download 5, Section 1: Create a cha Level 5, Exam 77-420 microsoft excel 2013 free download 2: Format a cha Level 5, Section 3: Insert and f Level 5, Section 4: create and m Level 5, Section 5: Format and m Gain in-depth knowledge for passing your exam with Exam-Labs Excel certification video training course.
The most trusted and reliable name for studying and passing with VCE files which include Microsoft practice test questions and answers, study guide and exam practice test questions. Unlike any other Excel video training course for your certification exam.
Pay a fraction of the cost to study with Exam-Labs Excel certification video training course. Passing the certification exams have never been easier. With the complete self paced exam prep solution including Excel certification video training course, practice test questions and answers, exam practice test questions and study guide, you have nothing to worry about for your next certification exam.
Similar Courses See All. Please check your mailbox for a message from support exam-labs. Student Feedback 4. Creating new blank workbooks. Entering data. An introduction to fonts and highlighting. Saving and closing your workbook. Practice Activity Number 1 - The Solution. Creating new workbooks using templates. Menus and toolbars. Managing multiple workbooks - Excel and Importing files and Opening non-native files directly in Excel.
Adding worksheets to existing workbooks. Copying and moving worksheets, and changing spreadsheet order. Saving workbooks in alternate file formats. Maintaining backward compatibility. Saving files to remote locations. Using basic operators. Order of operations. How to enter numbers and dates in Excel.
Referencing cell ranges in formulas. Practice Activity Number 2 - Solution. Searching for data within a workbook. Hot Keys. Changing worksheet tab colour. Inserting and deleting columns and rows. Undo and Redo. File Management tips. Adjusting row height and column width. Hiding columns and rows. Selecting multiple ranges. Hiding worksheets. Customising the Quick Access toolbar. Customising the Ribbon.
Assigning shortcut keys. Recording simple macros. Managing macro security. Changing workbook views. Using zoom. Adding values to workbook properties.
Displaying formulas. Freezing panes. Splitting the window. Printing individual worksheets. Printing an entire workbook and printing a selection. Setting a print area. Page setup, Part 1 first two tabs. Page setup, Part 2 Repeating headers and exam 77-420 microsoft excel 2013 free download.
Adding dynamic text to headers and footers. Inserting watermarks. Page setup, Part 3 Headings etc. Configuring workbooks to print. Inspecting your workbook prior to distribution. Copying and pasting basics, and Utilising references relative, mixed, absolute. Practice Activity - multiplication table. Answer - multiplication table. Appending data to Excel worksheets. Setting data validation. Finding and replacing data.
Copying and pasting data, including Paste Special. Cutting and moving cell data. Using AutoFill tool, and Expanding data across columns. Modifying cell alignment and indentation. Wrapping text within cells. Merging cells and Shrink to Fit. Changing font and font styles. Applying highlighting. Applying Number format. Applying borders. Applying cell styles. Using Format Painter.
